Sandwich Trades
Sandwich Trades Table
The Sandwich Trades table captures DEX events where sandwich trading activity is detected.
Sandwich trading involves placing two trades (a front-run and a back-run) around a victim's trade to manipulate the market price for profit.
Sample Query
Finding the total USD amount of sandwich trades by project and date:
Methodology
We use the dex.trades
table to construct this table. This table contains all trade events from DEX protocols. We identify sandwich trades using the following criteria:
Trade Pair Identification:
The sandwich trade (swap1 , swap2) must occur within the same block.
It must be executed in the same liquidity pool (same
liquidity_pool_address
).It must be executed by the same signer (
transaction_from_address
).The transaction indices must be different (
transaction_index
).
Direction Determination:
If
s1.transaction_index
>s2.transaction_index
, the trade is a "back" part of the sandwich.If
s1.transaction_index
<s2.transaction_index
, the trade is a "front" part of the sandwich.
Token Matching:
The token bought in the first trade (
s1
) must match the token sold in the second trade (s2
).Alternatively, the token sold in the first trade (
s1
) should be the token bought in the second trade (s2
).
Exclusion of Non-Applicable Projects:
Exclude DEXs without the concept of liquidity pools, such as RFQ protocols like Airswap.
Table Columns
Column Name | Description | Example |
---|---|---|
direction | Indicates whether the transaction is the front or back of the sandwich trade | back |
project | The project or DEX name where the trade occurred | uniswap |
protocol | The protocol used within the project | uniswap_v2 |
block_timestamp | The timestamp of the block containing the trade | 2024-06-13 01:00:11.000 |
block_number | The block number containing the trade | 20079481 |
transaction_index | The index of the transaction within the block | 7 |
sandwich_transaction_index | The transaction index of the corresponding sandwich within the block (back/front) | 5 |
log_index | The index of the log within the block | 56 |
transaction_hash | The hash of the transaction | 0x07fe3f18c82800b63072d14606d85d72ccdda9a5cf1c8a6aed900450d761e363 |
sandwich_transaction_hash | The hash of the corresponding end of sandwich (back/front) | 0x25273ef2808f689f8621daf2c2ae25746f30367780c54dc2ec90938d0c37efcc |
liquidity_pool_address | The address of the liquidity pool involved in the trade | 0xbf16540c857b4e32ce6c37d2f7725c8eec869b8b |
transaction_from_address | The address initiating the transaction | 0x8ef57238cd4178eed96cd30a13cbc7448925328e |
transaction_to_address | The address receiving the transaction | 0x00000023c10000eecb940000b914cdfd76cc83d1 |
token_sold_address | The address of the token sold in the transaction | 0x3ffeea07a27fab7ad1df5297fa75e77a43cb5790 |
token_sold_symbol | The symbol of the token sold in the transaction | PEIPEI |
token_sold_name | The name of the token sold in the transaction | PeiPei |
token_sold_amount | The amount of the token sold | 50279216370.7169 |
token_sold_amount_str | The amount of the token sold, in string format for precision. | 50279216370.716897543345668096 |
token_sold_amount_raw | The raw string representation of the amount of the token sold | 50279216370716897543345668096 |
token_bought_address | The address of the token bought in the transaction | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 |
token_bought_symbol | The symbol of the token bought in the transaction | WETH |
token_bought_name | The name of the token bought in the transaction | Wrapped Ether |
token_bought_amount | The amount of the token bought | 2.759992254 |
token_bought_amount_str | The amount of the token bought, in string format for precision. | 2.759992254092279808 |
token_bought_amount_raw | The raw string representation of the amount of the token bought | 2759992254092279808 |
usd_amount | The USD value of the swap log | 9817.485647264 |
sender_address | The address of the sender in the swap | 0x00000023c10000eecb940000b914cdfd76cc83d1 |
recipient_address | The address of the recipient in the swap | 0x00000023c10000eecb940000b914cdfd76cc83d1 |
unique_id | The unique identifier for the transaction | txn-0x07fe3f18c82800b63072d14606d85d72ccdda9a5cf1c8a6aed900450d761e363_log_index-56 |
Last updated