m0rt3zaWallets with more than on ALGO breakdown
Updated 2022-06-16
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
›
⌄
with wallet_list as ( -- wallet holding more than 1 algo and created in May
SELECT
a.address,
a.balance,
b.block_timestamp as creation_date,
CASE
WHEN creation_date BETWEEN '2022-05-01' AND '2022-06-01' THEN 'Created in May'
ELSE 'Others' end AS creation_groups
FROM flipside_prod_db.algorand.account as a JOIN flipside_prod_db.algorand.block as b
ON a.created_at = b.block_id
WHERE
a.account_closed = FALSE AND
a.closed_at is NULL AND
a.balance > 1
)
SELECT
creation_groups,
(select count(creation_groups) from wallet_list ) as total,
count(creation_groups) as gp_size,
gp_size/total*100 as percent
FROM wallet_list
GROUP BY creation_groups
Run a query to Download Data