KaskoazulALGO addresses distribution
Updated 2022-02-17
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 New_wallets AS (
SELECT
address,
balance
FROM
algorand.account
WHERE
created_at>= 18363444 AND created_at<=18974008 -- 18363444 January first block 18974008 January last block
)
SELECT -- Distribution of ALGO held by new wallets
CASE WHEN balance > 0 AND balance <= 1 THEN 'a. Shrimp 0-1'
WHEN balance > 1 AND balance <= 10 THEN 'b. Crab 1-10'
WHEN balance > 10 AND balance <= 100 THEN 'c. Octopus 10-100'
WHEN balance > 100 AND balance <= 1000 THEN 'd. Fish 100-1k'
WHEN balance > 1000 AND balance <= 10000 THEN 'e. Dolphin 1k-10k'
WHEN balance > 10000 AND balance <= 100000 THEN 'f. Shark 10k-100k'
WHEN balance > 100000 AND balance <= 1000000 THEN 'g. Whale 100k-1M'
WHEN balance > 1000000 AND balance <= 400000000 THEN 'h. Humpback >1M'
WHEN balance > 400000000 THEN 'i. Moby Dick > 400M'
ELSE NULL END AS Tier,
count(distinct address) as Number_of_addresses,
sum(balance) as Total_ALGO
FROM New_wallets
WHERE balance > 0
GROUP BY 1
ORDER BY 1
Run a query to Download Data