Tobi_1practical-chocolate
Updated 2024-09-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
WITH price_trend AS (
SELECT
HOUR,
PRICE,
LAG(PRICE) OVER (ORDER BY HOUR) AS previous_price -- Get the price from the previous hour
FROM
base.price.ez_prices_hourly
WHERE
TOKEN_ADDRESS = '0x532f27101965dd16442e59d40670faf5ebb142e4'
AND HOUR >= DATEADD(HOUR, -24, CURRENT_TIMESTAMP) -- Filter for the last 24 hours
)
-- Final Query: Calculate the percentage change in price
SELECT
HOUR,
PRICE,
previous_price,
CASE
WHEN previous_price IS NOT NULL THEN ((PRICE - previous_price) / previous_price) * 100
ELSE 0
END AS price_change_percentage
FROM
price_trend
ORDER BY
HOUR ASC;
QueryRunArchived: QueryRun has been archived