SELECT DISTINCT tx_hash

FROM (optimism.core.fact_event_logs)

WHERE contract_address LIKE '0x4200000000000000000000000000000000000010'

)

SELECT

symbol,

count(DISTINCT tx_hash) as total_transaction,

count(DISTINCT TO_ADDRESS) as total_user

FROM

(optimism.core.fact_token_transfers)

LEFT OUTER JOIN optimism.core.dim_contracts

ON address = contract_address

WHERE tx_hash in (SELECT * FROM total)

AND block_timestamp::date >= CURRENT_DATE - 90

AND from_address LIKE '0x0000000000000000000000000000000000000000'

GROUP BY symbol