with tab1 as (

select

date_trunc('day', hour) as date1,

avg(price) as MATIC_Price

from ethereum.core.fact_hourly_token_prices

where symbol like 'MATIC'

and hour > '2022-07-01'

group by 1 )

, tab2 as (

select

date_trunc('day', hour) as date2,

avg(price) as ETH_Price

from ethereum.core.fact_hourly_token_prices

where symbol like 'WETH'

and hour > '2022-07-01'

group by 1 )

select *

from tab1 left outer join tab2 on date1 = date2