Sajjadiii1.1 arbitrum Polygon Block Performance
    Updated 2022-07-26
    with list as (select a.block_number,
    b.block_timestamp,
    count(a.tx_hash) over (partition by a.block_number) as block_count
    from arbitrum.core.fact_transactions a
    join arbitrum.core.fact_blocks b
    on a.block_number = b.block_number
    where a.block_timestamp::date >='2022-07-15'
    and a.block_timestamp = b.block_timestamp

    )

    select round(avg(block_count),3) as "average block transactions "
    , round(max(block_count),3) as "max block transactions"
    , round(min(block_count),3) as "min block transactions"
    from list

    Run a query to Download Data