sagharkariTop 10 Tokens Swapped with mSOL by Total USD Volume
    Updated 2025-04-06
    SELECT
    CASE
    WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_to_symbol
    ELSE swap_from_symbol
    END AS paired_token,
    SUM(
    COALESCE(
    CASE
    WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_from_amount_usd
    WHEN swap_to_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_to_amount_usd
    ELSE NULL
    END,
    0
    )
    ) AS total_volume_usd

    FROM solana.marinade.ez_swaps
    WHERE succeeded = TRUE
    AND block_timestamp >= DATE '2025-01-01'
    AND (
    swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' OR
    swap_to_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
    )
    GROUP BY paired_token
    HAVING SUM(
    COALESCE(
    CASE
    WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_from_amount_usd
    WHEN swap_to_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_to_amount_usd
    ELSE NULL
    END,
    0
    )
    ) > 0
    ORDER BY total_volume_usd DESC
    Last run: 22 days ago
    PAIRED_TOKEN
    TOTAL_VOLUME_USD
    1
    SOL1170512203.06
    2
    USDC292284777.63
    3
    JITOSOL23768425.77
    4
    USDT19125262.92
    5
    JUPSOL8535956.63
    6
    JLP5417951.08
    7
    USDS4329308.68
    8
    DSOL3948877.28
    9
    RAY2860955.21
    10
    BSOL2724406.53
    10
    210B
    2s