TO_ADDRESS | DOMAINS_HELD | |
|---|---|---|
1 | 0x3d1ee7bf1e52dc7714fcd82b891f3bd053cc17b7 | 21934 |
2 | 0xc566872a1bfdfc6ebf282e31c2375df3cfb76817 | 21105 |
3 | 0x1925117fbcdc0383a82cb28f9576775984e5b463 | 20740 |
4 | 0x04488fcfa466c475774f8c81f21e1d7b492af7bc | 20676 |
5 | 0x1e218dc9c7d7b46e9c523d001885ccde24320342 | 20315 |
6 | 0xb694270bc8cbae2bc547f5927c5111c701b5310b | 20097 |
7 | 0xfda8801ee7889c6b5cb40ea52e33d8a1ab0ed848 | 19869 |
8 | 0x77a9ae2945bc752ecd68681e0136810b86be650d | 19472 |
9 | 0x687e68d91beef5ac78a42aa5318696ac3b35d082 | 19319 |
10 | 0xf0faf6271cd0aed0f94cdc97df765d8c059e4e2f | 18639 |
11 | 0xe92507d9a26658045ae41b5e956d58cfee173921 | 16520 |
12 | 0xcfb1de993bd67530fa188e0e7ea1fb4778a7088c | 16049 |
13 | 0x4ac1fbdbb6fbd1ca0324b950a85accb5d07aceda | 15835 |
14 | 0xcb7cea323b75efdcea5899df04b109e1aed94640 | 15337 |
15 | 0xa80cc87a2f5a1dae58244e3d76450c30df12492c | 14911 |
16 | 0x61b59d4b821f3c670fac06e891cc22cffba6073d | 14870 |
17 | 0x41e1913ce4f60c77aa8c2a6d9ee9fe81d804381e | 14362 |
18 | 0x9bf90921f44aaebb4de65e312b5c37ef792d211e | 13599 |
19 | 0x9f4ae8de58036267681a1d2d899bb100cef9899f | 13249 |
20 | 0x1a7be8a2e038a49aa160b1ab06035390828d8cca | 13177 |
Monad Metrics GuildTop 100 Holders of Nad Name Service
Updated 3 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
›
⌄
with base as (
select
block_timestamp,
tx_hash,
'0x' || substr(topic_1, 27) as from_address,
'0x' || substr(topic_2, 27) as to_address,
livequery.utils.udf_hex_to_int(topic_3) as token_id
from monad.testnet.fact_event_logs
where contract_address = '0x3019bf1dfb84e5b46ca9d0eec37de08a59a41308'
and topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
),
currentdomains_held as (
select
to_address,
token_id,
from base
qualify row_number() over(partition by token_id order by block_timestamp desc) = 1
)
select
to_address,
count(token_id) as domains_held
from currentdomains_held
group by 1
order by 2 desc
limit 100
Last run: 3 days ago
100
5KB
27s