PROJECT_NAME | TOTAL_SALES_VOLUME | TOTAL_SALES | |
|---|---|---|---|
1 | Milady: Type A | 7134.574136349 | 289 |
2 | The Loonies | 1306.235526 | 12 |
3 | SuperV Sidekicks | 562.707957553 | 49 |
4 | Aptos Monkeys | 485.589426 | 9 |
5 | Amnis Draconian | 291.152482 | 20 |
6 | Aptos Penguins | 257.87883658 | 262 |
7 | GUI Gang | 117.661 | 9 |
8 | Pontem Space Pirates | 103.068 | 2 |
9 | Aptomingos | 26.1288 | 1 |
10 | Painted Pandaz Gold Heartz Edition | 26.0759 | 6 |
aureasarsanedesfellow-cyan
Updated 5 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
PROJECT_NAME,
SUM(TOTAL_PRICE_USD) AS total_sales_volume,
COUNT(*) AS total_sales
FROM
aptos.nft.ez_nft_sales
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -7, CURRENT_DATE) 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: 5 days ago
10
341B
3s