flipside

    platform volume
    damidezplatform volume
    Updated 2025-02-18
    WITH msol_swaps AS (
    SELECT
    Block_timestamp,
    tx_id,
    swapper,
    swap_from_symbol,
    swap_to_symbol,
    swap_from_amount_usd,
    platform
    FROM solana.marinade.ez_swaps
    WHERE (swap_from_symbol = 'MSOL' OR swap_to_symbol = 'MSOL')
    AND Block_timestamp >= '2024-01-01'
    AND succeeded = 1
    )

    SELECT
    platform,
    COUNT(DISTINCT tx_id) AS swap_count,
    SUM(swap_from_amount_usd) AS total_volume_usd
    FROM msol_swaps
    GROUP BY platform
    ORDER BY total_volume_usd DESC;
    LIMIT 10;


    Last run: about 2 months ago
    PLATFORM
    SWAP_COUNT
    TOTAL_VOLUME_USD
    1
    		jupiter swap v622647314522010723.68
    2
    		raydium concentrated liquidity1215877455016678.27
    3
    		meteora pools program209720131803339.43
    4
    		orca whirlpool program4269841301503.49
    5
    		Raydium Liquidity Pool V4148231835886764.79
    6
    		meteora dlmm pools program9225829024915.21
    7
    		jupiter aggregator v2126293284025.4
    8
    		jupiter swap v448591385411.47
    9
    		Saber Stable Swap2682958054.38
    10
    		jupiter aggregator v364295652.97
    10
    443B
    11s