PapasotAlgorand Whales DEX preference
    Updated 2023-01-03
    With whales AS
    (select address,balance,wallet_type
    from algorand.account
    where balance > '100000'
    order by balance DESC)

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