flipside

    per platform
    datavortexper platform
    Updated 2025-02-18
    WITH swap_data AS (
    SELECT
    platform,
    swap_from_mint,
    tx_id,
    swapper,
    swap_from_amount_usd
    FROM
    solana.marinade.ez_swaps
    WHERE
    swap_from_mint IN ('MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey', 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So')
    AND swap_from_amount_usd IS NOT NULL
    )
    SELECT
    platform,
    COUNT(DISTINCT CASE WHEN swap_from_mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' THEN tx_id END) AS MNDE_Distinct_Tx_Count,
    COUNT(DISTINCT CASE WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN tx_id END) AS MSOL_Distinct_Tx_Count,
    COUNT(DISTINCT CASE WHEN swap_from_mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' THEN swapper END) AS MNDE_Distinct_Swapper_Count,
    COUNT(DISTINCT CASE WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swapper END) AS MSOL_Distinct_Swapper_Count,
    SUM(CASE WHEN swap_from_mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' THEN swap_from_amount_usd END) AS MNDE_Total_Swap_Volume_USD,
    SUM(CASE WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_from_amount_usd END) AS MSOL_Total_Swap_Volume_USD
    FROM
    swap_data
    GROUP BY
    platform
    HAVING
    COUNT(DISTINCT tx_id) > 0
    ORDER BY
    COUNT(DISTINCT tx_id) DESC,
    SUM(swap_from_amount_usd) DESC;

    Last run: 2 months ago
    PLATFORM
    MNDE_DISTINCT_TX_COUNT
    MSOL_DISTINCT_TX_COUNT
    MNDE_DISTINCT_SWAPPER_COUNT
    MSOL_DISTINCT_SWAPPER_COUNT
    MNDE_TOTAL_SWAP_VOLUME_USD
    MSOL_TOTAL_SWAP_VOLUME_USD
    1
    		Raydium Liquidity Pool V498551109301734657207251405202.2835988288.86
    2
    		jupiter swap v628154318240152476020480068972937.012180693460.6
    3
    		jupiter aggregator v3440721678582143911487770702.95210415382.13
    4
    		jupiter swap v464074156561636621447317322930.76131609812.04
    5
    		raydium concentrated liquidity1102311518181453343162417359.25315298343.96
    6
    		jupiter aggregator v2136644788954859803712429162.31176559439.36
    7
    		orca whirlpool program7753139959194457116287592.2242971060.63
    8
    		jupiter swap v513612124799350382797184.062430811.4
    9
    		meteora pools program231712347977485946767.1383861600.31
    10
    		ORCA Token Swap V264677087811362305573640.9224807079.64
    11
    		meteora dlmm pools program82145966281682395052.5913837707.34
    12
    		jupiter swap v5.1215629815436951568293.427460246.29
    13
    		Saber Stable Swap0149990252595050.81
    14
    		phoenix380127852977859051.882559720.53
    15
    		bonkswap03484018164603.63
    16
    		Saber Router04110271476827.49
    17
    		raydium constant product market maker24301015178.4196.46
    17
    1KB
    9s