# ZKROLL UP BATTLE

**Published by:** [SpuriousDragon](https://paragraph.com/@tadros/)
**Published on:** 2022-11-11
**URL:** https://paragraph.com/@tadros/zkroll-up-battle

## Content

http://dune.com is an online solution that anyone can create SQL queries on blockchain data for free. The results are visualized as charts. In this example i compare zksync vs arbitrum vs optimism vs polygon by size of daily depositor you can find the sql query at https://dune.com/queries/1493205 Code Sample :with zksync_summary as ( with depositors as (SELECT date, count(USER) AS deposits FROM (SELECT min(date) AS date, account AS USER FROM (SELECT date_trunc('day', min(evt_block_time)) AS date, "from" AS account FROM erc20."ERC20_evt_Transfer" where ( "to" = '\xaBEA9132b05A70803a4E85094fD0e1800777fBEF' ) and evt_block_time >'2020-06-01' and evt_block_time >= now() - interval '{{in _ days}} days' -- AND evt_block_time >= '{{date}}' -- AND evt_block_time < (DATE_TRUNC('day',CURRENT_TIMESTAMP)) GROUP BY 2) AS a GROUP BY 2) AS b GROUP BY 1 ORDER BY 1), depositors_eth as (SELECT date, count(USER) AS deposits_eth FROM (SELECT min(date) AS date, account AS USER FROM (SELECT date_trunc('day', min(block_time)) AS date, "from" AS account FROM ethereum.transactions WHERE ("to" = '\xaBEA9132b05A70803a4E85094fD0e1800777fBEF' ) and block_time >'2020-06-01' and block_time >= now() - interval '{{in _ days}} days' -- AND evt_block_time >= '{{date}}' -- AND evt_block_time < (DATE_TRUNC('day',CURRENT_TIMESTAMP)) GROUP BY 2) AS a GROUP BY 2) AS b GROUP BY 1 ORDER BY 1), bridge_interactions as ( select COALESCE(depositors.date, depositors_eth.date) AS "date", deposits+deposits_eth as total_deposits, sum(deposits+deposits_eth) over (order by depositors.date) as cumlative_deposits from depositors FULL OUTER JOIN depositors_eth on depositors_eth.date = depositors.date ) SELECT 'zksync' as bridge_name, * FROM bridge_interactions order by date DESC ) You can Find the comparison here but setting the duration by day and query the blockchain . https://dune.com/spuriousdragon/zkrollups Dune is the best product to query the blockchain it gives u the ability to visualize nfts defi bridges lending platforms on multiple chain . it a must try powerfull product

## Publication Information

- [SpuriousDragon](https://paragraph.com/@tadros/): Publication homepage
- [All Posts](https://paragraph.com/@tadros/): More posts from this publication
- [RSS Feed](https://api.paragraph.com/blogs/rss/@tadros): Subscribe to updates