SELECT

HOUR::DATE as DATE,

symbol,

avg(price) btc_price

FROM ethereum.core.fact_hourly_token_prices

WHERE symbol in ('WBTC')

AND HOUR::DATE >= CURRENT_DATE - INTERVAL '{{Past_Months}} MONTH'

group by 1,2

, op as (

SELECT

HOUR::DATE as DATE,

symbol,

avg(price) op_price

FROM optimism.core.fact_hourly_token_prices

WHERE symbol in ('OP')

AND HOUR::DATE >= CURRENT_DATE - INTERVAL '{{Past_Months}} MONTH'

group by 1,2

SELECT btc.DATE, btc_price, op_price

FROM btc join op USING(date)