flipside

    2.3 number of transactions per block in each day
    ZSaed2.3 number of transactions per block in each day
    Updated 2022-11-09
    select
    BLOCK_TIMESTAMP::date as day,
    sum( TX_COUNT)/count( DISTINCT BLOCK_NUMBER) as AVG_PER_BOLCK,
    count( DISTINCT BLOCK_NUMBER) as bolck_per_day
    from optimism.core.fact_blocks
    where day < '2022-11-01'
    GROUP by day
    Run a query to Download Data