WALLET_ADDRESS | CURRENT_NFT_BALANCE | |
|---|---|---|
1 | 0x10c908b79ecb67e4be0ce3ef8c4e4af6583eb38c | 22 |
2 | 0xbe085c573afdb8ab9904e80a1cd9bb9964a68abd | 10 |
3 | 0x52e11df407eaf0014ad82b1fd81f9e4683db7d65 | 9 |
4 | 0xcadaa3de8bafc03d2c3dfe2fffa8a3c232777735 | 7 |
5 | 0xc84bcea0311b79dd3fa09564132c618756397419 | 7 |
6 | 0xb46bf163c3b7de6b80270ece9012a276863842f0 | 6 |
7 | 0xc272a524f26ced4d5f64211966e582cd8fecf881 | 6 |
8 | 0x0e27aa67039934a382f6cb7baad46b6c8517a635 | 5 |
9 | 0x3e284422157251fa74bf164acee94d0f03135f99 | 5 |
10 | 0x58b15d535b3de5962c4cc94c747217f808637554 | 5 |
11 | 0x460e7f6fe9d8bdc5272389801c9d44635669f596 | 5 |
12 | 0x2b9f230031d7cfa3f79e789927e80934c3e4ebc1 | 5 |
13 | 0x41ccb8544c29d887d5af91ae04c06f3080f65158 | 5 |
14 | 0x30c8d6475f329f09ce5ef17a72f48fcd17b57d5b | 5 |
15 | 0x85a04b82a0e18caaf4ff5aba707173ee52564558 | 5 |
16 | 0x20a6fcc6e46f378f8a91c1c6e66b28169b097d1f | 5 |
17 | 0x00a88c84cdb85c73035243a87a5194d78420ce21 | 5 |
18 | 0x1f65bcbbaff104cb9295e1e477e8ff23732755c6 | 5 |
19 | 0x31c2b71bef1e3b5a5d6f5226113e97e0fb4eff5b | 5 |
20 | 0x7a6d67203bcf89ddef31982a4eb3cb033a70e5a7 | 5 |
thesaw-5wHtDBTop SLMND Holders
Updated 6 days ago
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
32
33
34
35
36
›
⌄
WITH MintEvents AS (
SELECT
el.block_timestamp,
el.tx_hash,
el.contract_address,
el.topic_0,
'0x' || SUBSTR(el.topics[1], 27) AS operator,
'0x' || SUBSTR(el.topics[2], 27) AS from_address,
'0x' || SUBSTR(el.topics[3], 27) AS to_address,
utils.udf_hex_to_int(SUBSTR(el.data, 3)) AS amount
FROM monad.testnet.fact_event_logs el
WHERE el.contract_address = LOWER('0xf7b984c089534ff656097e8c6838b04c5652c947')
AND el.topic_0 IN (
'0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62', -- TransferSingle
'0x4a39dc06d4c0dbc64b70af90fd698a233a518aa5d07e595d983b8c0526c8f7fb' -- TransferBatch
)
),
TokenBalances AS (
SELECT
to_address AS wallet_address,
SUM(amount) AS nft_count
FROM MintEvents
WHERE to_address != '0x0000000000000000000000000000000000000000' -- Exclude burn address
GROUP BY to_address
UNION ALL
SELECT
from_address AS wallet_address,
-SUM(amount) AS nft_count
FROM MintEvents
WHERE from_address != '0x0000000000000000000000000000000000000000' -- Exclude mint address
GROUP BY from_address
)
SELECT
wallet_address,
Last run: 6 days ago
...
3929
188KB
14s