keshanactive and inactive in jan
Updated 2022-02-13
9
1
2
3
4
5
6
7
8
9
›
⌄
with jan as (select date_trunc('month', block_timestamp) as month, count(distinct address) as created,
sum(case when account_closed = 'TRUE' then 1 else 0 end) as closed,
sum(case when account_closed = 'FALSE' then 1 else 0 end) as open
from algorand.account
left join algorand.block on block_id = created_at
group by month)
select month, (closed * 100 / created) as close_precentage, (open * 100 / created) as open_precentage from jan
Run a query to Download Data