COUNT(tx_hash) AS n_txs,

sum(AMOUNT_IN_USD) AS tot_in_usd,

avg(AMOUNT_IN_USD) AS avg_in_usd,

sum(AMOUNT_OUT_USD) AS tot_out_usd,

avg(AMOUNT_OUT_USD) AS avg_out_usd,

sum(AMOUNT_OUT_USD - AMOUNT_IN_USD) AS tot_net_flow,

avg(AMOUNT_OUT_USD - AMOUNT_IN_USD) AS avg_net_flow

FROM ethereum.sushi.ez_swaps

GROUP BY 1

ORDER BY 2 DESC

LIMIT 10