Moe0 FUNG copy
    Updated 2023-05-19
    select
    RECORDED_HOUR::date date,
    TOKEN,
    avg(CLOSE) as price
    from
    flow.core.fact_hourly_prices
    where
    date >= CURRENT_DATE - {{days_back}}
    and token in ('Starly','Revv','Blocto','Sportium')
    group by
    1,
    2


    Run a query to Download Data