KaskoazulDistribution of wallets by number of swaps ASA DEX
Updated 2022-04-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
WITH SWAPS AS (
select swapper as wallet,
count(distinct tx_group_id) as swaps
from algorand.swaps
where block_timestamp >= '2022-01-01'
and swap_from_amount >= 0
group by wallet--, type
order by swaps desc
)
select case
when swaps <= 1 then 'a. One-timer'
when swaps > 1 and swaps <= 10 then 'b. Swap Fish'
when swaps > 10 and swaps <= 50 then 'c. Decapod'
when swaps > 50 and swaps <= 100 then 'd. Elderly'
when swaps > 100 and swaps <= 500 then 'e. Daily swapper'
when swaps > 500 and swaps <= 1000 then 'f. Addicted to Swap'
when swaps > 1000 and swaps <= 5000 then 'g. Heavily automated'
when swaps > 5000 then 'h. Master Bot'
end as type,
count (wallet)
from SWAPS
group by type
order by type
Run a query to Download Data