mev_summary

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
Copy link