0xaimanTPS by Block
    Updated 2022-06-27
    select block_number::string , avg(n_txn) as tps_per_block
    from (select block_number, date_trunc('second',block_timestamp) as second, count(tx_hash) as n_txn from avalanche.core.fact_transactions

    group by 1,2 )

    group by 1 order by 1


    Run a query to Download Data