alfredfx10Top 10 NFT Collections by Volume
    Updated 2024-07-01
    SELECT PROJECT_NAME,
    SUM(PRICE_USD) AS "Sales Volume"
    FROM base.nft.ez_nft_sales
    WHERE BLOCK_TIMESTAMP >= '2024-01-01' AND
    BLOCK_TIMESTAMP<='2024-06-30'
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 10
    QueryRunArchived: QueryRun has been archived