feyikemiAptos Whales Per Platform
    Updated 2025-03-25
    --Adopted from Masi https://flipsidecrypto.xyz/Masi/dashboards

    WITH Stats AS (
    SELECT
    Platform,
    Swapper,
    SUM(COALESCE(amount_in_usd, amount_out_usd)) AS Total_Traded_Volume
    FROM
    aptos.defi.ez_dex_swaps
    WHERE block_timestamp::DATE >= '{{Start_Date}}'
    AND amount_in_usd < 1e6
    AND amount_out_usd < 1e6
    GROUP BY 1, 2
    )
    SELECT
    Platform,
    COUNT(DISTINCT Swapper) AS Traders
    FROM Stats
    WHERE Total_Traded_Volume > 1000000
    GROUP BY Platform
    ORDER BY Traders DESC
    Last run: 2 months ago
    PLATFORM
    TRADERS
    1
    cellana636
    2
    thala168
    3
    liquidswap163
    4
    pancake46
    5
    sushi24
    6
    hippo20
    6
    91B
    7s