maybeyonasalgo_jan_dec_wallet
Updated 2022-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
case
when block_timestamp < '202102-01' then 'jan 2021'
when month(block_timestamp) = 12 then 'dec 2021'
else 'jan 2022'
end month_time,
date(block_timestamp) as date,
count(distinct address) as users
from algorand.transaction_participation
where block_timestamp > '2021-02-02'
and month(block_timestamp) in (1,12)
group by 1,2
limit 1000
Run a query to Download Data