MLDZMNpd1
Updated 2023-08-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
CASE WHEN (price_USD) <= 500 THEN 'a.below 500'
WHEN (price_USD) > 500 and (price_USD) <=2000 THEN 'b.500-2000'
WHEN (price_USD) > 2000 and (price_USD) <=10000 THEN 'c.2000-10000'
WHEN (price_USD) > 10000 and (price_USD) <=50000 THEN 'd.10000-50000'
WHEN (price_USD) > 50000 THEN 'e.above 50000'
END as buckets,
count(distinct tx_hash) as sale_no,
count(distinct BUYER_ADDRESS) as buyer_no
from ethereum.core.ez_nft_sales
where NFT_ADDRESS='0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38'
and price_usd>0
group by 1
Run a query to Download Data