CATEGORY | BALANCE | FORMATTED_BALANCE | PERCENTAGE | |
|---|---|---|---|---|
1 | Top 10 Holders | 5360764.41941995 | $5.36M | 98.83% |
2 | Next 40 Holders (11-50) | 61526.841089894 | $61.53K | 1.13% |
3 | Next 50 Holders (51-100) | 1307.063054006 | $1.31K | 0.02% |
4 | Other Holders (101+) | 451.346436004 | $451.35 | 0.01% |
Kruys-Collinscomplex-ivory
Updated 2025-03-17
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 token_movements AS (
-- Sum of incoming transfers for each holder
SELECT
LOWER(to_address) AS holder,
SUM(amount) AS amount
FROM avalanche.core.ez_token_transfers
WHERE contract_address = LOWER('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E')
GROUP BY LOWER(to_address)
UNION ALL
-- Sum of outgoing transfers for each holder (negative amounts)
SELECT
LOWER(from_address) AS holder,
SUM(-amount) AS amount
FROM avalanche.core.ez_token_transfers
WHERE contract_address = LOWER('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E')
GROUP BY LOWER(from_address)
),
holder_balances AS (
-- Calculate net balance for each holder
SELECT
holder,
SUM(amount) AS balance
FROM token_movements
GROUP BY holder
),
ranked_holders AS (
-- Rank holders by balance in descending order
SELECT
holder,
balance,
ROW_NUMBER() OVER (ORDER BY balance DESC) AS rank
FROM holder_balances
Last run: 25 days ago
4
235B
3s