maybeyonasalgo_wallets_recent_aug
Updated 2022-02-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with
creation as (
select
-- created_at,
block_timestamp,
address
from algorand.account join algorand.block on created_at=block_id
)
select
date(block_timestamp) as date,
case
when block_timestamp >= '2021-09-20' and block_timestamp <= '2021-10-14' then 'gov1'
when block_timestamp >= '2021-12-24' and block_timestamp <= '2022-01-01' then 'gov2'
else 'not gov' end as gov_type,
count(distinct address) as users
from creation
where date(block_timestamp) >= '2021-09-01'
group by 1,2
-- limit 100
Run a query to Download Data