TRADER | # Swaps | 💲 Total Volume | BUY_TXS | 💲 Buy Volume | SELL_TXS | 💲 Sell Volume | 💲 Net Volume | |
|---|---|---|---|---|---|---|---|---|
1 | petra.apt | 4432 | 531188.3 | 2778 | 272130 | 3275 | 259058.3 | 13071.7 |
2 | apt321.apt | 70 | 65107.2 | 22 | 33648 | 48 | 31459.2 | 2188.8 |
3 | 0xc4ed27a01fdc83055877823893ca60b634d974dd361cf37394a5eab3ebcc4267 | 77 | 59780.2 | 39 | 29833.6 | 38 | 29946.6 | -113 |
4 | 0xschna.apt | 245 | 54749.3 | 123 | 27367.8 | 122 | 27381.5 | -13.7 |
5 | 0x625291f4e529c4315830dcdadaae8a78202e326a32d565eb415539d989d8bc4a | 1566 | 52221.4 | 780 | 26142.9 | 786 | 26078.5 | 64.4 |
6 | web3gamer.apt | 86 | 46986.9 | 27 | 24538.9 | 59 | 22448 | 2090.9 |
7 | 0x596a8142c392e03ccb11ee59b106519076b60c63f22bce3baf33896fd5510aa4 | 92 | 43733.2 | 39 | 21343 | 53 | 22390.2 | -1047.2 |
8 | 0x131987789c1ba42c36a5c5aa0d03668fb872c4e69544edd000385d36ab42108 | 85 | 39292.9 | 45 | 19839.9 | 40 | 19453 | 386.9 |
9 | 0xff4bbfcb7eea1817b02d13b52a5189dac2f293a1e2881d69b6a53a211a8d59db | 4618 | 36656.4 | 2308 | 18328.6 | 2310 | 18327.7 | 0.9 |
10 | 0xbffaac32e14559e198e8916d099d3f90f8441b6b95ec98a6f8fa7e182d0656dc | 3287 | 35183.8 | 1643 | 17593.6 | 1644 | 17590.2 | 3.4 |
11 | 0x674dde5bc7a4c62718a823a5f03c9f67b05454bcfe18734f72fad0f5663e9d16 | 74 | 33221.8 | 38 | 16820 | 36 | 16401.9 | 418.1 |
12 | 0xc2ba8ce1240a57d3cc4cfae77554706ccb47b5468a64f853ef005c5fa5bff378 | 471 | 32328.4 | 236 | 16157.6 | 235 | 16170.8 | -13.2 |
13 | onemore.apt | 105 | 31036.7 | 50 | 15203.3 | 55 | 15833.4 | -630.1 |
14 | 072.apt | 6 | 30294.7 | 2 | 7881.1 | 4 | 22413.6 | -14532.5 |
15 | 0x3917da9a5c5e891fee84a5e6aa7a2d9c239bbb1e1004a5af36c3db5bfde45c6 | 84 | 26044.9 | 26 | 14239.6 | 58 | 11805.3 | 2434.3 |
16 | 0xd67f4c0f312cd41ae1b41430d5628214b588a51cd14de356ebcd9fac600ce9a0 | 37 | 20977 | 23 | 13256.2 | 14 | 7720.8 | 5535.4 |
17 | 0xaebade21628a6e3504e02f907c8b10063c6fd794349d9d0fbaaa5933e020b946 | 61 | 19435.8 | 17 | 10796.1 | 44 | 8639.7 | 2156.4 |
18 | kaytrandt.apt | 82 | 19413.8 | 44 | 9247.8 | 38 | 10165.9 | -918.1 |
19 | khanhtrandt.apt | 82 | 19413.8 | 44 | 9247.8 | 38 | 10165.9 | -918.1 |
20 | malymlk.apt | 71 | 16206 | 24 | 7818 | 47 | 8388.1 | -570.1 |
0xHaM-dTop Swappers
Updated 2025-05-12
999
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
34
35
36
›
⌄
with
token_info as (
select
token_address,
symbol,
name,
decimals
from aptos.core.dim_tokens
)
,prices as (
select
hour::date as p_date,
symbol,
decimals,
token_address,
avg(price) as avg_price
from aptos.price.ez_prices_hourly
GROUP by 1, 2, 3, 4
)
, swaps as (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
EVENT_DATA,
EVENT_TYPE,
sender as swapper,
CASE
WHEN event_data:x_in :: int = 0 THEN TRIM(SPLIT_PART(SPLIT(event_type, ',')[1], ' ',2) :: string, '>')
WHEN event_data:x_in :: int != 0 THEN TRIM(SPLIT_PART(SPLIT(event_type, ',')[0], '<', 2) :: string, ' ')
END AS token_in,
CASE
WHEN event_data:y_in :: int = 0 THEN TRIM(SPLIT_PART(SPLIT(event_type, ',')[1], ' ',2) :: string, '>')
WHEN event_data:y_in :: int != 0 THEN TRIM(SPLIT_PART(SPLIT(event_type, ',')[0], '<', 2) :: string, ' ')
END AS token_out,
CASE
WHEN event_data : x_in :: int = 0 THEN event_data : y_in :: int
Last run: about 1 month ago
100
8KB
151s