date_trunc('day', hour) as date,

avg(price) as avg_price_eth

from ethereum.core.fact_hourly_token_prices

where token_address is null

and hour >= current_date() - 30

group by date),

wbtc as (select

date_trunc('day', hour) as date,

avg(price) as avg_price_btc

from ethereum.core.fact_hourly_token_prices

where hour >= current_date() - 30

and symbol in ('WBTC')

group by date

),

matic as (select

date_trunc('day', hour) as date,

avg(price) as avg_price_matic

from ethereum.core.fact_hourly_token_prices

where hour >= current_date() - 30

and symbol in ('MATIC')

group by date

),

sol as (select

date_trunc('day', recorded_hour) as date,

avg (close) as avg_price_sol

from solana.core.fact_token_prices_hourly

where symbol in ('SOL')

and recorded_hour >= current_date() - 30

group by date ),

atom as (select

date_trunc('day', recorded_at) as date,

avg (price) as avg_price_atom