LTirrellUntitled Query
    Updated 2021-10-05
    WITH mir AS (
    select
    distinct date_trunc('hour', o.block_timestamp) as date,
    o.symbol as sym,
    o.luna_exchange_rate as exchange_rate_luna
    from
    terra.oracle_prices o
    where
    sym = 'MIR'
    )
    select
    date,
    avg(exchange_rate_luna)
    from
    mir
    group by
    date
    order by
    date
    Run a query to Download Data