SALE_DATE | DAILY_SALES | TOTAL_SALES | DAILY_VOLUME_USD | TOTAL_VOLUME_USD | AVG_PRICE_USD | |
|---|---|---|---|---|---|---|
1 | 2024-09-30 00:00:00.000 | 324 | 324 | 2643.137374575 | 2643.137374575 | 8.157831403 |
2 | 2024-10-07 00:00:00.000 | 114 | 438 | 1399.31438 | 4042.451754575 | 12.274687544 |
3 | 2024-10-14 00:00:00.000 | 75 | 513 | 868.5027597 | 4910.954514275 | 11.580036796 |
4 | 2024-10-21 00:00:00.000 | 23 | 536 | 128.8124665 | 5039.766980775 | 5.600542022 |
5 | 2024-10-28 00:00:00.000 | 10 | 546 | 69.71343 | 5109.480410775 | 6.971343 |
6 | 2024-11-04 00:00:00.000 | 6 | 552 | 43.03778 | 5152.518190775 | 7.172963333 |
7 | 2024-11-11 00:00:00.000 | 3 | 555 | 21.7124 | 5174.230590775 | 7.237466667 |
8 | 2024-11-18 00:00:00.000 | 10 | 565 | 84.68196 | 5258.912550775 | 8.468196 |
9 | 2024-11-25 00:00:00.000 | 2 | 567 | 12.685 | 5271.597550775 | 6.3425 |
10 | 2024-12-02 00:00:00.000 | 3 | 570 | 24.24429 | 5295.841840775 | 8.08143 |
11 | 2024-12-09 00:00:00.000 | 33 | 603 | 329.438595 | 5625.280435775 | 9.982987727 |
12 | 2024-12-16 00:00:00.000 | 20 | 623 | 255.465319681 | 5880.745755457 | 12.773265984 |
13 | 2024-12-23 00:00:00.000 | 86 | 709 | 1438.251845607 | 7318.997601063 | 16.72385867 |
14 | 2024-12-30 00:00:00.000 | 32 | 741 | 624.436253 | 7943.433854063 | 19.513632906 |
15 | 2025-01-06 00:00:00.000 | 15 | 756 | 248.178576 | 8191.612430063 | 16.5452384 |
16 | 2025-01-13 00:00:00.000 | 33 | 789 | 580.306197663 | 8771.918627726 | 17.585036293 |
17 | 2025-01-20 00:00:00.000 | 6 | 795 | 80.8548574 | 8852.773485126 | 13.475809567 |
18 | 2025-01-27 00:00:00.000 | 7 | 802 | 73.214170848 | 8925.987655975 | 10.459167264 |
19 | 2025-02-03 00:00:00.000 | 10 | 812 | 748.975606 | 9674.963261975 | 74.8975606 |
20 | 2025-02-10 00:00:00.000 | 32 | 844 | 368.311385 | 10043.274646975 | 11.509730781 |
aureasarsanedespixel 2.2
Updated 4 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
DATE_TRUNC('week', BLOCK_TIMESTAMP) AS sale_date,
COUNT(*) AS daily_sales,
sum(daily_sales) over (order by sale_date) as total_sales,
SUM(TOTAL_PRICE_USD) AS daily_volume_usd,
sum(daily_volume_usd) over (order by sale_date) as total_volume_usd,
AVG(TOTAL_PRICE_USD) AS avg_price_usd
FROM
aptos.nft.ez_nft_sales
WHERE PROJECT_NAME = 'Pixel Pirates'
GROUP BY
sale_date
ORDER BY
sale_date
Last run: 4 days ago
27
2KB
2s