SELECT pool_name,
--DISTINCT(ORIGIN_FROM_ADDRESS) AS user,
COUNT(tx_hash) AS n_txs,
sum(AMOUNT_IN_USD - AMOUNT_OUT_USD) AS tot_netflow
FROM optimism.sushi.ez_swaps
WHERE AMOUNT_OUT_USD IS NOT NULL AND AMOUNT_IN_USD IS NOT NULL
GROUP BY 1
ORDER BY 3 DESC
LIMIT 10