SWAPPER | swap efficiency | |
|---|---|---|
1 | 0x4661065fb83060384e9e4a263c851baab9d4b05aa5353ad8e79d588c81425d44 | 260514.011715336 |
2 | 0x691c753ecafc8ed339c6133ffee0b120a2b7c8f9ef2cb9b65d3e7a6c9b3bcdd3 | 254076.889067 |
3 | 0xf23970708b3cdcc3c51470f868235e562002bc108073379c4adbabb4b5f61957 | 124614.733108904 |
4 | 0x20effa76a78ab6993c1f737069876f1181a0233fd38e09209611032a64d9728f | 119829.72 |
5 | 0x4414b4e8c98349c462d60d42cb7368968a32f41114e6b0514e23e1072f0ad2a6 | 117706.607422295 |
6 | 0x1d23332475a79a653fdddbc20df3c6dd42c7efefdcc7b61d94a0ecf0893ccc33 | 107904.39843719 |
7 | 0xad7d9878c04e1415336fddd42a58022c5e4bc78b9d2e7a9665a7ca46b4b5d7f4 | 107495.098575696 |
8 | 0x7d02d6e184ec973721ad4347e5af55f17b148be1c42d2fdd2631d25e9d09db4c | 100600 |
9 | 0x53c3c08d3c52bcc92aa41f27de73467003598ccd1ffd9769e64d570b8052cf0d | 100007.09439721 |
10 | 0x99d738da85f335edf27e6f5f5567caaa7cc82cb336f64da4b95a45ec3cc6ee6e | 99741.2 |
datavortexSwap Efficiency Per Top Swapper
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
›
⌄
WITH usdt_swaps AS (
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
)
SELECT
swapper,
"total usdt volume" / NULLIF("total swaps", 0) AS "swap efficiency"
FROM
usdt_swaps
ORDER BY
"swap efficiency" DESC
LIMIT
10;
Last run: 10 days ago
10
850B
12s