jkhuhnke11AAVE Token Holder Breakdown by Tokens 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
28
29
30
›
⌄
WITH labels as (
SELECT
user_address,
current_bal,
CASE WHEN current_bal < 10 THEN
'Plankton (< 10 AAVE)'
WHEN current_bal >= 10 AND current_bal < 50 THEN
'Minnow (Between 10 and 50 AAVE)'
WHEN current_bal >= 50 AND current_bal < 100 THEN
'Goldfish (Between 50 and 100 AAVE)'
WHEN current_bal >= 100 AND current_bal < 250 THEN
'Manta Ray (Between 100 and 250 AAVE)'
WHEN current_bal >= 250 AND current_bal <500 THEN
'Dolphin (Between 250 and 500 AAVE)'
WHEN current_bal >= 500 THEN
'Whale (More than 500 AAVE)'
END as label
FROM
ethereum.core.ez_current_balances
WHERE
contract_address = LOWER('0x7Fc66500c84A76Ad7e9c93437bFc5Ac33E2DDaE9')
AND current_bal > 0
)
SELECT
count(distinct user_address) as num_users,
label
FROM labels
GROUP BY label
Run a query to Download Data