with main1 as(select
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
date_trunc('day', hour) as "date(day)",
symbol as "symbol",
avg(price) as "Price(BNB)"
from ethereum.core.fact_hourly_token_prices
where symbol in ('WBNB')
and hour >= '2022-11-01'
group by 1,2)
SELECT
a."date(day)",
"Price(SOL)",
"Price(BNB)"
from main1 a join main2 b on a."date(day)"= b."date(day)"