symbol,

count(DISTINCT tx_hash) as transfers,

count(DISTINCT TO_ADDRESS) as users,

(count(DISTINCT tx_hash))/(count(DISTINCT TO_ADDRESS)) as avg_transfer_per_user

FROM optimism.core.fact_token_transfers

LEFT OUTER JOIN optimism.core.dim_contracts

ON address = contract_address

WHERE tx_hash in (SELECT * FROM (SELECT DISTINCT tx_hash

FROM optimism.core.fact_event_logs

WHERE contract_address LIKE '0x4200000000000000000000000000000000000010'

)

)

AND from_address LIKE '0x0000000000000000000000000000000000000000'

and symbol in('ETH', 'USDC', 'DAI', 'USDT')

GROUP BY 1,2