with eth_price as (

select

hour::date as DAY

, symbol

, avg(price) as token_price_eth

, avg(token_price_eth) over (partition by symbol order by day ROWS BETWEEN 6 PRECEDING AND CURRENT ROW ) as "Ethereum"

from

ethereum.core.fact_hourly_token_prices

where

-- symbol = 'AUDIO'

symbol = 'WETH'

and hour::DATE >= '{{start_date}}'

GROUP by 1,2

) , op_price as (

select

hour::date as DAY

, symbol

, avg(price) as token_price_op

, avg(token_price_op) over (partition by symbol order by day ROWS BETWEEN 6 PRECEDING AND CURRENT ROW ) as "OP"

from

optimism.core.fact_hourly_token_prices

where

symbol = 'OP'

and hour::DATE >= '{{start_date}}'

GROUP by 1,2

select

DAY

, "Ethereum"

, "OP"

from

op_price inner join eth_price using(day)