SELECT

swapper,

COUNT(DISTINCT tx_hash) AS "total swaps",

SUM(COALESCE(amount_in_usd, 0)) AS "total usdt volume"

FROM

aptos.defi.ez_dex_swaps

WHERE

symbol_in = 'USDT'

OR symbol_out = 'USDT'

AND block_timestamp BETWEEN '2024-01-01'

AND '2024-12-31'

GROUP BY

swapper

swapper,

"total usdt volume" / NULLIF("total swaps", 0) AS "swap efficiency"

usdt_swaps

ORDER BY

"swap efficiency" DESC

10;