with eth as (
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