total swappers | Total USDT Volume Sold | Total USDT Volume Bought | |
|---|---|---|---|
1 | 0xd7257c62806cea85fc8eaf947377b672fe062b81e6c0b19b6d8a3f408e59cf8c | 68512841.1771191 | 68189393.3010317 |
2 | 0x7d7e8bf13228c3eb22c0ba8924a9a916ce17a212643ac962ac9751f6e86f9b60 | 13426213.3594759 | 13429954.5859358 |
3 | 0x30521da32eb4b8b25d495a561ac368d17b499b10803efb4b569fc64963e42396 | 12263977.275757 | 12265684.9869816 |
4 | 0x3acf837b72c8f22b2b2af46ab962c2faf32578e6572b9c4c1838b9a9b55cad86 | 8399284.2217295 | 9194467.24798824 |
5 | 0x4467f8be8debe5daf2d46a27e9154620ed2534346eda1c5bb88a11317d03f046 | 5264951.22242182 | 5265231.42306055 |
6 | 0x75bafa65a5c98865a54283f8a615f5aac30a10a6270d799915cb52ef14ef0e07 | 5252187.52897002 | 4781224.68017635 |
7 | 0xeb9da077dd4abf8144ea815281410bb9164c338a90f4e2407527a52fbd295614 | 4740324.02428664 | 4744001.33471662 |
8 | 0x46ec512b8d1c2ab7cf26c8230d16589bcea9c828cf05d5f6a2e254efea448a05 | 4163232.1276674 | 4163811.97965947 |
9 | 0x6140830a1c775e2fd4627b9f74d0823562c0046e41dcb6b0b2e8720d038c4711 | 4009645.70172118 | 3549576.25045376 |
10 | 0xa5cfe99b16ef928115a8396578cdb3a512d8d1e71c89f4382de3a7e206ffb743 | 3295029.53037866 | 3295029.53037866 |
datavortexTop Swappers (Whales) by USDT Volume
Updated 10 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
WITH swaps_metrics AS (
SELECT
swapper AS "total swappers",
token_in AS "sold symbol",
token_out AS "bought symbol",
COALESCE(amount_in_usd, 0) AS "sold amount",
COALESCE(amount_out_usd, 0) AS "bought amount"
FROM
aptos.defi.ez_dex_swaps
WHERE
(token_in = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT'
OR token_out = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT')
AND block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
)
SELECT
"total swappers",
SUM(CASE
WHEN "sold symbol" = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' THEN COALESCE("sold amount", 0)
ELSE 0
END) AS "Total USDT Volume Sold",
SUM(CASE
WHEN "bought symbol" = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' THEN COALESCE("bought amount", 0)
ELSE 0
END) AS "Total USDT Volume Bought"
FROM
swaps_metrics
GROUP BY
"total swappers"
ORDER BY
"Total USDT Volume Sold" DESC
LIMIT
10;
Last run: 10 days ago
10
1KB
5s