DAY(BLOCK_TIMESTAMP_HOUR) AS day,

SUM(TOTAL_FEES_NATIVE) AS total_fees_native,

SUM(TOTAL_FEES_USD) AS total_fees_usd

FROM sei.stats.ez_core_metrics_hourly

WHERE BLOCK_TIMESTAMP_HOUR >= '2024-10-01'

AND BLOCK_TIMESTAMP_HOUR < '2024-11-01'

GROUP BY day

ORDER BY day;