MLDZMNBNM3
    Updated 2023-01-14
    select --2022-10-19 launch of blur
    distinct PROJECT_NAME as NFT_collections,
    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,
    row_number() over (order by volume_usd desc) as rank1
    from ethereum.core.ez_nft_sales
    where PLATFORM_NAME ='blur'
    and PRICE_USD::float > 0
    and price>0
    and BLOCK_TIMESTAMP>='2022-10-19'
    group by 1 having NFT_collections is not NULL
    order by 6 desc limit 10
    Run a query to Download Data