select

hour::date as sol_price_date

,avg(price) as Sol_Price

from solana.price.ez_prices_hourly

where token_address = 'So11111111111111111111111111111111111111112'

group by 1

,lst_eth_price as (

select

hour::date as eth_price_date

,avg(price) as ETH_Price

from ethereum.price.ez_prices_hourly

where SYMBOL ilike 'ETH'

and NAME = 'ethereum'

group by 1

,lst_near_price as (

select

hour::date as near_price_date

,avg(close) as NEAR_Price

from near.price.fact_prices_ohlc_hourly

where ASSET_ID='wrapped-near'

and near_price_date is not null

group by 1

)

,lst_aurora_price as (

select

hour::date as aurora_price_date

,avg(close) as AURORA_Price

from near.price.fact_prices_ohlc_hourly

where ASSET_ID='aurora-near'

and aurora_price_date is not null

group by 1

)

,lst_btc_price as (