SELECT

HOUR,

PRICE

FROM

bitcoin.price.ez_hourly_token_prices

WHERE

EXTRACT(YEAR FROM HOUR) = 2024

),

last_year_prices AS (

SELECT

HOUR,

PRICE AS PRICE_LAST_YEAR

FROM

bitcoin.price.ez_hourly_token_prices

WHERE

EXTRACT(YEAR FROM HOUR) = 2023

SELECT

a.HOUR AS now_date,

a.PRICE As THIS_YEAR,

b.PRICE_LAST_YEAR AS LAST_YEAR,

((a.PRICE - b.PRICE_LAST_YEAR)/b.PRICE_LAST_YEAR)*100 as YoY_Chg

FROM

current_prices a

LEFT JOIN

last_year_prices b

ON

EXTRACT(MONTH FROM a.HOUR) = EXTRACT(MONTH FROM b.HOUR)

AND EXTRACT(DAY FROM a.HOUR) = EXTRACT(DAY FROM b.HOUR)

AND EXTRACT(HOUR FROM a.HOUR) = EXTRACT(HOUR FROM b.HOUR)

ORDER BY

a.HOUR DESC;