DATE(hour) AS volume_date,

SUM(price) AS daily_volume

FROM

near.price.ez_prices_hourly

WHERE

DATE(hour) >= '2024-10-01'

AND DATE(hour) < '2024-11-14'

GROUP BY

volume_date

ORDER BY

volume_date;