MLDZMNNFT 1
    Updated 2024-04-29
    -- What are the popular collection that are being traded on the blockchain in the past 30 days?
    select
    PROJECT_NAME as Collection,
    round(sum(price_usd), 2) as "Volume USD",
    from
    ethereum.nft.ez_nft_sales
    where
    PROJECT_NAME is not null
    and Block_timestamp >= current_date - 30
    group by
    Collection
    order by
    "Volume USD" desc
    limit
    10
    QueryRunArchived: QueryRun has been archived