MLDZMNEPA5
    Updated 2023-05-08
    select
    PROJECT_NAME as NFT_project,
    count(distinct tx_hash) as sale_no,
    count(distinct buyer_ADDRESS) as buyer_no,
    count(distinct SELLER_ADDRESS) as seller_no,
    count(distinct TOKENID) as no_NFTs,
    sum(PRICE_USD) as volume_usd,
    avg(PRICE_USD)as average_volume,
    Median(PRICE_USD) as median_volume,
    min(PRICE_USD) as floor_price,
    max(PRICE_USD) as highest_price
    from ethereum.core.ez_nft_sales
    where BLOCK_TIMESTAMP>=current_date-30
    group by 1 having NFT_project is not NULL
    order by 6 desc limit 5
    Run a query to Download Data