TOKEN_BALANCE_GROUP | WALLETS | TOTAL_BALANCE | |
|---|---|---|---|
1 | e/ 1K-10K | 37 | 89527.050319 |
2 | b/ 1-10 | 25394 | 47530.510323 |
3 | f/ 10K-100K | 8 | 196774.031563 |
4 | d/ 100-1K | 257 | 67063.058242 |
5 | c/ 10-100 | 1773 | 44429.641671 |
6 | g/ 100K-1M | 1 | 718248.095988001 |
7 | a/ Below 1 | 23640 | 3241.166118 |
Pine AnalyticsINK 12 copy
Updated 2025-04-06
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 tab1 as (
select
block_timestamp,
tx_hash,
to_address as wallet,
'in' as tx_type,
amount
from ink.core.ez_token_transfers
where contract_address like lower('0xF1815bd50389c46847f0Bda824eC8da914045D14')
--and to_address like '0x0000000000000000000000000000000000000000'
union all
select
block_timestamp,
tx_hash,
from_address as wallet,
'out' as tx_type,
amount
from ink.core.ez_token_transfers
where contract_address like lower('0xF1815bd50389c46847f0Bda824eC8da914045D14')
--and like '0x0000000000000000000000000000000000000000'
)
select
case when balance < 1 then 'a/ Below 1'
when balance < 10 then 'b/ 1-10'
when balance < 100 then 'c/ 10-100'
when balance < 1000 then 'd/ 100-1K'
when balance < 10000 then 'e/ 1K-10K'
when balance < 100000 then 'f/ 10K-100K'
when balance < 1000000 then 'g/ 100K-1M'
when balance < 10000000 then 'h/ 1M-10M'
else 'i/ 10M+' end as Token_balance_group,
Last run: about 2 months ago
7
224B
17s