banbannardAvalanche vs Near
    Updated 2022-07-20
    with base as (select date_trunc('minute', block_timestamp) as minute,
    count(distinct(tx_hash)) as count_tx
    from avalanche.core.fact_transactions
    group by 1),

    base2 as (select date_trunc('hour',minute) as day,
    count_tx
    from base)

    select avg(count_tx) as "TPM by Hour",
    'Average TPM by Hour' as "Min, Avg and Max"
    from base2
    union
    select max(count_tx),
    'Max TPM by Hour'
    from base2
    union
    select min(count_tx),
    'Min TPM by Hour'
    from base2
    order by 1 asc
    Run a query to Download Data