DATE_TRUNC('day', block_timestamp) AS block_date,

AVG(tx_count) AS avg_transactions_per_block

flow.core.fact_blocks

GROUP BY

block_date

ORDER BY

block_date;