KaskoazulDistribution of wallets by number of swaps ASA DEX
    Updated 2022-04-19
    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