CryptoIcicleAlgo-101.New Wallets In May - ASA
Updated 2022-06-14
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
›
⌄
-- Payout 122.9 ALGO
-- Grand Prize 368.71 ALGO
-- Level Beginner
-- Q101. How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May?
-- How many new wallets were created in May? What % of total wallets with more than 1 ALGO is this?
-- Additionally, show the distribution of ALGO holdings for these new wallets. What is the average ALGO holding of these new wallets?
-- What other ASAs do these new wallets from May hold? How many of these wallets have performed a swap?
-- Finally, note anything else interesting about these wallets! Why are these wallets being created and what are they doing on Algorand?"
with wallets as (
select
address,
iff(block_timestamp between '2022-05-01' and '2022-05-30', 'may', 'non-may') as creation
from algorand.account a
join algorand.block b on a.created_at = b.block_id
where a.balance > 1
group by address, creation
)
select
a.asset_name,
count(distinct w.address) as n_wallets
from wallets w join flipside_prod_db.algorand.account_asset a on w.address = a.address and w.creation = 'may'
group by asset_name
order by n_wallets desc
limit 100
Run a query to Download Data