freemartianstETH/ETH Peg
    Updated 2022-06-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