HOLDER | TOTAL_MINTS | TOTAL_BUYS | TOTAL_SELLS | NFTS_HELD | |
|---|---|---|---|---|---|
1 | 0x2e76367356634729becd59d82e48c2c04982ab435abddb724b7c4bdb3ae10e20 | 0 | 39 | 0 | 39 |
2 | 0x3533c095209d0d77152780d81bc19b8526c0be1d06dd7d1aed2d871b19ee0aec | 0 | 28 | 0 | 28 |
3 | 0xb4576a3ec891f0508aedf9b907391e8aa2e467704f321a615cae8c8c730db76f | 0 | 33 | 9 | 24 |
4 | 0xd6e874769974e76c00225913bcb4f3ed3a6dcb895f7bda0f3fe7d84e83e3ab5c | 0 | 20 | 0 | 20 |
5 | 0x930d4087c600477abc79d0ceeefed3ece507f71d28750e0067a155cb945a832 | 0 | 16 | 0 | 16 |
6 | 0x487bfed293cafc24643f1b445fa5fdc61592c45a056c69dc166205a46482587e | 0 | 15 | 0 | 15 |
7 | 0x8c557bb0a12d47c1eda90dd4883b44674111b915fa39ff862e6a0a39140dcd4 | 0 | 15 | 1 | 14 |
8 | 0xfe74d60c887d076783a03a2a52ca4a500082758afa357c5ea0ca12999c449f7c | 0 | 14 | 1 | 13 |
9 | 0x66722c291fb31ed4fb9a407d4b464906060deaf69f3509386eccb208efcd9b40 | 0 | 12 | 0 | 12 |
10 | 0xb291d512ebe33cf7e6a00198528333bc666b6a7229830fee5a8cebffcf3ef7d4 | 0 | 12 | 0 | 12 |
11 | 0x509ff88e13e32b076faea57d4d645f9c974dddab2283fc04fe2f37f7a85a8c37 | 0 | 11 | 0 | 11 |
12 | 0x8d2eaaf052ae4026e83937fc76ac7c89e7f5695f586ef35c8b1044ac42ea7f43 | 0 | 12 | 2 | 10 |
13 | 0x353e37d31573e4abadc0cd033587273562265f9c05701e6d4134595fe42e29e1 | 0 | 10 | 0 | 10 |
14 | 0x56ac50b3bcd61d4cff133e262df4a73d5cd1c714a16e58c0faacf3bde99af4a3 | 0 | 10 | 1 | 9 |
15 | 0x59af92b856148bcf4e83129554147ae598613bed55ed314ca1d6af3cd0cc968e | 0 | 9 | 0 | 9 |
16 | 0x91ee92a59c8f29b9a312d8270d536e92a390578a0475588e3a20d91450e5107d | 0 | 10 | 1 | 9 |
17 | 0x6d6bd480bb690713133731c7413ad6066494a71b098cb1313c4f66799f8d2fff | 0 | 8 | 0 | 8 |
18 | 0xc02399a3dadb83d363802e3fc990eceade0e9b2a9a6dc180a092a60b0c17566f | 0 | 7 | 0 | 7 |
19 | 0xc5525850fdc38e95b00a7f2fb243d72829255adbae5cd91147a91241fa5e5a68 | 0 | 6 | 0 | 6 |
20 | 0x851e8432b2feb0e29d55131a98560fb326c262402301e8f68449ee88b1433b5e | 0 | 14 | 8 | 6 |
aureasarsanedesGUI Gang 4
Updated 2025-04-07
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
34
35
36
›
⌄
WITH mints AS (
SELECT
NFT_TO_ADDRESS AS holder,
SUM(NFT_COUNT) AS total_mints
FROM
aptos.nft.ez_nft_mints
WHERE
PROJECT_NAME ilike '%Gui Gang%'
GROUP BY
holder
),
buys AS (
SELECT
BUYER_ADDRESS AS holder,
COUNT(distinct tokenid) AS total_buys
FROM
aptos.nft.ez_nft_sales
WHERE
PROJECT_NAME ilike '%Gui Gang%'
GROUP BY
holder
),
sells AS (
SELECT
SELLER_ADDRESS AS holder,
COUNT(distinct tokenid) AS total_sells
FROM
aptos.nft.ez_nft_sales
WHERE
PROJECT_NAME ilike '%Gui Gang%'
GROUP BY
holder
)
SELECT
COALESCE(mints.holder, buys.holder, sells.holder) AS holder,
case when COALESCE(total_mints, 0) + COALESCE(total_buys, 0) - COALESCE(total_sells, 0)<0 then abs(COALESCE(total_mints, 0) + COALESCE(total_buys, 0) - COALESCE(total_sells, 0)) else
Last run: 19 days ago
...
795
61KB
7s