select

avg(price) price_avg_weth

from ethereum.core.fact_hourly_token_prices

where symbol = 'WETH'

and hour::date = (select max(hour::date) from ethereum.core.fact_hourly_token_prices where symbol = 'WETH')

),

t2 as (

select

avg(close) price_avg_sol

from solana.core.fact_token_prices_hourly

where symbol = 'SOL'

and recorded_hour::date = (select max(recorded_hour::date) from solana.core.fact_token_prices_hourly where symbol = 'SOL')

),

t3 as (

select

avg(price) price_avg_matic

from ethereum.core.fact_hourly_token_prices

where symbol = 'MATIC'

and hour::date = (select max(hour::date) from ethereum.core.fact_hourly_token_prices where symbol = 'MATIC')

),

t4 as (

select

avg(price_usd) price_avg_algo

from algorand.defi.ez_price_pool_balances

where asset_name = 'ALGO'

and block_hour::date = (select max(block_hour::date) from algorand.defi.ez_price_pool_balances where asset_name = 'ALGO')

),

t5 as (

select

avg(price) price_avg_atom

from osmosis.core.dim_prices