SELECT

TIMESTAMP::date as date,

AVG(price_usd) as usd_Price

FROM

NEAR.CORE.FACT_PRICES

WHERE

TIMESTAMP >= '2022-11-01'

AND

SYMBOL = 'wNEAR'

GROUP BY

date

),

solana_Price AS

SELECT

RECORDED_HOUR::date as date,

AVG(CLOSE) as usd_Price

FROM

solana.core.fact_token_prices_hourly

WHERE

recorded_hour >= '2022-11-01'

AND

SYMBOL = 'SOL'

GROUP BY

date

SELECT

a.date,

a.usd_Price as near_USD,

b.usd_Price as solana_USD

FROM

near_Price a JOIN solana_Price b ON a.date = b.date