COLLECTION_NAME | CREATOR_ADDRESS | TOTAL_TRANSFERS | UNIQUE_CONTRACTS | UNIQUE_SELLERS | UNIQUE_BUYERS | |
---|---|---|---|---|---|---|
1 | ERC20Test | 0xd58d857a5d9faa5865ead06a1e99b2cef8dd24d4 | 8874842 | 3 | 2001 | 12000 |
2 | 0x3e09533c74df2181069a1ec04c425fbca8a76b50 | 3012830 | 1 | 1601 | 11597 | |
3 | 0xd58d857a5d9faa5865ead06a1e99b2cef8dd24d4 | 1327433 | 78 | 1601 | 21750 | |
4 | 0xff73ba9e0669d7ead82421ad105bc6d715606ec4 | 363935 | 3 | 11435 | 142579 | |
5 | 0xbaaf22d2bc4ac001bbdda7de73d3ae1ba71dfddb | 273961 | 21 | 23431 | 31295 | |
6 | 0x5790bc75e4d09bb7327f21a90d48ce82aad04d5e | 196526 | 3 | 4705 | 176983 | |
7 | 0x60216fb3285595f4643f9f7cddab842e799bd642 | 161766 | 33603 | 43879 | 69950 | |
8 | 0x508426ee8cb3154f4b418f6c3b6ca6294d2c043c | 82724 | 2 | 14108 | 68489 | |
9 | 0x7297fb286b8725169a688f555a437d527830839d | 76320 | 8 | 16113 | 27678 | |
10 | 0xbc24a9bcc76a2cd505fa99dea21d4509c9af3388 | 69284 | 1 | 13 | 69275 | |
11 | USD Coin | 0xbaaf22d2bc4ac001bbdda7de73d3ae1ba71dfddb | 58209 | 1 | 18259 | 25866 |
12 | 0x67a4e43c7ce69e24d495a39c43489bc7070f009b | 53037 | 3276 | 8201 | 22975 | |
13 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 42917 | 1 | 9420 | 32965 | |
14 | 0x13c6badd8e656f29e6e781abe1e86b499a9bef76 | 41559 | 2 | 12734 | 15543 | |
15 | Curvance Wrapped Bitcoin | 0xbaaf22d2bc4ac001bbdda7de73d3ae1ba71dfddb | 33246 | 1 | 10979 | 22269 |
16 | 0x923d7f0bd128d760b421f7c5af187a56325a9da5 | 31491 | 23 | 9145 | 15536 | |
17 | 0xc776cbddea014889e8bab4323c894c5c34db214d | 31062 | 2 | 5872 | 25191 | |
18 | 0x904d6cef48d78448e332b90f66e23a5aaedc1a47 | 24564 | 1 | 9018 | 11721 | |
19 | 0x39d2770abcc456f6c6be820705ed966592e0ad96 | 24155 | 2 | 2721 | 15132 | |
20 | Curvance interest-bearing USD Coin | 0xbaaf22d2bc4ac001bbdda7de73d3ae1ba71dfddb | 17406 | 1 | 8 | 17402 |
gigiokobaoverseas-orange
Updated 2025-02-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
WITH nft_transfers AS (
SELECT
el.contract_address,
el.topic_1 as from_address,
el.topic_2 as to_address,
c.name as collection_name,
c.creator_address,
COUNT(*) as transfer_count
FROM monad.testnet.fact_event_logs el
LEFT JOIN monad.testnet.dim_contracts c
ON el.contract_address = c.address
WHERE el.block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP())
-- Filter for ERC-721 Transfer event signature
AND el.topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
-- Ensure we're looking at NFT transfers (topic_3 should be empty for ERC-721)
AND el.topic_3 IS NULL
AND el.tx_succeeded = true
GROUP BY 1,2,3,4,5
)
SELECT
collection_name,
creator_address,
COUNT(*) as total_transfers,
COUNT(DISTINCT contract_address) as unique_contracts,
COUNT(DISTINCT from_address) as unique_sellers,
COUNT(DISTINCT to_address) as unique_buyers
FROM nft_transfers
WHERE creator_address IS NOT NULL
GROUP BY 1,2
ORDER BY total_transfers DESC
LIMIT 20;
Last run: 23 days ago
20
1KB
16s