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