SALE_DATE | DAILY_SALES | TOTAL_SALES | DAILY_VOLUME_USD | TOTAL_VOLUME_USD | AVG_PRICE_USD | |
|---|---|---|---|---|---|---|
1 | 2025-03-30 00:00:00.000 | 2 | 2 | 11.747462 | 11.747462 | 5.873731 |
2 | 2025-04-01 00:00:00.000 | 8 | 10 | 38.574 | 50.321462 | 4.82175 |
3 | 2025-04-03 00:00:00.000 | 1 | 11 | 4.184 | 54.505462 | 4.184 |
4 | 2025-04-05 00:00:00.000 | 1 | 12 | 4.86 | 59.365462 | 4.86 |
5 | 2025-04-07 00:00:00.000 | 1 | 13 | 3.0015 | 62.366962 | 3.0015 |
aureasarsanedesPixel Pirates 2
Updated 5 days ago
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: 5 days ago
5
285B
2s