LTirrellprice_impact_airdrops_anc
    Updated 2021-10-06
    -- select
    -- o.block_timestamp as date,
    -- o.symbol as sym,
    -- o.luna_exchange_rate
    -- from
    -- terra.oracle_prices o
    -- where
    -- sym in ('ANC', 'MIR', 'MINE')
    -- order by
    -- date
    -- LIMIT
    -- 100
    WITH anc AS (
    select
    date_trunc('hour', o.block_timestamp) as date,
    o.symbol as sym,
    o.luna_exchange_rate as exchange_rate_luna,
    o.price_usd
    from
    terra.oracle_prices o
    where
    sym = 'MIR'
    ),
    luna AS (
    select
    date_trunc('hour', o.block_timestamp) as date,
    o.symbol as sym,
    o.price_usd
    from
    terra.oracle_prices o
    where
    sym = 'LUNA'
    ),
    L_Airdrops AS (
    select
    date_trunc('hour', m.block_timestamp) as date,
    Run a query to Download Data