ADDRESS | BALANCE | |
---|---|---|
1 | 0xab9de3886cd4eff047db9890ccdc5e984150bc9e | 29 |
2 | 0xaf23dc0fee95454f7ebec4f2f047d480e7061ea7 | 19 |
3 | 0x1fafb6ccb7ce36c8eeb8207c5c6b0826cfeab82d | 13 |
4 | 0xf89f98425f78ece5e2d2cc719a4230a4de068511 | 10 |
5 | 0x1af49fc1ea469eb1adeb7b92a42d0cdd150062a0 | 10 |
6 | 0x7c66f2575ca9d164b20a1915dde02b7df7d886ca | 10 |
7 | 0x6f4ccf06c7847fa4b8aa68fdafdde6c05fa92078 | 9 |
8 | 0xd69c4bbe50f7393443be7feca02f349dc1002bfd | 9 |
9 | 0xdcaa7d59a1fac11b3f8d2c719482d08c3e24600c | 9 |
10 | 0xfd710eeb8fe08942f14fae4d0c35d5e02686055a | 8 |
11 | 0x4c7f2b2da663722361405955bd2ba94ee3577e9f | 8 |
12 | 0x6ec34b4e58a2d9f5bc8ddd964b7b14dcaa35df7d | 8 |
13 | 0x86e17ea9debca8c8f7a5b4009f9c37fe8d97f323 | 7 |
14 | 0xe20f4d419a86111c7b59886c4f1832cd29e8bec8 | 7 |
15 | 0x9f8d845325f7b5941803a0d8cc379848bfab012a | 7 |
16 | 0x9521012db7b9be8ae24d6c6561a73e56b6e92b8c | 7 |
17 | 0xe0affacc943ad8a45c19306fcf1053b4c103bd48 | 6 |
18 | 0xa810d04d0009e43cdcbd138dbfda5c8d1ca6ea4c | 6 |
19 | 0x32758628f7db2eaeac0bf9879e4cd16d875c1c3b | 6 |
20 | 0xc67206d602717302beffd3bbc82fc43ecea58293 | 6 |
Hessishisolated-coffee
Updated 2025-02-27
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
›
⌄
WITH nft_transfers AS (
SELECT
'0x'||SUBSTRING(TOPICS[2], 27) AS from_add,
'0x'||SUBSTRING(TOPICS[3], 27) AS to_add,
CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) AS sent_nfts
FROM monad.testnet.fact_event_logs
WHERE CONTRACT_ADDRESS = lower('0x51E6da0E284609cD96e3134B12E94b4C4F0cA241')
AND TOPICS[0] = '0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'
)
select holder as address ,
SUM(incoming) - SUM(outgoing) AS balance
FROM (
SELECT to_add AS holder, SUM(sent_nfts) AS incoming, 0 AS outgoing
FROM nft_transfers
GROUP BY to_add
UNION ALL
SELECT from_add AS holder, 0 AS incoming, SUM(sent_nfts) AS outgoing
FROM nft_transfers
GROUP BY from_add
) t
GROUP BY holder
HAVING SUM(incoming) - SUM(outgoing) > 1
order by 2 desc
Last run: 18 days ago
...
2090
100KB
27s