KaskoazulWhales Swapping - Swaps per whale
    Updated 2022-04-15
    with whales as (
    select address
    from algorand.account
    where account_closed = 'FALSE'
    and balance >266880
    )

    select swapper,
    count (distinct tx_group_id) as number_of_swaps
    from algorand.swaps
    where swapper in (select address from whales)
    and block_timestamp >= '2022-01-01'
    group by 1
    order by 2 desc





    Run a query to Download Data