kidaUni Address Count by Category (Users Only)
Updated 2021-06-28
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
›
⌄
--whales
SELECT
COUNT(DISTINCT(user_address)),
'Whales (>= 1000000)' AS symbol
FROM ethereum.erc20_balances
WHERE balance >= 1000000 AND -- 0.1% of total supply
contract_address = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984' AND
balance_date = (SELECT MAX(balance_date) FROM ethereum.erc20_balances) AND
label_type IS NULL AND
label_subtype IS NULL
UNION ALL
--sharks
SELECT
COUNT(DISTINCT(user_address)),
'Sharks (10000 - 1000000)' AS symbol
FROM ethereum.erc20_balances
WHERE balance < 1000000 AND -- 0.1% of total supply
balance >= 10000 AND -- 0.001% of total supply
contract_address = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984' AND
balance_date = (SELECT MAX(balance_date) FROM ethereum.erc20_balances) AND
label_type IS NULL AND
label_subtype IS NULL
UNION ALL
--dolphins
SELECT
COUNT(DISTINCT(user_address)),
'Dolphins (100 - 10000)' AS symbol
FROM ethereum.erc20_balances
WHERE balance < 10000 AND -- 0.001% of total supply
balance >= 100 AND -- 0.00001% of total supply
contract_address = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984' AND
balance_date = (SELECT MAX(balance_date) FROM ethereum.erc20_balances) AND
label_type IS NULL AND
label_subtype IS NULL
UNION ALL
--the rest
Run a query to Download Data