SUM(TRANSACTION_COUNT) AS total_transactions

FROM

cosmos.stats.ez_core_metrics_hourly

WHERE

EXTRACT(MONTH FROM BLOCK_TIMESTAMP_HOUR) = 9

AND EXTRACT(YEAR FROM BLOCK_TIMESTAMP_HOUR) = EXTRACT(YEAR FROM CURRENT_DATE);