banbannardArbitrum Performance
    Updated 2022-07-24
    with base as (select block_number,
    count(distinct(tx_hash)) as count_tx
    from arbitrum.core.fact_transactions
    group by 1)

    select avg(count_tx) as "Transaction per Block",
    'Average TX per Block' as "Min, Avg and Max"
    from base
    union
    select max(count_tx),
    'Max TX per Block'
    from base
    union
    select min(count_tx),
    'Min TX per Block'
    from base
    order by 1 asc
    Run a query to Download Data