with eth_price as (

select

hour::date as day_price

,avg (price) as avg_price

from ethereum.core.fact_hourly_token_prices

where symbol = 'WETH'

group by 1

,sol_price as(

select

block_timestamp::date as day_price

,median (swap_to_amount/swap_from_amount) as avg_price

from solana.fact_swaps

where swap_to_mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

,'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')

and swap_from_mint = 'So11111111111111111111111111111111111111112'

and succeeded = 'TRUE'

group by 1

order by 1

,algo_price as (

select

block_hour::date as day_price

,avg (price_usd) as avg_price

from algorand.defi.ez_price_pool_balances

where asset_id = '0'

group by 1

,flow_price as (

select

timestamp::date as day_price

,TOKEN_CONTRACT

,avg (price_usd) as avg_price

from flow.core.fact_prices