mariyaUST Variance
    Updated 2022-04-26
    select date_trunc('hour', block_timestamp) as date,
    symbol,
    avg(price_usd)
    from terra.oracle_prices
    where date > GETDATE() - interval '6 months'
    AND symbol = 'UST'
    group by 1,2
    order by 1, 2