cypherUntitled Query
Updated 2022-11-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- credits to alik110
select count (distinct tx_hash) as Sales_Count,
count (distinct buyer_address) as Buyers_Count,
count (distinct seller_address) as Sellers_Count,
count (distinct nft_address) as Collections_Count,
count (distinct tokenid) as Tokens_Count,
sum (price_usd) as Total_USD_Volume,
avg (price_usd) as Average_USD_Volume,
median (price_usd) as Median_USD_Volume,
min (price_usd) as Min_USD_Volume,
max (price_usd) as Max_USD_Volume,
(tokens_count / 335888)*100 as Traded_To_Minted_Ratio
from ethereum.core.ez_nft_sales
where nft_address = '0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'
Run a query to Download Data