headitmanagerstETH vs ETH difference
Updated 2022-06-08
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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