avg (price) as solana from ethereum.core.fact_hourly_token_prices

where token_address in ('0xd31a59c85ae9d8edefec411d448f90841571b89c')

and hour::date >= CURRENT_DATE - 60 group by 1),

min2 as (select hour::date as date,

avg (price) as SRM from ethereum.core.fact_hourly_token_prices

where token_address in ('0x476c5e26a75bd202a9683ffd34359c0cc15be0ff')

and hour::date >= CURRENT_DATE - 60 group by 1)

select w.date, SRM, solana from min1 w join min2 a2 on w.date = a2.date