select

HOUR,

case when SYMBOL = 'WETH' then 'ETH'

else symbol end as symbol,

PRICE

from crosschain.price.ez_prices_hourly

where TOKEN_ADDRESS in ('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2','0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48','EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm','So11111111111111111111111111111111111111112')

and BLOCKCHAIN in ('solana','ethereum')

qualify row_number() over (partition by symbol order by hour desc) = 1),

final as (

(WITH hyperlane AS (

SELECT *

FROM eclipse.core.fact_events

WHERE PROGRAM_ID = 'EitxJuv2iBjsg2d7jVy2LDC1e2zBrx4GB5Y9h2Ko3A9Y'),

base as (

SELECT

BLOCK_TIMESTAMP,

'Inflow' AS action,

CAST(POST_TOKEN_BALANCES[0]:owner AS STRING) AS owner, -- Cast owner to STRING

CASE

WHEN POST_TOKEN_BALANCES[0]:mint = 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL' THEN 'SOL'

WHEN POST_TOKEN_BALANCES[0]:mint = '8SuhHnSEogAN2udZsoychjTafnaGgM9MCidYZEP8vuVY' THEN 'SOL'

WHEN POST_TOKEN_BALANCES[0]:mint = 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE' THEN 'USDC'

WHEN POST_TOKEN_BALANCES[0]:mint = 'AvieFG3iLSaETVWyd1Urov5fZHy888aATC2QtGTAEhf8' THEN 'USDC'

WHEN POST_TOKEN_BALANCES[0]:mint = 'Hm7FzFMQYxRay1AJxJN4ScBrpMakj8xxXaFcWiU7KLGK' THEN 'tETH' --Turbo ETH

WHEN POST_TOKEN_BALANCES[0]:mint = 'GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn' THEN 'tETH' --Turbo ETH

WHEN POST_TOKEN_BALANCES[0]:mint = '841P4tebEgNux2jaWSjCoi9LhrVr9eHGjLc758Va3RPH' THEN 'WIF' --dogwifhat

END AS symbol,

CAST(POST_TOKEN_BALANCES[0]:mint AS STRING) AS token_address, -- Cast token_address to STRING

CAST((zeroifnull(POST_TOKEN_BALANCES[0]:uiTokenAmount:uiAmountString) - zeroifnull(PRE_TOKEN_BALANCES[0]:uiTokenAmount:uiAmountString)) AS STRING) AS token_amount, -- Cast token_amount to STRING

TX_ID,

LOG_MESSAGES

FROM eclipse.core.fact_transactions