PLATFORM | TRADERS | |
---|---|---|
1 | cellana | 636 |
2 | thala | 168 |
3 | liquidswap | 163 |
4 | pancake | 46 |
5 | sushi | 24 |
6 | hippo | 20 |
feyikemiAptos Whales Per Platform
Updated 2025-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
--Adopted from Masi https://flipsidecrypto.xyz/Masi/dashboards
WITH Stats AS (
SELECT
Platform,
Swapper,
SUM(COALESCE(amount_in_usd, amount_out_usd)) AS Total_Traded_Volume
FROM
aptos.defi.ez_dex_swaps
WHERE block_timestamp::DATE >= '{{Start_Date}}'
AND amount_in_usd < 1e6
AND amount_out_usd < 1e6
GROUP BY 1, 2
)
SELECT
Platform,
COUNT(DISTINCT Swapper) AS Traders
FROM Stats
WHERE Total_Traded_Volume > 1000000
GROUP BY Platform
ORDER BY Traders DESC
Last run: 2 months ago
6
91B
7s