SELECT HOUR, PRICE, LAG(PRICE) OVER (ORDER BY HOUR) AS PREVIOUS_PRICE

FROM bitcoin.price.ez_hourly_token_prices

WHERE HOUR >= '2024-02-01 00:00:00' AND HOUR < '2024-03-01 00:00:00'

SELECT HOUR,

CASE WHEN PRICE > PREVIOUS_PRICE THEN 'Increase'

WHEN PRICE < PREVIOUS_PRICE THEN 'Decrease'

ELSE 'No Change' END AS PRICE_CHANGE_CATEGORY

FROM Lagged_Prices

ORDER BY HOUR;