select

date_trunc('day', hour) as day,

avg(price) as price

from ethereum.core.fact_hourly_token_prices

where token_address is null

group by 1

),

sol as (

select

date_trunc('day', recorded_hour) as day,

avg(close) as price

from solana.core.fact_token_prices_hourly

where symbol = 'SOL'

group by 1

),

poly as (

select

date_trunc('day', hour) as day,

avg(price) as price

from ethereum.core.fact_hourly_token_prices

where symbol = 'MATIC'

group by 1

),

algo as (

select

date_trunc('day', block_hour) as day,

avg(price_usd) as price

from algorand.core.ez_price_pool_balances

where asset_name = 'ALGO'

group by 1

),

near as (

select

date_trunc('day', timestamp) as day,

avg(price_usd) as price