flipside

    pair v
    Specterpair v
    Updated 2025-02-18
    WITH msol_outgoing AS (
    SELECT CONCAT(swap_from_symbol, ' --> ', swap_to_symbol) AS asset_pair,
    SUM(swap_from_amount_usd) AS swap_amount_usd
    FROM solana.marinade.ez_swaps
    WHERE (swap_from_symbol = 'MSOL'
    OR swap_to_symbol = 'MSOL')
    AND asset_pair IS NOT NULL
    AND Block_timestamp >= '2024-01-01'
    GROUP BY swap_from_symbol, swap_to_symbol
    )
    SELECT
    asset_pair,
    swap_amount_usd,
    FROM msol_outgoing
    ORDER BY swap_amount_usd DESC;
    limit 10




    Last run: 2 months ago
    ASSET_PAIR
    SWAP_AMOUNT_USD
    1
    		SOL --> MSOL2573412014.44
    2
    		MSOL --> SOL1444027299.58
    3
    		MSOL --> USDC434561047.2
    4
    		USDC --> MSOL182653643.48
    5
    		JITOSOL --> MSOL89030966.5
    6
    		MSOL --> JITOSOL77267074.85
    7
    		MSOL --> BSOL49898199.84
    8
    		BSOL --> MSOL45121617.06
    9
    		MSOL --> JUPSOL31599655.23
    10
    		MSOL --> INF27402841.95
    10
    310B
    0s