Flashbots
Flashbots is a research and development organization formed with the goal of making sure MEV incentives do not become opaque and undemocratic.
Note: mev-inspect-py, Flashbots’ open source engine for generating MEV data, is used to power dashboards such as mev-explore and Dune’s Flashbots integration. We’re always looking to improve, fix bugs, cover edge cases, and add protocol coverage to the best of our ability with the help of our community and contributors. We encourage researchers and developers to report and help correct any found bugs, or implement any new features! Feel free to consult the documentation and join the Flashbots discord for more information and updates on our data and mev-inspect

flashbots.mev_summary

This table contains summary of all the classified transactions
Query examples can be found here: Miner Revenue from Liquidations and Arbitrages
Column name
Type
Description
block_timestamp
timestamp
Block timestamp
block_number
bigint
Block number
base_fee_per_gas
bigint
Base fee per gas
coinbase_transfer
bigint
Direct transfer to miner’s address
error
string
Error if exists
gas_price
bigint
Price of the gas
gas_price_with_coinbase_transfer
bigint
Amount of gas spent + direct transfer to miner address
gas_used
bigint
Amount of gas used
gross_profit_usd
double
Total profit from the transaction in usd
miner_address
string
Address of the miner
miner_payment_usd
double
Payment received by the miner in usd
protocol
string
Main interacted protocol
protocols
string
List of protocols involved in the transaction
transaction_hash
string
Hash of the transaction
type
string
Type of the MEV (e.g. arbitrage)
timestamp
timestamp
Timestamp of the latest update of the file

flashbots.arbitrages

This table contains records with additional information about each arbitrage trade.
Query examples can be found here: Total Arb Protocols
Column name
Type
Description
block_number
bigint
Block number
account_address
string
Address of the searcher
created_at
string
Time of the record creation
end_amount
bigint
Available amount after the arbitrage
error
string
Available amount after the arbitrage
id
string
Internal id of the arbitrage
profit_amount
bigint
Profit amount after the arbitrage
profit_token_address
string
Address of the profit asset
protocols
string
List of protocols involved in the transaction
start_amount
bigint
Available amount before the arbitrage
transaction_hash
string
Hash of the transaction
timestamp
timestamp
Timestamp of the latest update of the file

flashbots.liquidations

Liquidation is another MEV strategy. This table contains details related to executed liquidations.
Query examples can be found here: Liquidations by Protocol
Column name
Type
Description
created_at
string
Time of the records creation
transaction_hash
string
Transaction hash
trace_address
string
Trace pattern related to the position of the transaction in the chain of all transactions related to the MEV trade.
debt_token_address
string
Underlying token address of the debt to pay
received_amount
bigint
Amount received from the liquidation
protocol
string
Protocol name
liquidated_user
string
Address of the liquidated user
liquidator_user
string
Address of the liquidator user
received_token_address
string
Address of the received asset
block_number
bigint
Block number
debt_purchase_amount
bigint
Amount of purchased debt
timestamp
timestamp
Timestamp of the latest update of the file

flashbots.sandwiched_swaps

The sandwiched_swaps table contains additional data about one or more swaps that were sandwiched with a corresponding sandwich in the database.
Query examples can be found here:
Column name
Type
Description
created_at
string
Time of the records creation
block_number
bigint
Block number
sandwich_id
string
Internal id of the sandwiched swap
trace_address
string
Trace pattern related to the position of the swap in the chain of all swaps related to the arbitrage trade.
transaction_hash
string
Transaction hash
timestamp
timestamp
Timestamp of the latest update of the file

flashbots.sandwiches

This table contains detailed information about executed sandwiches
Query examples can be found here:
Column name
Type
Description
created_at
datetime
Time of the records creation
block_number
bigint
Block number
backrun_swap_trace_address
string
address of the swap in the backrun transaction
backrun_swap_transaction_hash
string
transaction_hash of backrun transaction of specified sandwich
frontrun_swap_trace_address
string
address of the swap in the frontrun transaction
frontrun_swap_transaction_hash
string
transaction_hash of frontrun transaction of specified sandwich
id
string
Internal id of the sandwich
profit_amount
bigint
Profit amount after the arbitrage
profit_token_address
string
Address of the profit asset
sandwicher_address
string
Address of the sandwicher
timestamp
timestamp
Timestamp of the latest update of the file

flashbots.blocks

This table contains block numbers and corresponding block_timestamps
Query examples can be found here:
Column name
Type
Description
block_number
bigint
Block number
block_timestamp
timestamp
Block timestamp