TOTAL_NFT_TRANSFERS | TOTAL_UNIQUE_USERS | |
|---|---|---|
1 | 34102622 | 1228863 |
permaryTotal NFT Transfers
Updated 2025-04-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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: about 2 months ago
1
20B
3s