Afonso_Diazzealous-amaranth
    Updated 2025-01-31
    SELECT
    f.swap_program,
    COUNT(DISTINCT e.tx_id) AS Swaps,
    COUNT(DISTINCT e.swapper) AS Swappers,
    SUM(NVL(e.SWAP_FROM_AMOUNT_USD, e.SWAP_TO_AMOUNT_USD)) AS Total_Swap_Volume_USD,
    AVG(NVL(e.SWAP_FROM_AMOUNT_USD, e.SWAP_TO_AMOUNT_USD)) AS Average_Swap_Volume
    FROM
    solana.defi.fact_swaps f
    JOIN
    solana.defi.ez_dex_swaps e
    ON f.tx_id = e.tx_id
    WHERE
    (e.Swap_from_mint = '2zMMhcVQEXDtdE6vsFS7S7D5oUodfJHE8vd1gnBouauv'
    OR e.swap_to_mint = '2zMMhcVQEXDtdE6vsFS7S7D5oUodfJHE8vd1gnBouauv')
    GROUP BY
    f.swap_program
    ORDER BY
    Total_Swap_Volume_USD DESC
    Last run: 21 days ago
    SWAP_PROGRAM
    SWAPS
    SWAPPERS
    TOTAL_SWAP_VOLUME_USD
    AVERAGE_SWAP_VOLUME
    1
    raydium concentrated liquidity59518165118004366714269.28547.742002441
    2
    orca whirlpool program20501811970792881141532.2920.754608484
    3
    meteora dlmm pools program26344921964802569247337.53626.016011585
    4
    phoenix28852545897230717469.84620.533531932
    5
    Raydium Liquidity Pool V435376440767105639547.18218.809647177
    6
    pumpswap1800561666237313299.83147.1983109
    7
    raydium constant product market maker1995843284925779259.1977.917326646
    8
    meteora pools program2778352296425052261.7350.489658576
    9
    raydium liquidity pool program id v591365368707928977.8286.312133371
    10
    lifinity swap v23130410065884073.53119.026469708
    11
    ORCA Token Swap V2881910082658161.25245.308347176
    12
    stepn swap906201561247.61564.635422535
    13
    bonkswap4457514167075.2427.953026602
    14
    pump.fun48412897163834.1533.198409321
    15
    orca token swap2680386124054.1735.812404734
    16
    Saber Stable Swap1011060.5375.752142857
    16
    968B
    175s