glass_blossomsMine volatility
    Updated 2022-02-10
    WITH prices AS
    (select date_trunc('day',block_timestamp) as Date,
    symbol,
    round(avg(price_usd),2) AS avg,
    round(min(price_usd),2) AS low,
    round(max(price_usd),2) AS high,
    round(stddev(price_usd),2) AS stdDev
    from terra.oracle_prices
    where symbol = 'MINE'
    and block_timestamp > getdate() - interval'90 days'
    group by 1,2)

    select *,
    round((avg+stdDev),2) AS highStdDev,
    round((avg-stdDev),2) AS lowStdDev,
    round((avg-low),2) AS lowDiff,
    round((high-avg),2) AS highDiff
    from prices
    order by 1
    Run a query to Download Data