DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR) AS month,

SUM(transaction_count) AS monthly_transactions

FROM aleo.stats.ez_core_metrics_hourly

WHERE BLOCK_TIMESTAMP_HOUR BETWEEN '2022-01-01' AND '2024-12-31 23:59:59'

GROUP BY 1

ORDER BY 1;