MasiUntitled Query
Updated 2022-08-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
trunc(hour,'day') as day ,
case when symbol = 'WETH' then 'ETH' end as symbols ,
avg(price) as price
from ethereum.core.fact_hourly_token_prices
where hour::date between '2022-07-01' and '2022-07-30'
and symbol = 'WETH'
group by 1,2
UNION
select
trunc(hour,'day') as day ,
symbol as symbols,
avg(price) as price
from optimism.core.fact_hourly_token_prices
where hour::date between '2022-07-01' and '2022-07-30'
and symbol = 'OP'
group by 1,2
Run a query to Download Data