freemartianstETH/ETH Peg
Updated 2022-06-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with eth_price as (
select price, hour
from ethereum_core.fact_hourly_token_prices
where symbol = 'WETH'
),
steth_price as (
select price, hour
from ethereum_core.fact_hourly_token_prices
where symbol = 'stETH'
)
select avg(s.price/e.price), date_trunc('day', e.hour) as TIME
from eth_price e inner join steth_price s on e.hour = s.hour
group by TIME
Run a query to Download Data