bobby_daniel1_1-Top 5 Swap Programs With Highest Micro Trades
    Updated 2025-04-04
    SELECT
    DISTINCT SWAP_PROGRAM AS "SWAP PROGRAM",
    COUNT(DISTINCT tx_id) AS "Total Trades Done",
    SUM(swap_from_amount_usd) AS "Total Volume USD",
    SUM(CASE WHEN swap_from_amount_usd < 10 THEN 1 ELSE 0 END) AS "Total Micro Trades",
    AVG(swap_from_amount_usd) AS "Average Trade Size USD"
    FROM solana.defi.ez_dex_swaps
    WHERE block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP)
    AND swap_from_amount_usd IS NOT NULL -- ensure we have valid USD amounts
    GROUP BY 1
    ORDER BY "Total Micro Trades" DESC
    Limit {{Swap_Program_Amount}}
    Last run: about 2 months ago
    SWAP PROGRAM
    Total Trades Done
    Total Volume USD
    Total Micro Trades
    Average Trade Size USD
    1
    Raydium Liquidity Pool V419258505913380748644.6213180985162.853568331
    2
    pump.fun490804891886517888.182894998338.276395812
    3
    raydium constant product market maker20257832348000902.281836815016.432123996
    4
    meteora dlmm pools program250969729205746627.0516604704326.21923461
    5
    raydium concentrated liquidity646389179414737482.5313003667141.234548019
    5
    380B
    215s