Drsimontop token - price daily
Updated 2023-01-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with tab1 as ( select symbol as Symbol1,
avg (price) as Previous_Price
from osmosis.core.dim_prices
where symbol in ('ATOM' , 'osmo' , 'axl' , 'wbtc' ,'statom' , 'WETH' , 'JUNO', 'DAI','EVMOS','CRO')
--and recorded_at >= '2023-01-01'
group by 1)
select recorded_at::date as date,
symbol, price ,
(avg(price - Previous_Price)/avg(Previous_Price)) * 100 as Price_Change_Ratio
from osmosis.core.dim_prices t1 join tab1 t2 on Symbol1 = symbol
where symbol in ('ATOM' , 'osmo' , 'axl' , 'wbtc' ,'statom' , 'WETH' , 'JUNO', 'DAI','EVMOS','CRO')
--and recorded_at >= '2023-01-01'
group by 1,2,3
Run a query to Download Data