SELECT

swapper AS "Swappers",

DATE_TRUNC('day', block_timestamp) AS "Time Frame",

COUNT(DISTINCT tx_hash) AS "daily swaps"

FROM

aptos.defi.ez_dex_swaps

WHERE

(

token_in = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' -- Replace with correct token address

OR token_out = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' -- Replace with correct token address

)

AND block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'

GROUP BY

swapper,

"Time Frame"

"Swappers",

AVG("daily swaps") AS "average daily swaps",

MAX("daily swaps") AS "max daily swaps"

swap_metrics

GROUP BY

"Swappers"

ORDER BY

"average daily swaps" DESC

10;