adriaparcerisas1M New Algorand Wallets In May
Updated 2022-05-18
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
›
⌄
-- From May 4th to May 10 we saw over a million wallets being created. What are these new wallets doing on Algorand? Some things to look at:
-- Using the account table, show the distribution of ALGOs these wallets have?
--Are these wallets swapping assets?
-- If so, what assets are these wallets swapping for?
--What assets do these wallets hold using the account_asset table?
--Do we see any commonalities our patterns across these wallets?
WITH
list as (
SELECT
distinct address as wallets,
--block_timestamp as debut,
balance
from algorand.account x
join algorand.block y on x.created_at =y.block_id
where block_timestamp between '2022-05-04' and '2022-05-10'
)
SELECT
case when balance <100 then 'e. Tester: <100 ALGOs'
when balance between 100 and 1000 then 'd. Beginner: 100-1k ALGOs'
when balance between 1000 and 50000 then 'c. Believer: 1k-50k ALGOs'
when balance between 50000 and 500000 then 'b. Big holders: 50k-500k ALGOs'
else 'a. Whales: more than 500k ALGOs' end as wallet_type,
count(distinct wallets) as counts,
sum(balance) as total_balance_in_wallets
from list
group by 1
order by 1
Run a query to Download Data