feyikemiTop Assets on Aptos
    Updated 2025-03-25
    SELECT
    symbol_in AS Asset,
    COUNT(DISTINCT tx_hash) AS Total_Trades,
    COUNT(DISTINCT swapper) AS Total_Traders,
    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
    ORDER BY Total_Traders DESC
    LIMIT 10
    Last run: 2 months ago
    ASSET
    TOTAL_TRADES
    TOTAL_TRADERS
    TOTAL_TRADED_VOLUME
    1
    APT1328820610524803431303537.31036
    2
    USDC87282385200092334826238.62302
    3
    USDT3181209331146529539859.170058
    4
    amAPT17044482813761572340397.35825
    5
    WETH96483120716870513947.0417679
    6
    stAPT141572217014868576157.7942808
    7
    THL8579928172964682790.0857523
    8
    MOD117983080421669714244.108857
    9
    tAPT482076601003152375.7110371
    10
    MOOMOO3685405634048309684.4584528
    10
    405B
    17s