flipside

    Untitled Query
    boomer77Untitled Query
    Updated 2021-09-05
    select date_trunc('day', block_timestamp) as blockday, currency, symbol, avg(price_usd)
    from terra.oracle_prices
    where blockday >= CURRENT_DATE - 190
    group by 1,2,3
    order by 1 desc
    Run a query to Download Data