MLDZMNnft1
    Updated 2023-04-08
    select
    TOKENID as mint,
    count(distinct tx_hash) as sale_no,
    count(distinct BUYER_ADDRESS) as buyers,
    sum(price_USD) as volume
    --avg(price_USD) as volume_usd
    from ethereum.core.ez_nft_sales
    where price_usd is not NULL
    and CREATOR_FEE_USD is not null
    and NFT_ADDRESS='0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38'
    group by 1
    order by 2 desc limit 10
    Run a query to Download Data