TOTAL_SALES | SELF_TRADES | UNIQUE_BUYERS | UNIQUE_SELLERS | AVG_PRICE_USD | MAX_PRICE_USD | MIN_PRICE_USD | WALLET_CONCENTRATION_RATIO | |
|---|---|---|---|---|---|---|---|---|
1 | 274780 | 109 | 28259 | 31148 | 75.83616308 | 10367.819544782 | 0 | 0.4054443555 |
bobby_daniel3-NFT With Legit Sales
Updated 2025-04-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
COUNT(DISTINCT s.tx_id) as total_sales,
COUNT(DISTINCT CASE WHEN s.buyer_address = s.seller_address THEN s.tx_id END) AS self_trades,
COUNT(DISTINCT s.buyer_address) AS unique_buyers,
COUNT(DISTINCT s.seller_address) AS unique_sellers,
AVG(s.price_usd) AS avg_price_usd,
MAX(s.price_usd) AS max_price_usd,
MIN(s.price_usd) AS min_price_usd,
COUNT(DISTINCT s.buyer_address || s.seller_address)::FLOAT / NULLIF(COUNT(DISTINCT s.tx_id), 0) as wallet_concentration_ratio
FROM solana.nft.ez_nft_sales s
WHERE s.block_timestamp >= CURRENT_DATE - 30
AND s.succeeded = TRUE
HAVING
COUNT(DISTINCT s.tx_id) >= 3
AND (COUNT(DISTINCT s.buyer_address) + COUNT(DISTINCT s.seller_address)) >= 2
AND MAX(s.price) > AVG(s.price) * 1.5
ORDER BY total_sales DESC;
Last run: 25 days ago
1
69B
3s