hour::date as date,

avg(price) as sol_price

from ethereum.core.fact_hourly_token_prices

where token_address = lower('0xD31a59c85aE9D8edEFeC411D448f90841571b89c')

and date >= CURRENT_DATE - 1095

group by 1),

btc as (select

hour::date as date,

avg(price) as btc_price

from ethereum.core.fact_hourly_token_prices

where symbol = 'WBTC'

and date >= CURRENT_DATE - 1095

group by 1)

select s.date, sol_price, btc_price

from sol s

join btc b on s.date = b.date