PLATFORM_NAME | UNIQUE_BUYERS | UNIQUE_SELLERS | |
---|---|---|---|
1 | Wapal | 305 | 432 |
2 | Mercato | 89 | 118 |
3 | BlueMove | 21 | 23 |
4 | Topaz | 8 | 6 |
aureasarsanedesbattle 3
Updated 5 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
PLATFORM_NAME,
COUNT(DISTINCT BUYER_ADDRESS) AS unique_buyers,
COUNT(DISTINCT SELLER_ADDRESS) AS unique_sellers
FROM
aptos.nft.ez_nft_sales
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
GROUP BY
PLATFORM_NAME
ORDER BY
unique_buyers DESC
Last run: 5 days ago
4
71B
8s