WALLET_ADDRESS | CURRENT_NFT_BALANCE | |
|---|---|---|
1 | 0x10c908b79ecb67e4be0ce3ef8c4e4af6583eb38c | 22 |
2 | 0xbe085c573afdb8ab9904e80a1cd9bb9964a68abd | 10 |
3 | 0x52e11df407eaf0014ad82b1fd81f9e4683db7d65 | 9 |
4 | 0xcadaa3de8bafc03d2c3dfe2fffa8a3c232777735 | 7 |
5 | 0xc84bcea0311b79dd3fa09564132c618756397419 | 7 |
6 | 0xc272a524f26ced4d5f64211966e582cd8fecf881 | 6 |
7 | 0x1cf16a258c1ed86140de36b1c2910c7517e4ecc2 | 6 |
8 | 0x010c03894a1d541d0bd92b6f8c9b1beecbc66b8a | 6 |
9 | 0xa332592a7324c733137a54b921cb55042aadbcfb | 5 |
10 | 0x5143a4569bd4149200d855eb000e10f1707d9d37 | 5 |
11 | 0xa3c49b2d5a3d76eb961e7a54ef34b1dd16419f93 | 5 |
12 | 0x3b8c4965ef1d14a3a1596e9cc646fd1b08bb5bec | 5 |
13 | 0x3e284422157251fa74bf164acee94d0f03135f99 | 5 |
14 | 0x2949c4f936cdd8233a4a3e1c2d87d7f707412802 | 5 |
15 | 0xe37265f4d5a68ae596ece9252aff790b43af76f8 | 5 |
16 | 0x281d77d22b1cc914c1f36da2e6014707e85bcefe | 5 |
17 | 0x85a04b82a0e18caaf4ff5aba707173ee52564558 | 5 |
18 | 0x2b9f230031d7cfa3f79e789927e80934c3e4ebc1 | 5 |
19 | 0x18a42053256d248645162852a030f6c15e0dcf6d | 5 |
20 | 0x68f501d53b2afd52d21ac2dcc7aff561daba27d0 | 5 |
thesaw-5wHtDBTop SLMND Holders
Updated 7 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: 7 days ago
...
3902
187KB
29s