SALE_DATE | DAILY_SALES | TOTAL_SALES | DAILY_VOLUME_USD | TOTAL_VOLUME_USD | AVG_PRICE_USD | |
|---|---|---|---|---|---|---|
1 | 2025-03-20 00:00:00.000 | 15 | 15 | 1070.2732 | 1070.2732 | 71.351546667 |
2 | 2025-03-21 00:00:00.000 | 13 | 28 | 1040.3566 | 2110.6298 | 80.027430769 |
3 | 2025-03-22 00:00:00.000 | 27 | 55 | 2157.668674 | 4268.298474 | 79.913654593 |
4 | 2025-03-23 00:00:00.000 | 8 | 63 | 673.806 | 4942.104474 | 84.22575 |
5 | 2025-03-24 00:00:00.000 | 24 | 87 | 1537.3386466 | 6479.4431206 | 64.055776942 |
6 | 2025-03-25 00:00:00.000 | 83 | 170 | 6806.917055881 | 13286.360176481 | 82.011048866 |
7 | 2025-03-26 00:00:00.000 | 329 | 499 | 9886.380415633 | 23172.740592114 | 30.049788497 |
8 | 2025-03-27 00:00:00.000 | 17 | 516 | 336.2897 | 23509.030292114 | 19.781747059 |
aureasarsanedesamnis 2
Updated 2025-03-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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 = 'Amnis Draconian' AND BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
GROUP BY
sale_date
ORDER BY
sale_date
Last run: 18 days ago
8
573B
2s