SUM(price) AS total_volume

FROM

near.price.ez_prices_hourly

WHERE

date(HOUR) >= '2024-09-01'

AND date(HOUR) < '2024-10-01'