strawbettydistribution of the number of swaps per whale in 2022.
    Updated 2022-04-19
    with whales as (
    SELECT address
    from algorand.account
    where balance >= 100000
    )

    SELECT
    swapper,
    COUNT(DISTINCT tx_group_id) as swapcount
    from algorand.swaps
    where date(block_timestamp) >= '2022-01-01'
    and swap_from_amount > 0
    and swapper in (SELECT address from whales)
    GROUP by swapper