SWAP PROGRAM | SWAP TO SYMBOL | Total Trades Done | Total Volume USD | Total Micro Trades | Average Trade Size USD | |
|---|---|---|---|---|---|---|
1 | meteora dlmm pools program | HSOL | 1915772 | 1849753.13 | 1892984 | 0.9653679587 |
2 | Raydium Liquidity Pool V4 | YODA | 122854 | 90650.93 | 1457804 | 0.06216870899 |
3 | meteora pools program | 🦝 | 147344 | 19036.42 | 147119 | 0.129197117 |
4 | Raydium Liquidity Pool V4 | CENTS | 92918 | 49099.53 | 92419 | 0.5284178523 |
5 | raydium constant product market maker | SOLARBA | 62535 | 43341.07 | 62043 | 0.6930690014 |
bobby_daniel1_2-Suspicious Trades Tokens
Updated 2025-04-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DISTINCT SWAP_PROGRAM AS "SWAP PROGRAM",
SWAP_TO_SYMBOL AS "SWAP TO SYMBOL",
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,2
Having "Total Micro Trades" > 50 AND "Total Volume USD"/"Total Trades Done" <1
ORDER BY "Total Micro Trades" DESC
Limit {{Number of Swap Programs}}
Last run: about 2 months ago
5
380B
122s