PLATFORM | HIGHEST_TRADE_IN_VALUE | HIGHEST_TRADE_OUT_VALUE | |
|---|---|---|---|
1 | balancer | 3192193.52 | 3193109.33 |
2 | curve | 4220331.48 | 4220331.48 |
3 | dodo-v1 | 1732799.6 | 1734294.13 |
4 | dodo-v2 | 1502737.83 | 1505319.89 |
5 | fraxswap | 5864.89 | 5935.18 |
6 | pancakeswap-v2 | 1133124.24 | 1141923.28 |
7 | pancakeswap-v3 | 2396825.37 | 2384364.62 |
8 | shibaswap | 36408.49 | 36502.69 |
9 | sushiswap | 104529.06 | 104531.79 |
10 | uniswap-v2 | 5499397.34 | 5501234.07 |
11 | uniswap-v3 | 5487536.96 | 5502189.38 |
12 | verse | 4150.29 | 4176.52 |
MotilolaPlatform Spotlight: Jared's High-Value Sandwich Trades
Updated 2 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH txs_raw AS (
SELECT
block_number,
block_timestamp,
tx_hash,
origin_to_address,
amount_in_usd,
amount_out_usd,
symbol_in,
symbol_out,
platform
FROM
ethereum.defi.ez_dex_swaps
WHERE
origin_to_address = lower('0x1f2f10d1c40777ae1da742455c65828ff36df387')
),
filtered_blocks AS (
SELECT
block_number,
COUNT(tx_hash) AS attacker_tx_count
FROM
txs_raw
GROUP BY
block_number
HAVING
COUNT(tx_hash) = 2
)
SELECT
tr.platform,
MAX(tr.amount_in_usd) AS highest_trade_in_value,
MAX(tr.amount_out_usd) AS highest_trade_out_value
FROM
filtered_blocks fb
JOIN
txs_raw tr ON fb.block_number = tr.block_number
Last run: 2 days ago
12
412B
2s