DATE_TRUNC('week', hour) AS volume_week,

SUM(price) AS weekly_volume

FROM

near.price.ez_prices_hourly

WHERE

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

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

GROUP BY

volume_week

ORDER BY

volume_week;