flipside

    MDNE PAIR
    datavortexMDNE PAIR
    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 = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey'
    )
    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
    		MNDE-USDC1960501081251613307.76
    2
    		MNDE-SOL953591546817397962.32
    3
    		MNDE-MSOL1681161067714010138.13
    4
    		MNDE-USDT1572421756803067.46
    5
    		MNDE-BONK383012561060632.8
    6
    		MNDE-NEON46676638203
    7
    		MNDE-JUP2871769637650.46
    8
    		MNDE-JTO1536289532276.38
    9
    		MNDE-RAY831298525939.96
    10
    		MNDE-WIF1563325512292.77
    10
    341B
    3s