rw2023KI token price
Updated 2023-04-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from GENE token price @ https://flipsidecrypto.xyz/edit/queries/4dab3c10-dc4d-4193-9dae-77e2687d5116
-- forked from m-zamani-WmWD3E / mngo1 @ https://flipsidecrypto.xyz/m-zamani-WmWD3E/q/2023-04-14-02-26-pm-iGMDVa
select
RECORDED_HOUR::date as day,
avg(CLOSE) as token_price,
lag(token_price) ignore nulls over(ORDER BY day ASC) as lag_price,
((token_price-lag_price)/token_price)*100 as deviation_price,
avg(token_price) OVER (ORDER BY day ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as MA_7_Days_volume,
avg(token_price) OVER (ORDER BY day ROWS BETWEEN 15 PRECEDING AND CURRENT ROW) as MA_15_Days_volume
from solana.core.ez_token_prices_hourly
where day>= '2022-09-01'
and symbol in ('ki')
group by 1
ORDER by day DESC
Run a query to Download Data