TOTAL_HOLDERS | |
|---|---|
1 | 3665 |
feyikemiTotal Holders
Updated 2025-03-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
24
25
26
27
28
29
30
›
⌄
WITH all_transfers AS (
SELECT
TO_ADDRESS AS wallet,
AMOUNT AS amount
FROM ronin.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb'
AND TO_ADDRESS != '0x0000000000000000000000000000000000000000'
UNION ALL
SELECT
FROM_ADDRESS AS wallet,
-AMOUNT AS amount
FROM ronin.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb'
AND FROM_ADDRESS != '0x0000000000000000000000000000000000000000'
)
SELECT
COUNT(*) AS total_holders
FROM (
SELECT
wallet,
SUM(amount) AS net_balance
FROM all_transfers
GROUP BY wallet
HAVING net_balance > 0.00000000001
) AS net_holders;
Last run: 2 months ago
1
8B
2s