WITH decodedTXN AS (

SELECT tx_hash, src_chain, decoded_log, block_timestamp, event_name

FROM (

SELECT * , 'Ethereum' AS src_chain FROM ethereum.core.ez_decoded_event_logs

WHERE block_timestamp::date = '2025-02-09'

UNION

SELECT *, 'Polygon' AS src_chain FROM polygon.core.ez_decoded_event_logs

WHERE block_timestamp::date = '2025-02-09'

UNION

SELECT *, 'BSC' AS src_chain FROM bsc.core.ez_decoded_event_logs

WHERE block_timestamp::date = '2025-02-09'

UNION

SELECT *, 'BASE' AS src_chain FROM base.core.ez_decoded_event_logs

WHERE block_timestamp::date = '2025-02-09'

UNION

SELECT *, 'Arbitrum' AS src_chain FROM arbitrum.core.ez_decoded_event_logs

WHERE block_timestamp::date = '2025-02-09'

UNION

SELECT *, 'OP' AS src_chain FROM optimism.core.ez_decoded_event_logs

WHERE block_timestamp::date = '2025-02-09'

UNION

SELECT *, 'Avalanche' AS src_chain FROM avalanche.core.ez_decoded_event_logs

WHERE block_timestamp::date = '2025-02-09'

UNION

SELECT *, 'Gnosis' AS src_chain FROM gnosis.core.ez_decoded_event_logs

WHERE block_timestamp::date = '2025-02-09'

)),

prices as (

SELECT hour, price, decimals, symbol, iff(is_native,'0x0000000000000000000000000000000000000000', token_address) as token_address, 'Arbitrum' AS chain FROM arbitrum.price.ez_prices_hourly