TOKEN_BALANCE_GROUP | HOLDERS | TOKEN_BALANCE | |
|---|---|---|---|
1 | f/ 1K-100K | 5 | 190621.641766712 |
2 | b/ 0.1-1 | 3581 | 1295.622131744 |
3 | e/ 100-1K | 120 | 31897.414371477 |
4 | c/ 1-10 | 1598 | 4881.11500954 |
5 | g/ 100K+ | 3 | 654568.597661589 |
6 | f/ 1K-10K | 22 | 47127.229416772 |
7 | d/ 10-100 | 394 | 13758.214772378 |
8 | a/ Below 0.1 | 49071 | 332.07751027 |
Pine AnalyticsBLZE Stake 3
Updated 2025-04-07
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
›
⌄
SELECT
case
when balance < 0.1 then 'a/ Below 0.1'
when balance < 1 then 'b/ 0.1-1'
when balance < 10 then 'c/ 1-10'
when balance < 100 then 'd/ 10-100'
when balance < 1000 then 'e/ 100-1K'
when balance < 10000 then 'f/ 1K-10K'
when balance < 100000 then 'f/ 1K-100K'
else 'g/ 100K+'
end as token_balance_group,
count(*) as holders,
sum(balance) as token_balance
FROM (
select *
from (
SELECT
OWNER,
sum(balance - pre_balance) as balance
FROM solana.core.fact_token_balances
where mint like 'bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1'
AND succeeded
GROUP BY 1
)
where balance > 1 / power(10, 5)
order by 2 desc
)
where balance > 0
GROUP BY 1
Last run: 17 days ago
8
268B
224s