from ethereum.core.fact_hourly_token_prices

where token_address='0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' -- weth

group by 1

order by 1),

tab2 as (select date_trunc('day',hour) as day, avg(price) as ETH_Derivatives_price

from ethereum.core.fact_hourly_token_prices

where token_address='0xe95a203b1a91a908f9b9ce46459d101078c2c3cb' --aETH --> aETHc --> Ankr Reward Bearing Staked ETH

group by 1

order by 1)

select tab1.day, ETH_Derivatives_price as aETHc, ETH_price as ETH

from tab1 full outer join tab2 on tab1.day=tab2.DAY

where aETHc is not null

order by 1