select

date_trunc('day', HOUR) as date,

avg(PRICE) as ETH_price

from ethereum.core.fact_hourly_token_prices

where 1=1

and symbol = 'WETH'

and hour >= CURRENT_DATE - 30

group by 1

order by date ASC

),

SOL_price as (

select

date_trunc('day', RECORDED_HOUR) as date,

avg(CLOSE) as SOL_Price

from solana.core.fact_token_prices_hourly

where SYMBOL = 'SOL'

and RECORDED_HOUR >= CURRENT_DATE - 30

group by 1

),

Algo_price as (

select

date_trunc('day', block_hour) as date,

avg(price_usd) as Algo_price

from algorand.core.ez_price_pool_balances

where asset_id = '0'

group by 1

),

Flow_price as (

select

date_trunc('day',timestamp) as date,

avg(price_usd) as Flow_price

from flow.core.fact_prices

where symbol = 'FLOW'

group by 1

),