crypto_gostxenacious-tan
    Updated 2024-11-29
    WITH stablecoin AS (
    SELECT
    tx_hash,
    block_timestamp,
    swapper,
    TOKEN_IN AS token,
    TOKEN_OUT AS other_token,
    amount_out_usd AS amount_usd,
    platform
    FROM
    aptos.defi.ez_dex_swaps
    WHERE
    TOKEN_IN IN (
    '0x8d87a65ba30e09357fa2edea2c80dbac296e5dec2b18287113500b902942929d::celer_coin_manager::UsdcCoin', -- ceUSDC
    '0xa2eda21a58856fda86451436513b867c97eecb4ba099da5775520e0f7492e852::coin::T', -- USDT
    '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' -- USDC ()
    )
    UNION ALL
    SELECT
    tx_hash,
    block_timestamp,
    swapper,
    TOKEN_OUT AS token,
    TOKEN_IN AS other_token,
    amount_in_usd AS amount_usd,
    platform
    FROM
    aptos.defi.ez_dex_swaps
    WHERE
    TOKEN_OUT IN (
    '0x8d87a65ba30e09357fa2edea2c80dbac296e5dec2b18287113500b902942929d::celer_coin_manager::UsdcCoin', -- ceUSDC
    '0xa2eda21a58856fda86451436513b867c97eecb4ba099da5775520e0f7492e852::coin::T', -- USDT
    '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' -- USDC ()
    )
    )

    Last run: 3 months ago
    TOKEN_NAME
    TOKEN
    SWAPS
    SWAPPERS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    DAILY_AVERAGE_SWAPS
    DAILY_AVERAGE_SWAPPERS
    1
    USDC (layerzero)
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asse...
    111564096440793178030849.30829205.79939722433502.729731934.171171
    2
    USDT0xa2eda21a58856fda86451436513b867c97eecb4ba099da5775520e0f7492e852::coin::T3457264483251278041.540243570.7048298981038.216216134.630631
    3
    ceUSDC
    0x8d87a65ba30e09357fa2edea2c80dbac296e5dec2b18287113500b902942929d::cele...
    163228173234394905.3198455113.938495878490.17417452.021021
    3
    502B
    8s