select hour::date as day,

avg (price) as USDPrice

from ethereum.core.fact_hourly_token_prices

where symbol = 'WETH'

group by 1),

SOLPricet as (

select block_timestamp::date as day,

median (swap_to_amount/swap_from_amount) as USDPrice

from solana.fact_swaps

where swap_from_mint = 'So11111111111111111111111111111111111111112' --SOL

and swap_to_mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB') --USDC,USDT

and swap_to_amount > 0

and swap_from_amount > 0

and succeeded = 'TRUE'

group by 1),

algopricet as (

select block_hour::date as day,

avg (price_usd) as usdprice

from algorand.core.ez_price_pool_balances

where asset_id = '0'

group by 1),

flowpricet as (

select timestamp::date as day,

avg (price_usd) as usdprice

from flow.core.fact_prices

where source = 'coinmarketcap'

and symbol = 'FLOW'

group by 1),

nearpricet as (

select timestamp::date as day,

avg (price_usd) as usdprice