TOKEN_BALANCE_GROUP | DEPOSITORS | DEPOSIT_AMOUNT | |
|---|---|---|---|
1 | c/ 1-10 | 52 | 151.660359316 |
2 | b/ Below 1 | 230 | 20.23369349 |
3 | g/ 10K-100K | 1 | 22875.458125145 |
4 | e/ 100-1K | 11 | 3386.970232261 |
5 | d/ 10-100 | 15 | 444.24600642 |
6 | f/ 1K-10K | 2 | 4966.311048569 |
Pine Analyticsbrief-gold copy
Updated 2025-03-03
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
›
⌄
SELECT
case
when balance < 1 then 'b/ Below 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 'g/ 10K-100K'
when balance < 1000000 then 'h/ 100K-1M'
else 'i/ 1M+'
end as token_balance_group,
count(*) as depositors,
sum(balance) as deposit_amount
FROM (
SELECT
OWNER,
sum(balance - pre_balance) as balance
FROM solana.core.fact_token_balances
where mint like 'FxT7bPGvkS5jKF2vgnJ16MciHqtsNqxbcWTfFg7L136h'
AND succeeded
GROUP BY 1
order by 2 desc
)
where balance > 0
GROUP BY 1
Last run: about 2 months ago
6
188B
133s