select symbol as Symbol1,

avg (price) as Previous_Price

from ethereum.core.fact_hourly_token_prices

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

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

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-25'

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-25'

group by 1

union ALL

select symBol as symbol1,

avg (price_usd) as Previous_Price

from flow.core.fact_prices

where symbol in ('FLOW')

and timestamp = CURRENT_DATE

group by 1)

select date_trunc('day', hour) as date,

symbol,

(avg(price - Previous_Price)/avg(Previous_Price)) * 100 as Price_Change_Ratio

from ethereum.core.fact_hourly_token_prices t1 join previous_table t2 on Symbol1 = symbol

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

and hour >= '2022-10-25'

group by 1

union ALL select recorded_hour::date as date,