WITH senders AS (

SELECT from_address AS sender,

SUM(raw_amount/pow(10,18)) AS send_amount

FROM optimism.core.fact_token_transfers

WHERE contract_address = '0x4200000000000000000000000000000000000042'

GROUP BY 1

),

receivers AS(

SELECT to_address as receiver,

SUM(raw_amount/pow(10,18)) AS receive_amount

FROM optimism.core.fact_token_transfers

WHERE CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042'

GROUP BY 1

SELECT sender AS user, receive_amount - send_amount AS amount

FROM senders

INNER JOIN receivers

ON sender = receiver

HAVING amount > 0

ORDER BY 2 DESC

LIMIT 10