SALE_DATE | DAILY_SALES | TOTAL_SALES | DAILY_VOLUME_USD | TOTAL_VOLUME_USD | AVG_PRICE_USD | |
|---|---|---|---|---|---|---|
1 | 2025-02-12 00:00:00.000 | 4 | 4 | 95.12264 | 95.12264 | 23.78066 |
2 | 2025-02-13 00:00:00.000 | 1 | 5 | 24.557544 | 119.680184 | 24.557544 |
3 | 2025-02-14 00:00:00.000 | 3 | 8 | 67.63195 | 187.312134 | 22.543983333 |
4 | 2025-02-16 00:00:00.000 | 1 | 9 | 18.26292 | 205.575054 | 18.26292 |
5 | 2025-02-18 00:00:00.000 | 4 | 13 | 88.323 | 293.898054 | 22.08075 |
6 | 2025-02-19 00:00:00.000 | 11 | 24 | 277.493208 | 571.391262 | 25.226655273 |
7 | 2025-02-20 00:00:00.000 | 3 | 27 | 82.926244 | 654.317506 | 27.642081333 |
8 | 2025-02-21 00:00:00.000 | 1 | 28 | 23.44 | 677.757506 | 23.44 |
9 | 2025-02-22 00:00:00.000 | 7 | 35 | 158.829652 | 836.587158 | 22.689950286 |
10 | 2025-02-23 00:00:00.000 | 3 | 38 | 71.764403 | 908.351561 | 23.921467667 |
11 | 2025-02-25 00:00:00.000 | 8 | 46 | 146.268996 | 1054.620557 | 18.2836245 |
12 | 2025-02-26 00:00:00.000 | 1 | 47 | 22.56 | 1077.180557 | 22.56 |
13 | 2025-02-27 00:00:00.000 | 3 | 50 | 59.524231 | 1136.704788 | 19.841410333 |
14 | 2025-02-28 00:00:00.000 | 9 | 59 | 235.09824 | 1371.803028 | 26.122026667 |
15 | 2025-03-01 00:00:00.000 | 6 | 65 | 121.911828 | 1493.714856 | 20.318638 |
16 | 2025-03-02 00:00:00.000 | 7 | 72 | 143.6022459 | 1637.3171019 | 20.514606557 |
17 | 2025-03-05 00:00:00.000 | 1 | 73 | 26.845728 | 1664.1628299 | 26.845728 |
18 | 2025-03-06 00:00:00.000 | 1 | 74 | 27.77352 | 1691.9363499 | 27.77352 |
19 | 2025-03-11 00:00:00.000 | 4 | 78 | 65.7970344 | 1757.7333843 | 16.4492586 |
aureasarsanedesBruh Bears 2
Updated 2025-03-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
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 ilike '%Bruh Bears%' AND BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
GROUP BY
sale_date
ORDER BY
sale_date
Last run: about 1 month ago
19
1KB
2s