nickpayiatis_Untitled Query
Updated 2022-12-12
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
29
›
⌄
with addresses as(
select address, amount from "FLIPSIDE_PROD_DB"."ALGORAND"."ACCOUNT_ASSET"
where asset_id = '849191641'
and amount > 0
)
,wallet_profile as(
select acc.address, case
when amount >= 0 and acc.balance < 10 then '0-10 ALGO'
when acc.balance >= 10 and acc.balance < 100 then '10-100 ALGO'
when acc.balance >= 100 and acc.balance < 1000 then '100-1000 ALGO'
when acc.balance >= 100 and acc.balance < 1000 then '1000-10000 ALGO'
else '1000-10000 ALGO'
end as balance_group,
acc.balance as account_balance,
block.block_timestamp::Date as created_at
from group_addresses addr
)
select distinct created_at , count(*)
from wallet_profile
group by created_at
Run a query to Download Data