SELECT date_trunc('day', hour) as date, symbol, avg(price) as eth

FROM ethereum.core.fact_hourly_token_prices

WHERE SYMBOL = 'WETH' and date > '2021-01-01'

GROUP BY 1, 2

, steth_price as (

SELECT date_trunc('day', hour) as date, symbol, avg(price) as steth

FROM ethereum.core.fact_hourly_token_prices

WHERE SYMBOL = 'stETH' and date > '2021-01-01'

GROUP BY 1, 2

SELECT e.date, eth, steth, ((eth - steth) / eth) * 100 as pct_delta

FROM steth_price s LEFT JOIN eth_price e ON e.date = s.date