SALE_DATE | DAILY_SALES | TOTAL_SALES | DAILY_VOLUME_USD | TOTAL_VOLUME_USD | AVG_PRICE_USD | |
|---|---|---|---|---|---|---|
1 | 2025-04-15 00:00:00.000 | 13 | 13 | 188.62725 | 188.62725 | 14.509788462 |
2 | 2025-04-16 00:00:00.000 | 4 | 17 | 54.752 | 243.37925 | 13.688 |
3 | 2025-04-18 00:00:00.000 | 1 | 18 | 13.427 | 256.80625 | 13.427 |
4 | 2025-04-19 00:00:00.000 | 1 | 19 | 14.094 | 270.90025 | 14.094 |
5 | 2025-04-20 00:00:00.000 | 1 | 20 | 20.252232 | 291.152482 | 20.252232 |
aureasarsanedesamnis 2
Updated 5 days ago
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: 5 days ago
5
303B
2s