kasadeghThe average ALGO holding
Updated 2022-06-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with new_wallet_in_may as (
select count(distinct a.ADDRESS) as "number_of_new_wallet_in_may" from flipside_prod_db.algorand.account as a
join flipside_prod_db.algorand.block as b
on b.BLOCK_ID=a.CREATED_AT
where date(b.BLOCK_TIMESTAMP)>='2022-05-01' and date(b.BLOCK_TIMESTAMP)<='2022-05-30' and a.ACCOUNT_CLOSED=0
),
new_wallet_in_may_with_more_than_1 as (
select a.ADDRESS,a.BALANCE from flipside_prod_db.algorand.account as a
join flipside_prod_db.algorand.block as b
on b.BLOCK_ID=a.CREATED_AT
where date(b.BLOCK_TIMESTAMP)>='2022-05-01' and date(b.BLOCK_TIMESTAMP)<='2022-05-30' and a.ACCOUNT_CLOSED=0 and a.BALANCE>1
order by a.BALANCE desc
)
select avg(BALANCE) as "The average ALGO holding" from new_wallet_in_may_with_more_than_1
Run a query to Download Data