cypherUntitled Query
    Updated 2022-11-22
    -- 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