TOTAL_SALES | BUYERS | SELLERS | VOLUME_USD | FLOOR_PRICE_USD | AVG_PRICE_USD | |
|---|---|---|---|---|---|---|
1 | 53 | 31 | 29 | 1757.7333843 | 16.275104 | 22.535043388 |
aureasarsanedesbruh bears 1
Updated 2025-03-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT COUNT(distinct tokenid) AS total_sales,
COUNT(distinct buyer_address) as buyers,
COUNT(distinct seller_address) as sellers,
SUM(total_price_usd) as volume_usd,
min(total_price_usd) as floor_price_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)
Last run: about 1 month ago
1
48B
5s