SUM(TOTAL_FEES_USD) AS total_transaction_fees_usd

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);