SALES_DATE | PLATFORM_NAME | DAILY_BUYERS | DAILY_SELLERS | |
|---|---|---|---|---|
1 | 2025-03-31 00:00:00.000 | BlueMove | 2 | 2 |
2 | 2025-03-31 00:00:00.000 | Mercato | 33 | 55 |
3 | 2025-03-31 00:00:00.000 | Topaz | 5 | 6 |
4 | 2025-03-31 00:00:00.000 | Wapal | 79 | 92 |
5 | 2025-04-01 00:00:00.000 | BlueMove | 2 | 2 |
6 | 2025-04-01 00:00:00.000 | Mercato | 25 | 24 |
7 | 2025-04-01 00:00:00.000 | Topaz | 4 | 3 |
8 | 2025-04-01 00:00:00.000 | Wapal | 50 | 55 |
9 | 2025-04-02 00:00:00.000 | BlueMove | 3 | 3 |
10 | 2025-04-02 00:00:00.000 | Mercato | 36 | 37 |
11 | 2025-04-02 00:00:00.000 | Topaz | 1 | 1 |
12 | 2025-04-02 00:00:00.000 | Wapal | 68 | 91 |
13 | 2025-04-03 00:00:00.000 | BlueMove | 1 | 3 |
14 | 2025-04-03 00:00:00.000 | Mercato | 23 | 28 |
15 | 2025-04-03 00:00:00.000 | Souffl3 | 1 | 2 |
16 | 2025-04-03 00:00:00.000 | Topaz | 2 | 1 |
17 | 2025-04-03 00:00:00.000 | Wapal | 38 | 48 |
18 | 2025-04-04 00:00:00.000 | BlueMove | 1 | 1 |
19 | 2025-04-04 00:00:00.000 | Mercato | 16 | 20 |
20 | 2025-04-04 00:00:00.000 | Topaz | 2 | 2 |
aureasarsanedesbattle 6
Updated 8 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS sales_date,
PLATFORM_NAME,
COUNT(DISTINCT BUYER_ADDRESS) AS daily_buyers,
COUNT(DISTINCT SELLER_ADDRESS) AS daily_sellers
FROM
aptos.nft.ez_nft_sales
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
GROUP BY
sales_date, PLATFORM_NAME
ORDER BY
sales_date, PLATFORM_NAME
Last run: 8 days ago
31
1KB
3s