wanlinQuery BTC price
Updated 2024-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- 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