SELECT

symbol as symbol0,

avg (price) as price_old

FROM ethereum.core.fact_hourly_token_prices

WHERE symbol in ('WETH', 'MATIC')

AND HOUR BETWEEN CURRENT_DATE - 31 AND CURRENT_DATE - 29

GROUP BY 1

)

, algoPrice as (

select

ASSET_NAME as symbol0,

avg(price_usd) as price_old

from algorand.defi.ez_price_pool_balances

where ASSET_NAME = 'ALGO'

AND ASSET_ID = 0

AND block_hour BETWEEN CURRENT_DATE - 31 AND CURRENT_DATE - 29

GROUP by 1

)

, solPrice as (

select

SYMBOL as symbol0,

avg(CLOSE) as price_old

from solana.core.fact_token_prices_hourly

where SYMBOL = 'SOL'

and IMPUTED = FALSE

and RECORDED_HOUR BETWEEN CURRENT_DATE - 31 AND CURRENT_DATE - 29

group by 1

)

, atomPrice as (

SELECT

symbol as symbol0,

avg(price) as price_old

FROM osmosis.core.dim_prices

WHERE symbol = ('ATOM')

AND RECORDED_AT BETWEEN CURRENT_DATE - 31 AND CURRENT_DATE - 29