HOLDER | TOTAL_MINTS | TOTAL_BUYS | TOTAL_SELLS | NFTS_HELD | |
|---|---|---|---|---|---|
1 | 0xbde50e7939cc5f0536a5626d113fb268949d621d81a633c75fbd6b927ec61dc3 | 304 | 0 | 0 | 304 |
2 | 0xc02399a3dadb83d363802e3fc990eceade0e9b2a9a6dc180a092a60b0c17566f | 150 | 0 | 0 | 150 |
3 | 0x953c5795bb04101055a0c89286eac6730efe2356e42691e56ba5eb31d002b2e8 | 130 | 10 | 0 | 140 |
4 | 0x640c3407f8e7f1aaf8dae1b0f2ae6b04936db8f7ab3ad9e54888f4cf4a03479f | 140 | 0 | 0 | 140 |
5 | 0x1d1921cca62b53b7be1cbebec9e70e51a03e35d9044fe72a4146e8f927097b6b | 122 | 3 | 0 | 125 |
6 | 0x2b763a9ab4d823d9d3d47794641944e0562630a4e01d9a77f9e65d6f5fa97b6c | 105 | 8 | 3 | 110 |
7 | 0x311a3609fbad18c6b5849a4588607206cc97c7ec50c3c1de90a92418a9f8be11 | 102 | 0 | 0 | 102 |
8 | 0x7159ef0384d530ba5aa176472c329897522b1b4a48363eacec4d7ff850c4e62e | 67 | 3 | 1 | 69 |
9 | 0x267e9e3b43ebf6a5929f11a81bed63c4c12d1f34fedb81e0424087213f9b251c | 56 | 1 | 7 | 50 |
10 | 0xe708b796fe3878286c9d8605a3448ddb67c1ca5d404f36bf064c0075b21db4d3 | 40 | 0 | 0 | 40 |
11 | 0xd140d2316e894ae65d1929292be33ab7fba8b263f86c1e5dc5c9cbfca7918c8c | 40 | 0 | 0 | 40 |
12 | 0x6d214ef1fb27d8e07744db7d296b91625039e7844b5454d33a21c0cf518e9601 | 32 | 0 | 0 | 32 |
13 | 0x879327d3ab971d81e5afa59439b0e69d0ed92ee7c991402c0ba702edee15b187 | 31 | 1 | 2 | 30 |
14 | 0x8b5947c9120e0ae72691d17a382e7aae54efcbbe9c279642512a319d88d0f2d0 | 25 | 1 | 0 | 26 |
15 | 0xf03791373086e2cfd8dc878204f2bdfd5210ef4b1bbe45e905c2c231e5651480 | 25 | 0 | 0 | 25 |
16 | 0xcd152e64c0414ea8d94b42b66b1d6ab805a7a34c6da62b76688bb731656439f5 | 22 | 0 | 0 | 22 |
17 | 0x41ae976fb9632accd122ba4d85fdd4417ba0337571434595de2f30f15d3a37d3 | 21 | 0 | 0 | 21 |
18 | 0x11ec35a1851d229421e2ba74203010470b08eefc6d763d11c596caa3b88db022 | 20 | 0 | 0 | 20 |
19 | 0xe38e9876eb7a583363249923b02ca41d4660f5924988c61424e8af3d33f449e8 | 20 | 0 | 0 | 20 |
20 | 0x4339a5309329ccf218b375dfee8bdcae58ee9ac27bf905c8131ed817610e51d3 | 20 | 2 | 2 | 20 |
aureasarsanedesBaptmen 4
Updated 2025-02-28
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
distinct case when xx.event_resource='TransferEvent' then xx.event_data:to end AS holder,
count(distinct case when x.event_resource='Mint' then x.event_data:index:value end) AS total_mints
FROM aptos.core.fact_events x
join aptos.core.fact_events xx on x.tx_hash=xx.tx_hash
join aptos.core.fact_events y on x.tx_hash=y.tx_hash
where date_trunc('day',x.block_timestamp)>'2025-01-01' and x.event_resource='Mint' and x.event_module='collection' and xx.event_resource='TransferEvent' and y.event_resource='DepositEvent'
and x.event_data:collection='0x7b4cd01cc85280139fbf2a11dd929a073febeba767d74904d0c691d68b74f321'
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 '%Baptmen%'
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 '%Baptmen%'
GROUP BY
holder
)
SELECT
COALESCE(mints.holder, buys.holder, sells.holder) AS holder,
Last run: about 2 months ago
...
281
22KB
328s