alirezaalirezastETH and ETH daily price
Updated 2022-09-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with stETH as (select
trunc(hour,'day') as days,
AVG(price) as stETH_price
from ethereum.token_prices_hourly
where symbol = 'stETH'
and days >= '2022-01-01'
group by 1
),
ETH as (select
trunc(hour,'day') as day,
AVG(price) as ETH_price
from ethereum.token_prices_hourly
where symbol like 'WETH'
and day >= '2022-01-01'
group by 1
)
select
day,
stETH_price,
ETH_price,
stETH_price / ETH_price as peg_ratio
from stETH s left join ETH e ON day = days
order by 1 asc
Run a query to Download Data