OWNER | ENS_NAME | LABEL | |
|---|---|---|---|
1 | 0xffc9a5ecf39dba2bf0b8b2c4d843bfd70b1a6082 | dreamersmoca | 🔴 Not Primary |
2 | 0xffb8c9ec9951b1d22ae0676a8965de43412ceb7d | tokito182 | 🟢 Primary Domain |
3 | 0xff3ac23ea2c27bf6994ca90f6185b60d516c1a9a | aamafia | 🔴 Not Primary |
4 | 0xff3ac23ea2c27bf6994ca90f6185b60d516c1a9a | niard | 🟢 Primary Domain |
5 | 0xff3ac23ea2c27bf6994ca90f6185b60d516c1a9a | niardo | 🔴 Not Primary |
6 | 0xfee2c0c52eb0f05f3dccccd0d857bc0f3f9f6c94 | ogzgzy | 🔴 Not Primary |
7 | 0xfe468f9214c20cfd4d11dae68f3abda8873a0847 | softhearted | 🟢 Primary Domain |
8 | 0xfe468f9214c20cfd4d11dae68f3abda8873a0847 | whalemembers | 🔴 Not Primary |
9 | 0xfde9cbc7c830addc475d616c3cf6773002fb2d32 | 223301 | 🔴 Not Primary |
10 | 0xfde9cbc7c830addc475d616c3cf6773002fb2d32 | 889908 | 🟢 Primary Domain |
11 | 0xfd211ee23506e82938c88dc140e2d88f851e2039 | apedrian | 🟢 Primary Domain |
12 | 0xfcae89f3319c760d4f481a522aa717af81e93e77 | gl1tch | 🟢 Primary Domain |
13 | 0xfc961534a0a55b925db2c5ee546c8a019c0d78d5 | majinidao | 🔴 Not Primary |
14 | 0xfc961534a0a55b925db2c5ee546c8a019c0d78d5 | crypt0rx | 🔴 Not Primary |
15 | 0xfc961534a0a55b925db2c5ee546c8a019c0d78d5 | aibra | 🟢 Primary Domain |
16 | 0xfc5a080c6ec2a047e1da3b862af83bbf20632263 | ocbc | 🔴 Not Primary |
17 | 0xfc0aa8e31375e619d4612523295761ea9b75b552 | akiraneo | 🔴 Not Primary |
18 | 0xfc0aa8e31375e619d4612523295761ea9b75b552 | yayoikusamarian | 🔴 Not Primary |
19 | 0xfc0aa8e31375e619d4612523295761ea9b75b552 | kakapo | 🟢 Primary Domain |
20 | 0xfb79c3a4d001691a6a1cffcebcf426ce81355639 | keysfi | 🟢 Primary Domain |
freemartianHolders ENS
Updated 2025-04-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with holders AS(
SELECT *, rank() over(partition BY user_address ORDER BY block_timestamp DESC) AS rank
FROM ethereum.core.fact_token_balances
WHERE contract_address = lower('0x9830b32f7210f0857A859c2A86387e4d1bB760B8')
qualify rank = 1
)
SELECT owner, ens_domain AS ens_name,
(CASE
when ens_set = true THEN '🟢 Primary Domain'
ELSE '🔴 Not Primary' END) AS label
FROM ethereum.ens.ez_ens_domains
WHERE owner in (SELECT user_address FROM holders)
AND expired = FALSE
ORDER BY 1 DESC
Last run: 25 days agoAuto-refreshes every 1 hour
...
1844
142KB
198s