flipside

    min SCRT price($)
    FatemeTheLadymin SCRT price($)
    Updated 2022-10-12

    select date(recorded_at) as "Date",
    avg(price) as "SCRT price"
    --case when Date>CURRENT_DATE-8 then 'Current week' else 'other days' end as "Date status"
    from osmosis.core.dim_prices
    where symbol = 'SCRT' and "Date"<CURRENT_DATE --and Date>CURRENT_DATE-91
    group by 1
    order by 2 asc
    limit 1



    Run a query to Download Data