strawbettywallets that have more than 1 Algo
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
25
26
27
28
›
⌄
with base as (select address
from flipside_prod_db.algorand.account a
join algorand.block b
on a.created_at = b.block_id
where block_timestamp >= '2022-05-01'
and block_timestamp <= '2022-05-31'),
base2 as (select a.address,
sum(balance) as algo_balance, case
when algo_balance <= 1 then 'algo balance <= 1'
when algo_balance > 1 then 'algo balance > 1'
end as algo_balance_ranges,
case
when algo_balance <= 1 then '0'
when algo_balance > 1 then '1'
end as ordering
from base a
join algorand.account b
on a.address = b.address
group by 1)
select algo_balance_ranges,
ordering,
count(distinct(address)) as count_wallets
from base2
group by 1,2
order by 2
Run a query to Download Data