princefarzamMINE volatility
    Updated 2022-02-10
    With MAX_MINE_PRICE AS (
    SELECT
    date_trunc('day', block_timestamp) AS day,
    max(price_usd) AS MAX_PRICE_OF_MINE
    from terra.oracle_prices
    where symbol= 'MINE'
    and day::DATE >= CURRENT_DATE -INTERVAL'90 days'
    GROUP BY 1
    ORDER BY 1
    ),MIN_MINE_PRICE AS (
    SELECT
    date_trunc('day', block_timestamp) AS day,
    min(price_usd) AS MIN_PRICE_OF_MINE
    from terra.oracle_prices
    where symbol= 'MINE'
    and day::DATE >= CURRENT_DATE -INTERVAL'90 days'
    GROUP BY 1
    ORDER BY 1
    )
    SELECT
    MX.day,
    MX.MAX_PRICE_OF_MINE,
    MN.MIN_PRICE_OF_MINE,
    MX.MAX_PRICE_OF_MINE - MN.MIN_PRICE_OF_MINE AS volatility
    FROM MAX_MINE_PRICE MX INNER JOIN MIN_MINE_PRICE MN ON MX.day=MN.day
    Run a query to Download Data