jkhuhnke11Balancer Holders By Amount Of Balancer Held
Updated 2023-04-19
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
›
⌄
WITH labels as (
SELECT
user_address,
CASE WHEN current_bal < 10 THEN
'Plankton (< 10 BAL)'
WHEN current_bal >= 10 AND current_bal < 100 THEN
'Minnow (Between 10 and 100 BAL)'
WHEN current_bal >= 100 AND current_bal < 1000 THEN
'Goldfish (Between 100 and 1000 BAL)'
WHEN current_bal >= 1000 AND current_bal < 5000 THEN
'Manta Ray (Between 1k and 5k BAL)'
WHEN current_bal >= 5000 AND current_bal <10000 THEN
'Dolphin (Between 5k and 10k BAL)'
WHEN current_bal >= 10000 THEN
'Whale (More than 10k BAL)'
END as label
FROM
ethereum.core.ez_current_balances
WHERE
contract_address = LOWER('0xba100000625a3754423978a60c9317c58a424e3D')
AND current_bal > 0
)
SELECT
count(distinct user_address) as num_users,
label
FROM labels
GROUP BY label
Run a query to Download Data