NFT_COLLECTION | TOTAL_NFT_TRANSFERS | TOTAL_UNIQUE_USERS | |
|---|---|---|---|
1 | Pixel Dungeons Items | 26006702 | 246211 |
2 | Axie | 2200773 | 389639 |
3 | Axie Consumable Item | 1214695 | 46378 |
4 | Wild Forest Units | 746990 | 15118 |
5 | PHZM | 510093 | 32915 |
6 | Axie Material | 503010 | 45028 |
7 | Nyang Kit | 386787 | 34986 |
8 | Jin on a Sailing Ship | 325224 | 325225 |
9 | Ronke on a Sailing Ship | 270357 | 270358 |
10 | Ragnarok Monsters | 181512 | 11454 |
permaryTop 10 nft collections
Updated 2025-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
COALESCE (nt.name,nt.contract_address )AS nft_collection,
COUNT(*) AS total_nft_transfers,
COUNT(DISTINCT nt.from_address) + COUNT(DISTINCT nt.to_address) AS total_unique_users,
-- SUM(nt.amount_usd) AS total_nft_volume_usd
FROM ronin.nft.ez_nft_transfers nt
LEFT JOIN ronin.core.dim_labels dl
ON nt.contract_address = dl.address -- Categorizing by collection name
WHERE nt.block_timestamp >= '2025-01-01'
AND nt.block_timestamp < '2025-04-01'
GROUP BY 1
ORDER BY 2 DESC;
limit 10
Last run: 12 days ago
10
337B
6s