m3jiMost traded NFT Collections
Updated 2025-04-02Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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