6_1-MEV BOT ADDRESSES

bobby_daniel6_1-MEV BOT ADDRESSES

Updated 2025-05-05

WITH potential_mev_swaps AS (

SELECT

swapper as bot_address,

tx_id,

block_timestamp,

swap_from_amount_usd

FROM solana.defi.ez_dex_swaps

WHERE block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP())

AND swap_from_amount_usd > 0

-- Identify addresses with high-frequency trading behavior

mev_bot_metric AS (

SELECT

bot_address,

COUNT(DISTINCT tx_id) as total_trades,

COUNT(DISTINCT DATE_TRUNC('hour', block_timestamp)) as active_hours,

AVG(swap_from_amount_usd) as avg_value_usd

FROM potential_mev_swaps

GROUP BY bot_address

HAVING total_trades > 100 -- Filter for high-frequency traders

AND active_hours > 24 -- Active across multiple hours

-- Join with labels to identify known MEV bots

bot_labels AS (

SELECT

address,

label_type,

label_subtype,

label,

address_name

FROM solana.core.dim_labels

WHERE label_type IN ('dex', 'defi')

OR label LIKE '%bot%'

OR label LIKE '%MEV%'

Last run: about 1 month ago

	BOT_ADDRESS	TOTAL_TRADES	ACTIVE_HOURS	AVG_VALUE_USD	MEV_LIKELIHOOD_SCORE
1	MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa	7736615	718	906.108420467	5554889570
2	AzDByJsGm9gAVQPX8v8WS3iAs3PPdTwZZDDUNP2u5nVj	3287965	720	2436.36038428	2367334800
3	CsVdJ8WH8Q9eHSTRpwtwN3TYApm24QnLKYUMNxJ3DaED	2625744	720	152.378968753	1890535680
4	CapuXNQoDviLvU1PxFiizLgPNQCxrsag1uMeyk6zLVps	2505933	720	194.583061638	1804271760
5	6LXutJvKUw8Q5ue2gCgKHQdAN4suWW8awzFVC6XCguFx	2498172	720	193.928672554	1798683840
6	GGztQqQ6pCPaJQnNpXBgELr5cs3WwDakRbh1iEMzjgSJ	2498109	720	194.151114206	1798638480
7	2MFoS3MPtvyQ4Wh4M9pdfPjz6UhVoNbFbGJAskCPCj3h	2497832	720	193.157799158	1798439040
8	6U91aKa8pmMxkJwBCfPTmUEfZi6dHe7DcFq2ALvB2tbB	2497453	720	192.328135016	1798166160
9	9nnLbotNTcUhvbrsA6Mdkx45Sm82G35zo28AqUvjExn8	2496068	720	196.526637761	1797168960
10	4xDsmeTWPNjgSVSS1VTfzFq3iHZhp77ffPkAmkZkdu71	2495232	720	196.138394813	1796567040

1010B

40s

flipside