MLDZMNprofile 7
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tbt as (select
distinct swapper,
count(distinct TX_GROUP_ID) as times
from flipside_prod_db.algorand.swaps
where BLOCK_TIMESTAMP between '2022-05-01' and '2022-06-30'
group by 1)
select
case
when times=1 then 'Only one swap'
when times>1 then 'More than 1 swap'
end as buckets,
count(distinct swapper) as count_users
from tbt
group by 1
Run a query to Download Data