m3jiMost traded NFT Collections
    Updated 2025-04-02
    SELECT
    m.NFT_COLLECTION_NAME AS "Name of NFT Collection",
    sum(SALES_AMOUNT) AS "Sales Volume in SOL",
    count (DISTINCT sales.TX_ID) AS "No. of Sales",
    count (DISTINCT sales.PURCHASER) AS "No. of Buyers",
    count (DISTINCT sales.SELLER) AS "No. of Sellers",
    count (DISTINCT sales.mint) AS "No. of NFTs Traded"
    FROM
    solana.nft.fact_nft_sales sales
    LEFT JOIN solana.nft.dim_nft_metadata m on sales.mint = m.mint
    WHERE
    block_timestamp >= '2024-01-01'
    AND succeeded = 'TRUE'
    AND marketplace = 'solsniper'
    AND nft_collection_name IS NOT NULL
    GROUP BY
    1
    ORDER BY
    2 DESC
    LIMIT
    20;
    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived