SALES_DATE | DAILY_SALES_VOLUME | NFT_BUYERS | NFT_SALES | |
|---|---|---|---|---|
1 | 2025-04-15 00:00:00.000 | 4292.674378215 | 134 | 1135 |
2 | 2025-04-16 00:00:00.000 | 1515.175740626 | 86 | 1483 |
3 | 2025-04-17 00:00:00.000 | 1582.887045193 | 73 | 917 |
4 | 2025-04-18 00:00:00.000 | 1303.36991066 | 76 | 142 |
5 | 2025-04-19 00:00:00.000 | 895.51760167 | 57 | 146 |
6 | 2025-04-20 00:00:00.000 | 840.044551248 | 51 | 101 |
7 | 2025-04-21 00:00:00.000 | 865.435620024 | 55 | 194 |
aureasarsanedescalm-coral
Updated 5 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS sales_date,
SUM(TOTAL_PRICE_USD) AS daily_sales_volume,
count(distinct buyer_address) as nft_buyers,
count(*) as nft_sales
FROM
aptos.nft.ez_nft_sales
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -7, CURRENT_DATE) and BLOCK_TIMESTAMP < CURRENT_DATE
GROUP BY
sales_date
ORDER BY
sales_date;
Last run: 5 days ago
7
349B
3s