SALE_DATE | DAILY_SALES | TOTAL_SALES | DAILY_VOLUME_USD | TOTAL_VOLUME_USD | AVG_PRICE_USD | |
|---|---|---|---|---|---|---|
1 | 2024-12-20 00:00:00.000 | 5 | 5 | 57.029399681 | 57.029399681 | 11.405879936 |
2 | 2024-12-21 00:00:00.000 | 12 | 17 | 148.03412 | 205.063519681 | 12.336176667 |
3 | 2024-12-22 00:00:00.000 | 1 | 18 | 23.375 | 228.438519681 | 23.375 |
4 | 2024-12-23 00:00:00.000 | 7 | 25 | 89.39604168 | 317.834561361 | 12.770863097 |
5 | 2024-12-24 00:00:00.000 | 4 | 29 | 57.6901024 | 375.524663761 | 14.4225256 |
6 | 2024-12-25 00:00:00.000 | 37 | 66 | 671.933987503 | 1047.458651264 | 18.160378041 |
7 | 2024-12-26 00:00:00.000 | 13 | 79 | 202.680421024 | 1250.139072288 | 15.590801617 |
8 | 2024-12-27 00:00:00.000 | 9 | 88 | 141.34368 | 1391.482752288 | 15.704853333 |
9 | 2024-12-28 00:00:00.000 | 8 | 96 | 134.3352 | 1525.817952288 | 16.7919 |
10 | 2024-12-29 00:00:00.000 | 8 | 104 | 140.872413 | 1666.690365288 | 17.609051625 |
11 | 2024-12-30 00:00:00.000 | 9 | 113 | 142.684813 | 1809.375178288 | 15.853868111 |
12 | 2024-12-31 00:00:00.000 | 6 | 119 | 128.81497 | 1938.190148288 | 21.469161667 |
13 | 2025-01-02 00:00:00.000 | 1 | 120 | 56.04 | 1994.230148288 | 56.04 |
14 | 2025-01-03 00:00:00.000 | 4 | 124 | 71.669595 | 2065.899743288 | 17.91739875 |
15 | 2025-01-04 00:00:00.000 | 1 | 125 | 16.478475 | 2082.378218288 | 16.478475 |
16 | 2025-01-05 00:00:00.000 | 11 | 136 | 208.7484 | 2291.126618288 | 18.977127273 |
17 | 2025-01-06 00:00:00.000 | 1 | 137 | 16.82031 | 2307.946928288 | 16.82031 |
18 | 2025-01-07 00:00:00.000 | 2 | 139 | 31.491052 | 2339.437980288 | 15.745526 |
19 | 2025-01-09 00:00:00.000 | 7 | 146 | 88.667313 | 2428.105293288 | 12.666759 |
20 | 2025-01-10 00:00:00.000 | 4 | 150 | 97.7158 | 2525.821093288 | 24.42895 |
aureasarsanedesPixel Pirates 2
Updated 2025-01-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
DATE_TRUNC('day', 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' AND BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
GROUP BY
sale_date
ORDER BY
sale_date
Last run: 3 months ago
27
2KB
2s