YEAR(HOUR) AS halving_year,

AVG(PRICE) AS avg_price

FROM

bitcoin.price.ez_hourly_token_prices

GROUP BY

halving_year;