select
a.hour::date as day,
avg (a.price) as eth_price_usd,
avg (b.price) as reth_price_usd
from ethereum.core.fact_hourly_token_prices a
join ethereum.core.fact_hourly_token_prices b
on a.hour::date = b.hour::date
where a.symbol = 'WETH' --ETH
and b.token_address = lower('0xae78736Cd615f374D3085123A210448E74Fc6393') --rETH
group by 1
order by 1