nits4- Binance Bonanza Tokens which had their prices changed
Updated 2022-11-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with day1 as
(SELECT date(recorded_at) as day,symbol, avg(price) as avg_price
from osmosis.core.dim_prices
GROUP by 1 , 2
order by 1 desc ),
day2 as
(SELECT date(recorded_at) as day_,symbol as s, avg(price) as avg_price2
from osmosis.core.dim_prices
GROUP by 1 ,2
order by 1 desc)
SELECT *, case when symbol = 'OSMO' then 'OSMO'
when percent_change_price>= 10 then 'more than 10% increase'
when percent_change_price < 10 and percent_change_price>= 0 then 'less than 10% increase'
when percent_change_price < 0 then 'price decreased' end as type
from
(SELECT *, (avg_price-avg_price2)/avg_price2*100 as percent_change_price
from day1
inner join day2
on day = day_+1 and s = symbol)
where day = '2022-10-28'
limit 100
Run a query to Download Data