DATE_TRUNC('day', hour) AS day,

AVG(price) AS avg_yearly_price

FROM

bitcoin.price.ez_prices_hourly

WHERE

hour >= '2024-10-01' AND hour < '2024-11-04'

GROUP BY

DATE_TRUNC('day', hour)

ORDER BY

day;