HOLDER | TOTAL_MINTS | TOTAL_BUYS | TOTAL_SELLS | NFTS_HELD | |
|---|---|---|---|---|---|
1 | 0x1a7bb2976717336e53de6cacd08d604ca6e475c199af8dd6593ed52233a0d6c1 | 207 | 0 | 0 | 207 |
2 | 0xe7668dd0850ae518979c682d448118b9327b166f425f13d38e5128896e8d5840 | 168 | 0 | 0 | 168 |
3 | 0x20f1ce08c85cfe85415be0b4df602abf616e693d4d990d2d7bf751d46d1aff39 | 133 | 0 | 0 | 133 |
4 | 0x28c8726e00d28e687cacc37e2c679a1565f57666bffc1939f7b8e8b46c6dabbf | 111 | 0 | 0 | 111 |
5 | 0x6d5f7f84cc40b69183fbd785eb102f69ccd460c362ac8d7911d3ccd32443bb9 | 100 | 0 | 0 | 100 |
6 | 0x7e59c22228e8515b8383c7fd70d0cbc725cb82e3f64cdcf642cdfbb32156c7c7 | 60 | 17 | 0 | 77 |
7 | 0x1cc4624a2b3d626d35984cadb453846b28c720f1d53e9cccc22408d2e50c2b63 | 53 | 1 | 3 | 51 |
8 | 0x4577474bb943dfbd5c59eb7861915bc690977885d1f2790ade29406f8299e7d9 | 48 | 0 | 0 | 48 |
9 | 0xeae63240f827f8bbff49a4825e1f5c405ebaf6055cd805133f3c88a0f97c109b | 17 | 32 | 6 | 43 |
10 | 0xb66afcd4bbc9bb5bb65aff2feb41cfe81a8fe4bf9dd2a608840bfd7cc4907000 | 60 | 0 | 18 | 42 |
11 | 0x707bc637020e9ad598d5018b646e2dcd89b8da9d7d3ef30dde2836a2f4aa4157 | 0 | 79 | 39 | 40 |
12 | 0x4fa7eed75dc4411ecba66da92e1e87a9e675e7fe5b8360801873fcd8aed05e1e | 44 | 4 | 10 | 38 |
13 | 0xa81b103f908e1c7be3418810c1021658df0c09ba240adc3fe168594f6d08fbc7 | 0 | 38 | 0 | 38 |
14 | 0xf797db937531b078a2c55f7b3d76a4c8c0707e67aa656ef926c1194d65afc9a3 | 35 | 0 | 0 | 35 |
15 | 0xe5c8a0e709254a062417b3fe672e3f020dbe48dc9be23d357f2e7c266b9f407b | 0 | 33 | 0 | 33 |
16 | 0xf4bc9181266da5c400cd74706c61e8761787a6b521035304f069ef14c4e732c2 | 0 | 76 | 43 | 33 |
17 | 0x78b77f28c9b634ed2676d28883d67d3170c0df7b5b43429a815637275135831d | 0 | 61 | 32 | 29 |
18 | 0xdeb665a349e63349cde612e9a2c7d70855e4dc5785b16297008808ce5f88fa84 | 51 | 0 | 22 | 29 |
19 | 0x2cd41b3dac899713d014ecfbbc0c20d911dff60ac1e1018286e438ab108b128e | 25 | 3 | 0 | 28 |
20 | 0xd098ed4c8a4fecfd082149216a1029ff1ed3d4dffd628348b018ed00036eec22 | 10 | 15 | 0 | 25 |
aureasarsanedesPenguin Chronicles 4
Updated 21 hours 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
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-05-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='0x94a3ca2ac92e61d3c91cf1873e88d9195c1103d242caaf2ee3eb08fb6aa4939a'
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 '%Penguin Chronicles%'
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 '%Penguin Chronicles%'
GROUP BY
holder
)
SELECT
COALESCE(mints.holder, buys.holder, sells.holder) AS holder,
Last run: 6 days ago
...
631
49KB
31s