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.
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
