amelia-leeCopy of Untitled Query
    Updated 2022-11-23

    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