datavortexTop Swapped to Token By Volume 1
    Updated 2024-09-11
    SELECT
    swap_to_symbol AS swapped_to,
    COUNT(DISTINCT tx_id) AS total_swap,
    SUM(swap_from_amount_usd) AS volume_swapped,
    COUNT(DISTINCT swapper) AS swappers
    FROM
    solana.defi.ez_dex_swaps
    WHERE
    block_timestamp BETWEEN '{{start_date}}' AND '{{end_date}}'
    AND swap_from_symbol = '{{token1}}'
    AND swap_to_symbol IS NOT NULL
    GROUP BY
    swap_to_symbol
    ORDER BY
    volume_swapped DESC;

    Last run: 17 days ago
    SWAPPED_TO
    TOTAL_SWAP
    VOLUME_SWAPPED
    SWAPPERS
    1
    USDC82086908219558717.92141985
    2
    WIF957795628449189.0217427
    3
    USDT2402518496263536.3137322
    4
    JITOSOL259427367440986.267931
    5
    POPCAT725287350800758.3318479
    6
    JUP879806350056772.518437
    7
    JLP609403218041643.525274
    8
    MSOL179219213773160.454855
    9
    FWOG368497170946464.3832556
    10
    SCF352397166759011.422491
    11
    NEIRO506211163760893.7876366
    12
    JUPSOL142796149197442.915655
    13
    BILLY335582143425175.5431610
    14
    MUMU213473115414142.7523814
    15
    INF126443111228601.952778
    16
    WBTC314482104199932.572969
    17
    MEW170807101649213.1712900
    18
    WDOG35485499317603.2425932
    19
    $MICHI18437689430525.2217958
    20
    BSOL17356786146677.543607
    ...
    1985
    51KB
    68s