Total Trades Done | Fake Volume | Total Micro Trades | |
|---|---|---|---|
1 | 94016308 | 10445132.23 | 105489206 |
bobby_daniel1-Suspicious Trades Done
Updated 2025-04-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH suspicious_pairs AS (
SELECT
swapper as trader,
COUNT(DISTINCT tx_id) AS trades,
SUM(swap_from_amount_usd) AS fake_volume,
SUM(CASE WHEN swap_from_amount_usd < 10 THEN 1 ELSE 0 END) AS micro_trades
FROM solana.defi.ez_dex_swaps
WHERE block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP)
GROUP BY 1
HAVING micro_trades > 100 AND fake_volume/trades < 1 -- High freq, low value
)
SELECT
sum (s.trades) as "Total Trades Done",
sum(s.fake_volume) as "Fake Volume",
sum(s.micro_trades) as "Total Micro Trades"
FROM suspicious_pairs s
LEFT JOIN solana.core.dim_labels l ON s.trader = l.address
Last run: about 2 months ago
1
34B
135s