HOLDER_TIER | WALLET_COUNT | TOTAL_RONKE_HELD | |
|---|---|---|---|
1 | Small Holder (< 1K) | 1573 | 401287.16 |
2 | Retail (1K – 10K) | 484 | 1839888.83 |
3 | Mid Holder (10K – 100K) | 542 | 17321079.58 |
4 | Shark (100K – 1M) | 299 | 83901923.83 |
5 | Whale (1M+ RONKE) | 78 | 280966358.05 |
feyikemiHolders distribution
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
31
32
33
34
35
36
›
⌄
WITH all_transfers AS (
SELECT
TO_ADDRESS AS wallet,
AMOUNT AS amount
FROM ronin.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = LOWER('0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb')
AND TO_ADDRESS != '0x0000000000000000000000000000000000000000'
AND block_timestamp::date >= '2025-02-22'
UNION ALL
SELECT
FROM_ADDRESS AS wallet,
-AMOUNT AS amount
FROM ronin.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = LOWER('0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb')
AND FROM_ADDRESS != '0x0000000000000000000000000000000000000000'
AND block_timestamp::date >= '2025-02-22'
),
wallet_balances AS (
SELECT
wallet,
SUM(amount) AS amount_held
FROM all_transfers
GROUP BY wallet
HAVING SUM(amount) > 0
),
wallet_distribution AS (
SELECT
wallet,
amount_held,
CASE
WHEN amount_held >= 1000000 THEN 'Whale (1M+ RONKE)'
WHEN amount_held >= 100000 THEN 'Shark (100K – 1M)'
Last run: 2 months ago
5
203B
2s