mlhETH vs BTC price
Updated 2023-01-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with eth as (
select hour::date as date,
avg (price) as ETH
from ethereum.core.fact_hourly_token_prices
where symbol in ('WETH')
and hour >= '2022-01-01'
group by 1),
wbtc as (
select hour::date as date,
avg (price) as WBTC
from ethereum.core.fact_hourly_token_prices
where symbol in ('WBTC')
and hour >= '2022-01-01'
group by 1)
select a.date,
ETH,
WBTC
from eth a join wbtc b on a.date = b.date
Run a query to Download Data