PROJECT_NAME | TOTAL_SALES_VOLUME | |
---|---|---|
1 | The Loonies | 84553.502246028 |
2 | Aptos Monkeys | 16187.679054544 |
3 | GUI Gang | 9377.024652397 |
4 | Cellana Voting Tokens | 7541.834760061 |
5 | Amnis Draconian | 7278.705639 |
6 | Aptomingos | 4675.672502116 |
7 | Yuppies Club | 4360.773666463 |
8 | MAVRIK | 3107.730886733 |
9 | Amaterasu | 2795.77354 |
10 | Bruh Bears | 2442.643989935 |
victor-sanzcapdetTop 10 Collections by Sales Volume
Updated 2025-02-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
project_name,
SUM(TOTAL_PRICE_USD) AS total_sales_volume
FROM
aptos.nft.ez_nft_sales
WHERE
block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)
AND TOTAL_PRICE_USD IS NOT NULL
AND project_name IS NOT NULL
GROUP BY
project_name
HAVING
total_sales_volume IS NOT NULL
ORDER BY
total_sales_volume DESC
LIMIT 10;
Last run: 3 months ago
10
311B
2s