# ZKROLL UP BATTLE

By [SpuriousDragon](https://paragraph.com/@tadros) · 2022-11-11

---

[http://dune.com](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](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](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

---

*Originally published on [SpuriousDragon](https://paragraph.com/@tadros/zkroll-up-battle)*