flipside

    platform volume Trend
    Specterplatform volume Trend
    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
    ),
    top_10_platforms AS (
    SELECT
    platform,
    SUM(swap_from_amount_usd) AS total_volume_usd
    FROM msol_swaps
    GROUP BY platform
    ORDER BY total_volume_usd DESC
    LIMIT 10
    )

    SELECT
    DATE_TRUNC('month', Block_timestamp) AS date,
    m.platform,
    COUNT(DISTINCT m.tx_id) AS swap_count,
    SUM(m.swap_from_amount_usd) AS total_volume_usd
    FROM msol_swaps m
    JOIN top_10_platforms t ON m.platform = t.platform
    GROUP BY date, m.platform
    ORDER BY date DESC;

    Last run: 2 months ago
    DATE
    PLATFORM
    SWAP_COUNT
    TOTAL_VOLUME_USD
    1
    		2025-02-01 00:00:00.000meteora pools program1556613311999.34
    2
    		2025-02-01 00:00:00.000raydium concentrated liquidity7921435051035.43
    3
    		2025-02-01 00:00:00.000Raydium Liquidity Pool V419056774777.72
    4
    		2025-02-01 00:00:00.000orca whirlpool program1647619859.7
    5
    		2025-02-01 00:00:00.000jupiter swap v631540237146210.93
    6
    		2025-02-01 00:00:00.000meteora dlmm pools program66792766923.14
    7
    		2025-02-01 00:00:00.000Saber Stable Swap104252.59
    8
    		2025-01-01 00:00:00.000Raydium Liquidity Pool V415072625849407.35
    9
    		2025-01-01 00:00:00.000Saber Stable Swap124101784.26
    10
    		2025-01-01 00:00:00.000jupiter swap v652338499872230.58
    11
    		2025-01-01 00:00:00.000meteora dlmm pools program2180212046857.37
    12
    		2025-01-01 00:00:00.000meteora pools program6331027472752.02
    13
    		2025-01-01 00:00:00.000orca whirlpool program38612058213.65
    14
    		2025-01-01 00:00:00.000raydium concentrated liquidity492273214907231.65
    15
    		2024-12-01 00:00:00.000Saber Stable Swap348706.31
    16
    		2024-12-01 00:00:00.000meteora pools program2323018900610.84
    17
    		2024-12-01 00:00:00.000orca whirlpool program1612832248.16
    18
    		2024-12-01 00:00:00.000raydium concentrated liquidity13044935759793.41
    19
    		2024-12-01 00:00:00.000meteora dlmm pools program126441323579.28
    20
    		2024-12-01 00:00:00.000Raydium Liquidity Pool V433396976163.52
    ...
    112
    7KB
    3s