ZKROLL UP BATTLE

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

More from SpuriousDragon

Cover image for Forget Market Cap — Here’s the Real Size of BTC, ETH & SOL

SpuriousDragon

Nov 24

Forget Market Cap — Here’s the Real Size of BTC, ETH & SOL

Exchange-liquidity data sourced from CoinGlass (https://coinglass.com/).

Cover image for "Simon Tadros": A Lebanese Tech Entrepreneur's Harrowing Journey Through Belgian Justice: The Untold…

SpuriousDragon

Jun 5

"Simon Tadros": A Lebanese Tech Entrepreneur's Harrowing Journey Through Belgian Justice: The Untold…

There is no crueler tyranny than that which is perpetuated under the shield of law and in the name of justice." ~ Baron de Montesquieu NIHDay 764 …ArabnetMy name is Simon Tadros, a Lebanese serial crypto entrepreneur and layer 2 engineer, and I have endured numerous injustices and unfair treatment on Belgian soil. In this blog post, I aim to shed light on the profound challenges I have faced and the inhuman conditions imposed upon me. From my unjust detention to the deprivation of my basic hu...

SpuriousDragon

Jan 6

ETHIQ AIRDROP

How to Earn Your Share of the $500,000 USDC + 50,000,000 $ETHIQ Reward ETHIQ’s Proof of Solidarity Airdrop is officially live.

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
)