PLATFORM_NAME | SALES_COUNT | TOTAL_VOLUME_USD | |
|---|---|---|---|
1 | Wapal | 30 | 532.029718463 |
2 | Mercato | 1 | 17.29602 |
aureasarsanedespixel 3
Updated 2025-01-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
PLATFORM_NAME,
COUNT(*) AS sales_count,
SUM(TOTAL_PRICE_USD) AS total_volume_usd
FROM
aptos.nft.ez_nft_sales
WHERE
PROJECT_NAME = 'Pixel Pirates' AND BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
GROUP BY
PLATFORM_NAME
ORDER BY
total_volume_usd DESC
Last run: 3 months ago
2
51B
2s