headitmanagerstETH vs ETH difference
    Updated 2022-06-08
    with ETH as (select 'ETH' as lbl ,avg(price) as ethprice,hour from flipside_prod_db.ethereum_core.fact_hourly_token_prices where token_address is null
    group by hour)
    , STEHT as (select 'STETH' as lbl ,avg(price) as stethprice,hour from flipside_prod_db.ethereum_core.fact_hourly_token_prices
    where token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    group by hour)


    select (ethprice-stethprice) as diff ,ETH.hour from ETH inner join STEHT on ETH.hour=STEHT.hour



    Run a query to Download Data