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