alirezaalirezastETH and ETH daily price
    Updated 2022-09-13
    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