dr1888Top 5 NFT collections sold (count of sales) in last 30 days
    Updated 2023-05-07
    SELECT
    distinct project_name,
    sum(price_usd) as SALE_VOLUME,
    count(distinct tx_hash) as SALE_COUNT
    from ethereum.core.ez_nft_sales
    where block_timestamp >= current_date - 30
    and project_name is not null
    group by 1
    order by 3 desc
    limit 5
    Run a query to Download Data