HOLDER | TOTAL_MINTS | TOTAL_BUYS | TOTAL_SELLS | NFTS_HELD | |
|---|---|---|---|---|---|
1 | 0x39cadde3707b8f38c26922a85370cfa57ecd1c6e93f9a9339d281ac1aae35919 | 0 | 45 | 0 | 45 |
2 | 0x43fd23fcc7df5599c4f86d88ae2f54fef4ee05ec1948ec416c9bf0c9d39de699 | 0 | 25 | 0 | 25 |
3 | 0x1cc4624a2b3d626d35984cadb453846b28c720f1d53e9cccc22408d2e50c2b63 | 0 | 27 | 4 | 23 |
4 | 0x502f531cffbd05b3492b479b4ef43dffbe8ef76b54445fb86c38ab0971158d79 | 0 | 30 | 8 | 22 |
5 | 0x1dcd901b01dbb540b62118a65cd06e95ad4484d11a1f7bef140c2ed24871927a | 0 | 21 | 0 | 21 |
6 | 0x973a372db99c9fb7906a8f8488dd90420ee059e1232d7d08cadf70e4910d7686 | 0 | 14 | 0 | 14 |
7 | 0x8ccc7bb4626a43af0e337e0dcdefa96ab208f3f30e74359a186b59fe634d9a6a | 0 | 14 | 0 | 14 |
8 | 0x79ff5ea5d030a8224cef0f656699ec473cc88cb0b0cb75b106e938b419dfcb00 | 0 | 12 | 0 | 12 |
9 | 0x2522f0f64eb3866214afe0e3097b16453881810ea356e9c1d700ab27b3dd0f4a | 0 | 22 | 10 | 12 |
10 | 0xf351e0d8c347f0aa11359853b82a8920dffa5a97a9be4cff1b8afb6aca9d97e5 | 0 | 11 | 0 | 11 |
11 | 0xe32fe84095979a55dcbc32d0fa63a7e161a73dab0da08870e94d5029a1aa6130 | 0 | 11 | 0 | 11 |
12 | 0x64abbb2bbbbd63a6dd7705641e056feb80a5c25acbadb9faadb15c05fe6f11c0 | 0 | 10 | 0 | 10 |
13 | 0xe8a40a0cf1dda703e7a851ce317b4a315b85b8a71a106a460a76ec6da7201f10 | 0 | 18 | 8 | 10 |
14 | 0xfdd89934dc12499db1f63739420fa7c71099d773f9548bcb400cee1ce1d71af7 | 0 | 10 | 0 | 10 |
15 | 0x3bebfdc91b5e0804d0f47a7fe1ef9066d4a14380a9ff3b39bd78838fae9b81e6 | 0 | 10 | 0 | 10 |
16 | 0x8ba0e1fc2c7735ccc23a7bf29ff50112745e8f9b28fcf95b4a960f8d4c4cd76a | 0 | 10 | 0 | 10 |
17 | 0x61c6d479459fa170a6cca59343c5793751313674c74d7896b88832bd0ffa224c | 0 | 11 | 2 | 9 |
18 | 0x41d5a19abf1ffd263d9685c62f2240839cbeac4ef446d02c0c0f43aa1914eda0 | 0 | 9 | 0 | 9 |
19 | 0x9e453e9e370508a84d9c23fa59f60452c98f1d3c38a0df5fff02b127bc42d2d | 0 | 11 | 2 | 9 |
20 | 0x276f7be7a66c40cd42715a3c3095c2e1ce2942f6ae3f78fe3d9100da1ed45bba | 0 | 9 | 0 | 9 |
aureasarsanedesBruh Bears 4
Updated 2025-03-14
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 x.event_resource='Mint' and x.event_module='collection' and xx.event_resource='TransferEvent' and y.event_resource='DepositEvent'
and x.event_data:collection ilike '%0x43ec2cb158e3569842d537740fd53403e992b9e7349cc5d3dfaa5aff8faaef2%'
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 '%Bruh Bears%'
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 '%Bruh Bears%'
GROUP BY
holder
)
SELECT
COALESCE(mints.holder, buys.holder, sells.holder) AS holder,
Last run: about 1 month ago
...
4009
309KB
84s