0xHaM-dSolana Price
Updated 2022-11-28Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
RECORDED_HOUR::date as date,
CASE
WHEN RECORDED_HOUR >= '2022-11-07' THEN 'Post FTX Demise' ELSE 'Pre FTX Demise'
END as period,
avg(CLOSE) as "Token Price",
avg("Token Price") over (order by date rows between 7 PRECEDING and current row) as "MA 7-day Token",
avg("Token Price") over (order by date rows between 100 PRECEDING and current row) as "MA 100-day Token",
avg("Token Price") over (order by date rows between 200 PRECEDING and current row) as "MA 200-day Token"
from solana.core.fact_token_prices_hourly
where SYMBOL = 'SOL'
and IMPUTED = FALSE
AND RECORDED_HOUR >= '2022-10-01'
AND RECORDED_HOUR <= CURRENT_DATE - 1
GROUP by 1,2
ORDER by 1
Run a query to Download Data