with

flow as (

SELECT DATE_TRUNC('HOUR', hour) AS hour,

avg(price) AS avg_price

FROM ethereum.core.fact_hourly_token_prices

WHERE hour >= DATEADD(day, -90, CURRENT_TIMESTAMP())

AND token_address=lower('0x5c147e74D63B1D31AA3Fd78Eb229B65161983B2b')

GROUP BY DATE_TRUNC('HOUR', hour)

),

sand as (

SELECT DATE_TRUNC('HOUR', hour) AS hour,

avg(price) AS avg_price

FROM crosschain.core.ez_hourly_prices

WHERE hour >= DATEADD(day, -90, CURRENT_TIMESTAMP())

AND symbol IN ('SAND')

GROUP BY DATE_TRUNC('HOUR', hour)

),

apt as (

SELECT DATE_TRUNC('HOUR', hour) AS hour,

avg(price*(pow(10,5))) AS avg_price

FROM crosschain.core.ez_hourly_prices

WHERE hour >= DATEADD(day, -90, CURRENT_TIMESTAMP())

AND symbol IN ('APT')

GROUP BY DATE_TRUNC('HOUR', hour)

),

sol as (

SELECT DATE_TRUNC('HOUR', recorded_hour) AS hour,

avg(close) AS avg_price

FROM solana.core.fact_token_prices_hourly

WHERE hour >= DATEADD(day, -90, CURRENT_TIMESTAMP())

AND symbol IN ('SOL')

GROUP BY DATE_TRUNC('HOUR', recorded_hour)

),

token_prices as (

select 'FLOW' as symbol,* from flow