picasoTop 20 Swaps by Output Volume
    Updated 2025-05-09
    SELECT
    SYMBOL_IN AS token_in,
    SYMBOL_OUT AS token_out,
    SUM(AMOUNT_OUT_USD) AS total_output_volume,
    CONCAT(SYMBOL_IN, ' ==> ', SYMBOL_OUT) AS conversion
    FROM
    aptos.defi.ez_dex_swaps
    WHERE DATE(BLOCK_TIMESTAMP) >= DATE '2025-01-01'
    AND SYMBOL_IN IS NOT NULL
    AND SYMBOL_OUT IS NOT NULL
    AND AMOUNT_OUT_USD IS NOT NULL
    AND AMOUNT_OUT_USD > 0
    GROUP BY
    SYMBOL_IN,
    SYMBOL_OUT
    ORDER BY
    total_output_volume DESC
    LIMIT
    20;
    Last run: about 2 months ago
    TOKEN_IN
    TOKEN_OUT
    TOTAL_OUTPUT_VOLUME
    CONVERSION
    1
    USDCAPT273142610.180057USDC ==> APT
    2
    APTUSDC247544746.018341APT ==> USDC
    3
    APTamAPT120694733.934071APT ==> amAPT
    4
    amAPTAPT120385405.028759amAPT ==> APT
    5
    MODUSDC67256673.8114281MOD ==> USDC
    6
    USDCMOD66008709.7750552USDC ==> MOD
    7
    APTUSDT57703006.3485743APT ==> USDT
    8
    USDTAPT56808627.3012796USDT ==> APT
    9
    thAPTAPT54345737.602847thAPT ==> APT
    10
    USDtAPT40133418.608281USDt ==> APT
    11
    APTaBTC26596038.3208769APT ==> aBTC
    12
    USDCUSDC26394519.6786398USDC ==> USDC
    13
    aBTCAPT25106433.7163732aBTC ==> APT
    14
    USDCUSDT18628303.6808508USDC ==> USDT
    15
    USDTUSDC18413472.8237042USDT ==> USDC
    16
    AMIAPT11771859.4954797AMI ==> APT
    17
    SidelinedAPT9640858.93053911Sidelined ==> APT
    18
    USDCWETH5727101.94120979USDC ==> WETH
    19
    WETHUSDC4984061.07288719WETH ==> USDC
    20
    APTSidelined4817355.63210463APT ==> Sidelined
    20
    973B
    1s