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

    SELECT
    swapper,
    COUNT(DISTINCT tx_group_id) as swap_count
    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
    Run a query to Download Data