wanlinQuery BTC price
    Updated 2024-04-02
    -- forked from gigiokoba / PRICE_CHANGE BY HOUR @ https://flipsidecrypto.xyz/gigiokoba/q/uOw9rRSeVPAn/price_change-by-hour

    WITH Lagged_Prices AS (
    SELECT HOUR, PRICE, LAG(PRICE) OVER (ORDER BY HOUR) AS PREVIOUS_PRICE
    FROM bitcoin.price.ez_hourly_token_prices
    WHERE HOUR >= '2021-01-01 00:00:00' AND HOUR < '2024-04-01 00:00:00'
    )
    SELECT HOUR,
    PRICE,
    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;


    QueryRunArchived: QueryRun has been archived