HOLDER | TOTAL_MINTS | TOTAL_BUYS | TOTAL_SELLS | NFTS_HELD | |
|---|---|---|---|---|---|
1 | 0x735a0e594d5e271a570133da7b991ea023a5accf0ff11bfa6c5770f849f7eb27 | 361 | 0 | 0 | 361 |
2 | 0xa22eeda900498193486a91c97c70796bdd7f9ac22b967b851bb542b9332352c2 | 0 | 72 | 7 | 65 |
3 | 0xbf291aadb1730bf64cc8bec9231f133eabc37673ddd681bade0df3bfbcff2752 | 0 | 53 | 10 | 43 |
4 | 0x530658f45f67bd0f8fb3159732b86e8f235b86b709b04f7851f0cde382204b2f | 0 | 37 | 0 | 37 |
5 | 0xcba12c8506f1463077e62f55708f71ac606b0113008f9bde8e6b5d8ccc06e31f | 0 | 36 | 1 | 35 |
6 | 0x5b8d398315c51d2643a975b37bfc049a232b01ff0f715681f9a8c16c05aa8b54 | 0 | 26 | 0 | 26 |
7 | 0xc877cae97fdff89582fc878870f9fd7f2ec131bd1246b35eac135a8edf38d58e | 26 | 0 | 0 | 26 |
8 | 0xcff73813b04b14754d7fb6f294c9c24ed7d14f8aac5d8a97875da0fe50bd2bd3 | 0 | 22 | 1 | 21 |
9 | 0xd5f7c589d20bd42056eaf01aace89e2ee26fcb4729ba720e1bf7a2c3f11ad22a | 0 | 19 | 0 | 19 |
10 | 0x7c2bb20e5c5ba1e7edfbcf2d0de07dffc6418520b70e74bb635afafc2184a7e5 | 0 | 19 | 0 | 19 |
11 | 0xd23d18aee2582039cd7e3d91f29ac8646f222611df8af3057039fde8b1892afb | 0 | 20 | 2 | 18 |
12 | 0x1471850a0a72b56c1b698200cefb83d1c2d91d62155bce174f784aabffffab23 | 0 | 18 | 0 | 18 |
13 | 0x41da518efed026330244add70845013ce55bf85fbb4f428e9f038a3137593d4a | 0 | 16 | 0 | 16 |
14 | 0xadc753cdfe814437e57affb5a3717bed5d20de8cc56cf986fcc67f1a25712504 | 0 | 23 | 8 | 15 |
15 | 0xfab0de26db823995fe430af997ab4e80c9f0eb5071b89ff6436400860dd3e9a6 | 0 | 14 | 0 | 14 |
16 | 0x8fb8879e3870fa338858fc22c279d92e87772fd4e79002f1a51e68aa254109f | 0 | 14 | 0 | 14 |
17 | 0x4b29b5b48464040c067e4cd555c276c1f6224b2075120983d5b7543d9f20fe55 | 0 | 17 | 3 | 14 |
18 | 0x5125fe9198abdf95951e9eaca45878ef3656dca3ddd29834998cdc1c2260aba1 | 0 | 15 | 2 | 13 |
19 | 0xe2453d99aa378f06b3788332003a67bdcf8a54fd7378b7297206d2aaeaf2cac9 | 0 | 19 | 6 | 13 |
20 | 0x6978b7d33d67caea9a058795bca57d4816449e026e0389581e1802c5afcff101 | 0 | 12 | 0 | 12 |
aureasarsanedesice blue 4
Updated 2025-02-11
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 = 'Ice Blue'
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 = 'Ice Blue'
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 = 'Ice Blue'
GROUP BY
holder
)
SELECT
COALESCE(mints.holder, buys.holder, sells.holder) AS holder,
COALESCE(total_mints, 0) AS total_mints,
Last run: about 2 months ago
...
2709
210KB
3s