SELECT

DISTINCT contract_address, symbol

FROM arbitrum.core.fact_transactions as a

LEFT outer JOIN (

SELECT --*

tx_hash,

CONTRACT_ADDRESS,

SYMBOL

FROM arbitrum.core.ez_token_transfers

WHERE NOT contract_address in (

lower('0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8'),

lower('0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9'),

lower('0xfc90518D5136585ba45e34ED5E1D108BD3950CFa'),

lower('0xaf88d065e77c8cc2239327c5edb3a432268e5831')

--lower('0xaf88d065e77c8cc2239327c5edb3a432268e5831')

)

--WHERE tx_hash LIKE '0xa984d31dafe0d7ad59ba2bb439e068b6f16c9fcec444d615a8237baea57a87ed'

--GROUP BY 1,2

) as b

on a.tx_hash = b.tx_hash

WHERE to_address LIKE '0xe4f65f9a4659a2bd961a0e3ee68341bf221114e4'

AND ORIGIN_FUNCTION_SIGNATURE LIKE '0x53fdc1f3'

--AND (

--from_address LIKE '0x0000000000000000000000000000000000000000'

--OR to_address LIKE '0x0000000000000000000000000000000000000000'

--)

), tab2 as (

SELECT

DISTINCT contract_address, symbol