0xaimanBlock Generated per Year on Ethereum
    Updated 2022-07-22


    select year, count(block_number), min(n_txn) as min_txn, max(n_txn) as max_txn, avg(n_txn) as avg_txn,
    min(gas_used) as min_gas, max(gas_used) as max_gas, avg(gas_used) as avg_gas
    from (select date_trunc('year',block_timestamp) as year, block_number, count(tx_hash) as n_txn, sum(gas_used) as gas_used
    from ethereum.core.fact_transactions
    group by 1,2 order by 1)
    group by 1
    Run a query to Download Data