PLATFORM | TOTAL_ATTACKED_BLOCKS | TOTAL_ATTACKED_POOLS | TOTAL_INPUT_TOKENS | TOTAL_OUTPUT_TOKENS | |
|---|---|---|---|---|---|
1 | fraxswap | 13 | 5 | 6 | 7 |
2 | pancakeswap-v2 | 255 | 29 | 27 | 23 |
3 | uniswap-v2 | 204130 | 8534 | 7243 | 7247 |
4 | pancakeswap-v3 | 4683 | 83 | 62 | 68 |
5 | dodo-v2 | 1224 | 139 | 117 | 117 |
6 | balancer | 2240 | 129 | 94 | 95 |
7 | verse | 141 | 8 | 9 | 9 |
8 | shibaswap | 1235 | 58 | 50 | 47 |
9 | curve | 3169 | 86 | 74 | 68 |
10 | sushiswap | 6627 | 356 | 313 | 314 |
11 | dodo-v1 | 723 | 2 | 1 | 2 |
12 | uniswap-v3 | 90841 | 2856 | 1978 | 1953 |
MotilolaShowing Jared’s Exploits in AMM Pools, DEXs, Token Across Platform
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,
tx_hash,
origin_to_address,
contract_address,
pool_name,
symbol_in,
symbol_out,
platform
FROM ethereum.defi.ez_dex_swaps
WHERE origin_to_address = lower('0x1f2f10d1c40777ae1da742455c65828ff36df387')
),
-- Find blocks with exactly 2 transactions
filtered_blocks AS (
SELECT
block_number,
COUNT(tx_hash) AS tx_count
FROM txs_raw
GROUP BY block_number
HAVING tx_count = 2
),
return_filtered_blocks AS (
SELECT
b.block_number,
LOWER(r.pool_name) AS filtered_pool_name,
LOWER(r.symbol_in) AS filtered_symbol_in,
LOWER(r.symbol_out) AS filtered_symbol_out,
r.platform
FROM txs_raw r
JOIN filtered_blocks b ON r.block_number = b.block_number
)
Last run: 2 days ago
12
343B
3s