SELECT

distinct(from_address) AS contract_address,

'Arbitrum' AS chain

FROM

arbitrum.core.fact_traces

WHERE 1 = 1

AND to_address = lower('0xff1a0f4744e8582df1ae09d5611b887b6a12925c')

AND from_address not IN (lower('0xff1a0f4744e8582df1ae09d5611b887b6a12925c'))

AND tx_status = 'SUCCESS'

UNION all

SELECT

distinct(from_address) AS contract_address,

'Aurora' AS chain

FROM

aurora.core.fact_traces

WHERE 1 = 1

AND to_address = lower('0xF89C7b475821EC3fDC2dC8099032c05c6c0c9AB9')

AND from_address not IN (lower('0xF89C7b475821EC3fDC2dC8099032c05c6c0c9AB9'))

AND tx_status = 'SUCCESS'

UNION all

SELECT

distinct(from_address) AS contract_address,

'Avalanche' AS chain

FROM

avalanche.core.fact_traces

WHERE 1 = 1

AND to_address = lower('0x4305FB66699C3B2702D4d05CF36551390A4c69C6')

AND from_address not IN (lower('0x4305FB66699C3B2702D4d05CF36551390A4c69C6'))

AND tx_status = 'SUCCESS'