date_trunc('day', hour) as date,

avg(price) as avg_daily_price

from optimism.core.fact_hourly_token_prices

where token_address = lower('0x4200000000000000000000000000000000000042')

group by date),

velo_volume as (select

date_trunc('day', block_timestamp) as date,

sum(amount_in_usd) as volume_velo

from optimism.velodrome.ez_swaps

group by date

),

comb as (select * from op_price

left join velo_volume using (date))

select corr(avg_daily_price, volume_velo)

from comb