SELECT TX_HASH, ORIGIN_FROM_ADDRESS, 'Arb' AS Chain

FROM arbitrum.core.ez_decoded_event_logs

WHERE ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

AND EVENT_NAME IN ('LiFiTransferStarted', 'LiFiHopTransfer', 'LiFiAcrossTransfer', 'LiFiCBridgeTransfer')

AND TX_STATUS = 'SUCCESS'

UNION ALL

SELECT TX_HASH, ORIGIN_FROM_ADDRESS, 'Optimisim' AS Chain

FROM optimism.core.ez_decoded_event_logs

WHERE ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

AND EVENT_NAME IN ('LiFiTransferStarted', 'LiFiHopTransfer', 'LiFiAcrossTransfer', 'LiFiCBridgeTransfer')

AND TX_STATUS = 'SUCCESS'

UNION ALL

SELECT TX_HASH, ORIGIN_FROM_ADDRESS, 'Base' AS Chain

FROM base.core.ez_decoded_event_logs

WHERE ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

AND EVENT_NAME IN ('LiFiTransferStarted', 'LiFiHopTransfer', 'LiFiAcrossTransfer', 'LiFiCBridgeTransfer')

AND TX_STATUS = 'SUCCESS'

UNION ALL

SELECT TX_HASH, ORIGIN_FROM_ADDRESS, 'Polygon' AS Chain

FROM polygon.core.ez_decoded_event_logs

WHERE ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

AND EVENT_NAME IN ('LiFiTransferStarted', 'LiFiHopTransfer', 'LiFiAcrossTransfer', 'LiFiCBridgeTransfer')

AND TX_STATUS = 'SUCCESS'

UNION ALL

SELECT TX_HASH, ORIGIN_FROM_ADDRESS, 'Ethereum' AS Chain

FROM ethereum.core.ez_decoded_event_logs

WHERE ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

AND EVENT_NAME IN ('LiFiTransferStarted', 'LiFiHopTransfer', 'LiFiAcrossTransfer', 'LiFiCBridgeTransfer')

AND TX_STATUS = 'SUCCESS'

),

CombinedTokenTransfers AS (

SELECT TX_HASH, ORIGIN_FROM_ADDRESS, AMOUNT_USD, 'Arbitrium' AS Chain

FROM arbitrum.core.ez_token_transfers

WHERE ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

AND ORIGIN_FROM_ADDRESS = FROM_ADDRESS