warriorgem10
Updated 2023-06-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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