nitsTransaction Estimatrion
    Updated 2022-09-11
    SELECT date(block_timestamp) as day, count(DISTINCT block_number) as total_blocks,
    sum(tx_count) as total_txs, total_txs/total_blocks as txs_per_block,
    avg(txs_per_block) over (order by day) as avg_txs_per_block
    from ethereum.core.fact_blocks
    GROUP by 1
    -- limit 200
    Run a query to Download Data