select symbol as Symbol1,

avg (price) as Previous_Price

from ethereum.core.fact_hourly_token_prices

where symbol in ('WETH','WBTC','MATIC')

and hour::date = '2022-10-24'

group by 1

union ALL

select symbol as Symbol1,

avg (close) as Previous_Price

from solana.core.fact_token_prices_hourly

where symbol in ('SOL')

and recorded_hour = '2022-10-24'

group by 1

union ALL

select symbol as Symbol1,

avg (price) as Previous_Price

from osmosis.core.dim_prices

where symbol in ('ATOM')

and recorded_at = '2022-10-24'

group by 1

union ALL

select

'AVAX' as Symbol1,

avg(amount_usd/amount) as Previous_Price

from avalanche.core.ez_avax_transfers

where date_trunc('day', block_timestamp) = '2022-10-24'),

avax_price_table as (

select