SELECT DISTINCT sender_wallet AS address

FROM external.layerzero.fact_transactions_snapshot

WHERE sender_wallet IS NOT NULL

),

combined_txs AS (

SELECT 'Polygon' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH

FROM polygon.core.fact_transactions

WHERE FROM_ADDRESS IN (SELECT address FROM layerzero_addresses)

AND TO_ADDRESS IN (SELECT address FROM layerzero_addresses)

AND TO_ADDRESS != FROM_ADDRESS

UNION ALL

SELECT 'Optimism' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH

FROM optimism.core.fact_transactions

WHERE FROM_ADDRESS IN (SELECT address FROM layerzero_addresses)

AND TO_ADDRESS IN (SELECT address FROM layerzero_addresses)

AND TO_ADDRESS != FROM_ADDRESS

UNION ALL

SELECT 'Arbitrum' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH

FROM arbitrum.core.fact_transactions

WHERE FROM_ADDRESS IN (SELECT address FROM layerzero_addresses)

AND TO_ADDRESS IN (SELECT address FROM layerzero_addresses)

AND TO_ADDRESS != FROM_ADDRESS

UNION ALL

SELECT 'Ethereum' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH

FROM ethereum.core.fact_transactions

WHERE FROM_ADDRESS IN (SELECT address FROM layerzero_addresses)

AND TO_ADDRESS IN (SELECT address FROM layerzero_addresses)

AND TO_ADDRESS != FROM_ADDRESS

UNION ALL

SELECT 'Avalanche' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH

FROM avalanche.core.fact_transactions

WHERE FROM_ADDRESS IN (SELECT address FROM layerzero_addresses)

AND TO_ADDRESS IN (SELECT address FROM layerzero_addresses)

AND TO_ADDRESS != FROM_ADDRESS