farid-c9j0VMETH vs stETH price
    Updated 2022-06-09
    with tab1 as (select date_trunc('day', hour) as day, avg(price) as eth_price
    from ethereum.token_prices_hourly_v2
    where day>'2021-01-01' and symbol='ETH'
    group by 1
    order by 1 desc),

    tab2 as (select date_trunc('day', hour) as day, avg(price) as STETH_price
    from ethereum.token_prices_hourly_v2
    where day>'2021-01-01' and token_address='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    group by 1
    order by 1 desc)

    select tab1.day, tab1.ETH_price, tab2.STETH_price, (tab1.ETH_price-tab2.STETH_price) as difference
    from tab1
    left join tab2
    on tab1.day=tab2.DAY
    order by 1 desc


    Run a query to Download Data