HOLDER | TOTAL_MINTS | TOTAL_BUYS | TOTAL_SELLS | NFTS_HELD | |
|---|---|---|---|---|---|
1 | 0x6f446fe32a361c5512863d5e610f7d7eaa54d5cee1cea6a2712f2e56da693f1c | 0 | 96 | 0 | 96 |
2 | 0x953c5795bb04101055a0c89286eac6730efe2356e42691e56ba5eb31d002b2e8 | 0 | 81 | 0 | 81 |
3 | 0x650ebd962512a6d622eae0543703458710c604f077f39cdcee5919a638e3532f | 0 | 35 | 0 | 35 |
4 | 0x9107aa1836105136c0d618a6624982cc36220eb6cd7044a7506db3ca34309d1e | 0 | 20 | 0 | 20 |
5 | 0x7e59c22228e8515b8383c7fd70d0cbc725cb82e3f64cdcf642cdfbb32156c7c7 | 0 | 18 | 0 | 18 |
6 | 0xd83800c5041ddc09bade58c40dbadcee6a80c44231d08d56de7f0eadaee18c55 | 0 | 18 | 0 | 18 |
7 | 0xc02399a3dadb83d363802e3fc990eceade0e9b2a9a6dc180a092a60b0c17566f | 0 | 21 | 8 | 13 |
8 | 0xe559f939f5ca550cf7dd65a5809bc73ff7f9ad0e0ff84da06d2ac91f411671e0 | 0 | 12 | 0 | 12 |
9 | 0x3069769d6e92c6d4a662dda0183e8b795fa81e91ebce665d660b4b03a86f78fe | 0 | 12 | 0 | 12 |
10 | 0xae9238e251555b4a6c74089da2cf4066bb44272be1ccc206ca983520b156e3bf | 0 | 12 | 2 | 10 |
11 | 0xddd6ab72d9122ddf7d59b8cf4631d4b7eed60fb741ac64cbeaad4e2a910b608c | 0 | 8 | 0 | 8 |
12 | 0x9ce14bd263abede19dab6b0781d99459f4a8979cf7490086c69d0aaba44a07ee | 0 | 12 | 4 | 8 |
13 | 0x3a3a0d2d78ee903ff438085093553e41170ae6bb50c783e0d9f60a195b667585 | 0 | 8 | 0 | 8 |
14 | 0x2b041cfd3640a724eabd5aa011c8c76483de2e1638d63358004c937bea9e832a | 0 | 7 | 0 | 7 |
15 | 0xc86751ca6672a12e38932c88729a56d688f889a1cb1678f1cf65e551ac36f9f1 | 0 | 8 | 1 | 7 |
16 | 0xf9999d3a2728e29c25a6bed9ff9f61b03bf6b7d86cf2218a8345563714ba61ec | 0 | 7 | 0 | 7 |
17 | 0xf42e66d4ed10dfc0924b784f1b75e7a527e6e84d3cc64f8b282533cbd6b31b77 | 0 | 6 | 0 | 6 |
18 | 0x1fa5d659b315112ece29ce9b72ab070df00132067ae2715b3108ccee15b568bc | 0 | 7 | 1 | 6 |
19 | 0xd6e874769974e76c00225913bcb4f3ed3a6dcb895f7bda0f3fe7d84e83e3ab5c | 0 | 6 | 1 | 5 |
20 | 0x9f7af028979326a86bf41f0d2141b8bdb6535e2ec4bebe6978ba488667516c5b | 0 | 5 | 0 | 5 |
aureasarsanedespixel 4
Updated 4 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
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 = 'Pixel Pirates'
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 = 'Pixel Pirates'
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 = 'Pixel Pirates'
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: 4 days ago
...
394
30KB
3s