nsa2000opso10
Updated 2022-12-09Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with table1 as (
select hour::date as date,
avg (price) as WBTC
from ethereum.core.fact_hourly_token_prices
where symbol in ('WBTC')
and hour >= '2022-10-08'
group by 1),
table2 as (
select recorded_hour::date as date,
avg (close) as SOL
from solana.core.fact_token_prices_hourly
where symbol in ('SOL')
and recorded_hour >= '2022-10-08'
group by 1)
select t1.date,
WBTC,
SOL
from table1 t1 join table2 t2 on t1.date = t2.date
Run a query to Download Data