Sandwich Trades
Last updated
Last updated
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.
Finding the total USD amount of sandwich trades by project and date:
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.
| 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 |
