warriorgem10
    Updated 2023-06-09
    with ev as (
    select date(recorded_at) as pdate,
    avg(price) as price
    from osmosis.core.dim_prices
    where symbol = 'ATOM'
    group by pdate
    )

    select date(HOUR) as pdate,
    avg(btc.price) as btc_price, ev.price as atom_price
    from ethereum.core.fact_hourly_token_prices btc
    join ev on ev.pdate = date(HOUR)
    where symbol = 'WBTC'
    group by date(HOUR), ev.price
    Run a query to Download Data