DATE_TRUNC('hour', hour) AS hour,

AVG(price) AS avg_yearly_price

FROM

bitcoin.price.ez_prices_hourly

WHERE

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

GROUP BY

DATE_TRUNC('hour', hour)

ORDER BY

hour;