Papasotwhales swappers percentage
    Updated 2023-01-03
    With whales AS
    (select address,balance,wallet_type
    from algorand.account
    where balance > '100000'
    order by balance DESC)

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