amelia-leeCopy of Untitled Query
Updated 2022-11-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select
count (DISTINCT TX_HASH) as Sale,
count (DISTINCT BUYER_ADDRESS) as Buyers,
count (DISTINCT SELLER_ADDRESS) as Sellers,
sum (PRICE) as ETH_Price,
sum (PRICE_USD) as USD_Price,
CASE
WHEN PRICE_USD < 5 THEN 'Less than 5 USD'
WHEN PRICE_USD BETWEEN 5 and 10 THEN 'Between 5 and 10 USD'
WHEN PRICE_USD BETWEEN 10 and 50 THEN 'Between 10 and 50 USD'
WHEN PRICE_USD BETWEEN 50 and 100 THEN 'Between 50 and 100 USD'
WHEN PRICE_USD BETWEEN 100 and 500 THEN 'Between 100 and 500 USD'
ELSE 'More than 500 USD'END as type
from ethereum.core.ez_nft_sales
where NFT_ADDRESS = '0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205' and EVENT_TYPE = 'sale'
group by type
Run a query to Download Data