flipside

    Swap Pairs By Swap Count
    datavortexSwap Pairs By Swap Count
    Updated 2025-05-12
    WITH usdt_to_other AS (
    SELECT
    CASE
    WHEN symbol_out = 'APT' THEN 'USDT-APT swap'
    WHEN symbol_out = 'USDC' THEN 'USDT-USDC swap'
    WHEN symbol_out = 'PROPS' THEN 'USDT-PROPS swap'
    WHEN symbol_out = 'WETH' THEN 'USDT-WETH swap'
    ELSE symbol_out
    END AS swap_pair,
    COUNT(DISTINCT tx_hash) AS swap_count
    FROM aptos.defi.ez_dex_swaps
    WHERE symbol_in = 'USDT'
    AND block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
    GROUP BY swap_pair
    ),
    other_to_usdt AS (
    SELECT
    CASE
    WHEN symbol_in = 'APT' THEN 'APT-USDT swap'
    WHEN symbol_in = 'USDC' THEN 'USDC-USDT swap'
    WHEN symbol_in = 'PROPS' THEN 'PROPS-USDT swap'
    WHEN symbol_in = 'WETH' THEN 'WETH-USDT swap'
    ELSE symbol_in
    END AS swap_pair,
    COUNT(DISTINCT tx_hash) AS swap_count
    FROM aptos.defi.ez_dex_swaps
    WHERE symbol_out = 'USDT'
    AND block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
    GROUP BY swap_pair
    )

    SELECT
    'From USDT to' AS direction,
    swap_pair,
    swap_count
    FROM usdt_to_other
    Last run: 13 days ago
    DIRECTION
    SWAP_PAIR
    SWAP_COUNT
    1
    		From other to USDTAPT-USDT swap1416150
    2
    		From other to USDTUSDC-USDT swap1323476
    3
    		From USDT toUSDT-USDC swap1292742
    4
    		From USDT toUSDT-APT swap1249828
    5
    		From USDT toUSDT-PROPS swap172721
    6
    		From other to USDTUSDT159322
    7
    		From USDT toUSDT159322
    8
    		From other to USDTPROPS-USDT swap155188
    9
    		From other to USDTUSDt100196
    10
    		From USDT toUSDt89856
    10
    404B
    9s