flipside

    platform
    sagharkariplatform
    Updated 2025-04-06
    SELECT
    platform,
    COUNT(DISTINCT tx_id) AS swap_count,
    COUNT(DISTINCT swapper) AS unique_swappers,
    SUM((swap_from_amount_usd + swap_to_amount_usd) / 2) 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 platform
    ORDER BY total_volume_usd DESC
    limit 7;
    Last run: 21 days ago
    PLATFORM
    SWAP_COUNT
    UNIQUE_SWAPPERS
    TOTAL_VOLUME_USD
    1
    		jupiter swap v6166216230601155613089.72
    2
    		raydium concentrated liquidity73465794025291553167.6
    3
    		meteora pools program1178642105756224909.03
    4
    		Raydium Liquidity Pool V42198802982327753502.855
    5
    		meteora dlmm pools program41295759916866434.665
    6
    		orca whirlpool program1208123433274404.215
    7
    		Saber Stable Swap1462106562.645
    7
    359B
    4s