bachiavalanche5
    Updated 2023-04-13
    select date(block_timestamp) as day, sum(tx_count) as tot_txn_count, round((sum(tx_count))/(24 * 60 * 60),2) as txns_per_sec
    from avalanche.core.fact_blocks
    group by day
    order by day desc
    Run a query to Download Data