BUYER_RANK | COLLECTION | UNIQUE_BUYERS | TOTAL_TRANSACTIONS | VOLUME_APT | FEES_APT | |
|---|---|---|---|---|---|---|
1 | 1 | Make Every M🌐ve Count. | 191279 | 218174 | 493.18 | 7.4 |
2 | 2 | Amnis Retroactive Booster Card | 44577 | 79021 | 1828.96 | 27.43 |
3 | 3 | Aptos Connect Early Adopters | 6579 | 12548 | 2948.84 | 44.23 |
4 | 4 | APTS | 5145 | 11147 | 43.68 | 0.66 |
5 | 5 | Cellana Voting Tokens | 3821 | 8377 | 4047.64 | 60.71 |
HadisehTop 5 Collections based on buyer
Updated 8 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 wapal_sales AS (
SELECT
project_name,
buyer_address,
total_price,
platform_fee
FROM
aptos.nft.ez_nft_sales
WHERE
UPPER(platform_name) = 'WAPAL'
AND block_timestamp >= '2024-01-01'
),
collection_metrics AS (
SELECT
project_name AS collection,
COUNT(DISTINCT buyer_address) AS unique_buyers,
COUNT(*) AS total_transactions,
SUM(total_price) AS volume_apt,
SUM(platform_fee) AS fees_apt
FROM
wapal_sales
GROUP BY
project_name
HAVING
total_transactions >= 10
)
SELECT
RANK() OVER (
ORDER BY
unique_buyers DESC
) AS buyer_rank,
collection,
unique_buyers,
total_transactions,
ROUND(volume_apt, 2) AS volume_apt,
ROUND(fees_apt, 2) AS fees_apt
Last run: 8 days ago
5
266B
8s