select timestamp::date as day,

avg (price_usd) as usd_price

from near.core.fact_prices

where symbol = 'wNEAR'

and timestamp >= '2022-11-01'

group by 1),

flow_price as (

select timestamp::date as day,

avg (price_usd) as usd_price

from solana.core.fact_prices

where source = 'stableswap'

and token_contract = 'A.1654653399040a61.FlowToken'

and timestamp >= '2022-11-01'

group by 1)

select

t1.day,

t1.usd_price as NEAR,

t2.usd_price as SOL

from near_price t1

join sol_price t2 on t1.day = t2.day