MLDZMNENI8
Updated 2023-01-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
CASE
WHEN PRICE_USD < 5 then 'a. Below 5'
WHEN PRICE_USD < 100 then 'b. 5 - 100'
WHEN PRICE_USD < 500 then 'c. 100 - 500'
WHEN PRICE_USD < 2000 then 'd. 500 - 2,000'
WHEN PRICE_USD >= 2000 then 'e. Over 2,000'
end as gp,
count(distinct tx_hash) as sale_no,
count(distinct BUYER_ADDRESS) as buyer_no
from ethereum.core.ez_nft_sales
where PRICE_USD::float > 0
and price>0
and BLOCK_TIMESTAMP between '2022-01-01' and '2023-01-01'
group by 1
Run a query to Download Data