Hour,

AVG(Price) AS BTC_price

FROM bitcoin.price.ez_hourly_token_prices

WHERE hour >= '2023-12-01' AND hour < CURRENT_DATE

GROUP BY 1

ORDER BY 1 DESC