gigiokobaPrice volatility (%)
Updated 2024-10-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH PriceChanges AS (
SELECT
hour,
PRICE AS current_price,
LAG(PRICE) OVER (PARTITION BY TOKEN_ADDRESS ORDER BY hour) AS previous_price
FROM solana.price.ez_prices_hourly
WHERE TOKEN_ADDRESS = 'HnKkzR1YtFbUUxM6g3iVRS2RY68KHhGV7bNdfF1GCsJB'
)
SELECT
hour,
current_price,
previous_price,
CASE
WHEN previous_price IS NULL THEN NULL
ELSE ROUND(((current_price - previous_price) / previous_price) * 100, 2)
END AS percent_change
FROM PriceChanges
ORDER BY hour;
QueryRunArchived: QueryRun has been archived