bachibin1
    Updated 2022-11-02
    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