bachibin1
Updated 2022-11-02Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select date(recorded_at) as day,
case when day >= '2022-10-28' then 'After $OSMO listed on Binance'
else 'Before $OSMO listed on Binance'
end as time_period,
round(avg (price),2) as osmo_price_usd
from osmosis.core.dim_prices
where symbol = 'OSMO'
and recorded_at >= dateadd(month, -3, getdate())
group by day, time_period
order by day desc
Run a query to Download Data