SELLERS | VOLUME_CATEGORY | |
|---|---|---|
1 | 7912 | Above 300 |
2 | 51669 | Less than 20 |
3 | 3600 | 100 to 200 volume |
4 | 6117 | 20 to 50 Volume |
5 | 4029 | 50 to 100 volume |
6 | 1875 | 200 to 300 volume |
fidam Distribution of Buyers by Volume
Updated 2025-01-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
With deii AS(
SELECT
BUYER_ADDRESS,
Sum(Price_USD) as Volume
From avalanche.nft.ez_nft_sales
Group by BUYER_ADDRESS
)
SELECT
Count (DISTINCT BUYER_ADDRESS) AS Sellers,
CASE
When Volume <20 Then 'Less than 20'
When Volume BETWEEN 20 And 50 Then '20 to 50 Volume'
When Volume Between 50 And 100 Then '50 to 100 volume'
When Volume BETWEEN 100 And 200 Then '100 to 200 volume'
When Volume BETWEEN 200 AND 300 Then '200 to 300 volume'
When Volume >300 Then 'Above 300'
End as Volume_Category
From deii
Group by Volume_Category
Last run: 3 months ago
6
148B
1s