recorded_hour::date as "date(day)",

symbol as "symbol",

avg(close) as "Price(SOL)"

from solana.core.fact_token_prices_hourly

where symbol in ('SOL')

and recorded_hour >= '2022-11-01'

group by 1,2),

main2 as (select

timestamp::date as "date(day)",

symbol as "symbol",

avg(price_usd) as "Price(FLOW)"

from flow.core.fact_prices

where symbol in ('FLOW')

and timestamp >= '2022-11-01'

group by 1,2)

select

a."date(day)",

"Price(SOL)",

from main1 a join main2 b on a."date(day)" = b."date(day)"