USER_ADDRESS | BALANCE | |
|---|---|---|
1 | 0xe5e83c2347be43eb917715c7385ae2a2cf95453c | 57 |
2 | 0x96ef7cf2f781579aa499e9e04f6f1ce6244149ac | 22 |
3 | 0xe922a0bc44210f97aa6a38fe1ad7f6b8d3b23dec | 22 |
4 | 0x0871deb34bfd2052b1c10dc4f6c0912a2a47e927 | 17 |
5 | 0x512e3eb472d53df71db0252cb8dccd25cd05e9e9 | 15 |
6 | 0xb8da19f218a93d430c7eb167785e2afc5a43c7d3 | 15 |
7 | 0xa65ce1d604fa901c13aa29f2126a57d9032e412b | 10 |
8 | 0xc58d63d59ad68930c9fdff6f1ac479c5c9941ef4 | 10 |
9 | 0x5c8413d0d908c9caa91ac36f60affab023ddf88a | 9 |
10 | 0x75d415edcb3c3782e5952470821e983f9053a209 | 9 |
11 | 0xe6c4f3f937b961e621d021d9d9e7deadeac9c934 | 9 |
12 | 0x9b864dde6ed1c21608b1665a0ac0faa4f7e36e6e | 7 |
13 | 0x9284266887ab43b6fb088aa0e4c6aef043bac823 | 5 |
14 | 0x6b17062890bc3556bed6b8398be5adccd4d84a4e | 5 |
15 | 0xfd211ee23506e82938c88dc140e2d88f851e2039 | 5 |
16 | 0xcb915dca399d7c4fe92b17466571883d6fc34311 | 5 |
17 | 0x80cc9003fa6e43315f9196da10f0b51ce27be964 | 4 |
18 | 0x03739f52ab1bd514682c6e21de70e06a676920f0 | 4 |
19 | 0x758e83c114e36a28ca1f31c4d2adb5ec7c04c578 | 4 |
20 | 0xee9b897b21e1ae58f4fa79504dea5bb07bd2c51a | 4 |
freemartiantemp query
Updated 2025-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- forked from Holders @ https://flipsidecrypto.xyz/studio/queries/df06b030-b0a5-4c39-a927-1f11f459fc4e
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
user_address,
balance
FROM holders
-- WHERE balance >=4
WHERE balance >0
ORDER BY 2 DESC
Last run: 3 months ago
...
914
44KB
1s