flipside

    msol pairs
    datavortexmsol pairs
    Updated 2025-02-18
    WITH swap_data AS (
    SELECT
    swap_from_mint,
    swap_to_mint,
    swap_from_symbol,
    swap_to_symbol,
    tx_id,
    swapper,
    swap_from_amount_usd,
    swap_to_amount_usd,
    block_timestamp
    FROM
    solana.marinade.ez_swaps
    WHERE
    swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
    -- AND block_timestamp >= CURRENT_DATE - INTERVAL '1 MONTH'
    )
    SELECT
    CONCAT(swap_from_symbol, '-', swap_to_symbol) AS swap_pair,
    COUNT(DISTINCT tx_id) AS distinct_swap_count,
    COUNT(DISTINCT swapper) AS distinct_swapper_count,
    SUM(swap_from_amount_usd) AS total_swap_volume_usd
    FROM
    swap_data
    where swap_pair IS NOT NULL
    GROUP BY
    swap_pair
    ORDER BY
    total_swap_volume_usd DESC
    LIMIT 10

    Last run: 3 months ago
    SWAP_PAIR
    DISTINCT_SWAP_COUNT
    DISTINCT_SWAPPER_COUNT
    TOTAL_SWAP_VOLUME_USD
    1
    		MSOL-SOL38719082438511996377636.13
    2
    		MSOL-USDC191544474448660620419.18
    3
    		MSOL-JITOSOL11526129513107094811.28
    4
    		MSOL-USDT42593016249102383096.45
    5
    		MSOL-BSOL1034141882073432857.12
    6
    		MSOL-MSOL57658411749605607.23
    7
    		MSOL-JUPSOL13436233331587297.33
    8
    		MSOL-INF4463196827413253.05
    9
    		MSOL-STSOL82635273416983121.96
    10
    		MSOL-ETH36810247314609045.4
    10
    390B
    5s