SUM(transaction_count) AS total_transactions,

SUM(transaction_count_success) AS successful_transactions,

SUM(transaction_count_failed) AS failed_transactions

FROM aleo.stats.ez_core_metrics_hourly

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