SELECT DISTINCT tx_hash

FROM optimism.core.fact_event_logs

WHERE contract_address LIKE '0x4200000000000000000000000000000000000010'

SELECT

symbol,

count(DISTINCT tx_hash) as transfer,

count(DISTINCT TO_ADDRESS) as users

FROM optimism.core.fact_token_transfers

LEFT OUTER JOIN optimism.core.dim_contracts

ON address = contract_address

WHERE tx_hash in (SELECT * FROM tab1)

AND from_address LIKE '0x0000000000000000000000000000000000000000'

GROUP BY 1