Papasot100k Algo whales swappers Top 20 list
    Updated 2023-01-03
    With whales AS
    (select address,balance,wallet_type
    from algorand.account
    where balance > '100000'
    order by balance DESC)

    SELECT
    distinct(swapper),
    count(swapper) as Swaps,
    balance
    FROM algorand.swaps
    LEFT JOIN whales ON swapper = whales.address
    WHERE block_timestamp >= '2022-01-01' AND
    whales.balance > '100000'
    GROUP BY swapper, balance
    ORDER BY Swaps DESC
    Limit 20
    Run a query to Download Data