external.flashbots Table: fact_mevshare_transactions Type: View
What
This table records all the landed backrun transactions on MEV-share, and its original user transaction that is being backrun, as well as the refund transaction where block builder send searcher’s refund back to originating user. These 3 transactions are settled in a bundle with the order of(user_tx, backrun_tx, refund_tx). MEV-share is the Order Flow Auction (OFA) product from
Flashbots, resharing MEV profits back to users, with parameterized privacy features. MEV-share
inherit orderflow coming from Flashbots Protect RPC endpoint. Read more in
Flashbots docs! Please reach out to the
Flashbots team for any data discrepancies or questions.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_NUMBER | NUMBER | The number of the block in which transactions were included. |
| BLOCK_TIME | TIMESTAMP_NTZ | The timestamp for when the block was mined. |
| BLOCK_HASH | TEXT | The hash of the block in which the MEV-share transactions landed. |
| EXTRA_DATA | TEXT | Additional data included in the block, often used for identifying the block builder. |
| FEE_RECIPIENT_ADDRESS | TEXT | The Ethereum address of the recipient of block rewards, which can be the block builder or validator. |
| BUNDLE_ID | NUMBER | A row number partitioned by (usertxhash, backruntxhash) to use as part of the deterministic id for refund bundles. |
| USER_TX_HASH | TEXT | The Ethereum hash of the user’s protect transaction. |
| USER_TX_FROM | TEXT | The Ethereum address of the sender of the protect transaction. |
| USER_TX_TO | TEXT | The Ethereum address of the recipient of the protect transaction. |
| BACKRUN_TX_HASH | TEXT | The Ethereum hash of the transaction that backran the user’s transaction in MEV-share OFA. |
| BACKRUN_TX_FROM | TEXT | The Ethereum address of the sender of the backrunning transaction. |
| BACKRUN_TX_TO | TEXT | The Ethereum address of the recipient of the backrunning transaction. |
| REFUND_TX_HASH | TEXT | The Ethereum hash of the refund transaction. |
| REFUND_FROM | TEXT | REFUND_FROM column |
| REFUND_TO | TEXT | REFUND_TO column |
| REFUND_VALUE_ETH | TEXT | The amount of ETH refunded to the protect transaction, as a result of a successful OFA backrun, depending on user’s refund percentage setting when sending the transaction. |
| IS_MEVSHARE | BOOLEAN | If true, mev-share matched the transactions in the bundle. If false, it was sent pre-matched from a third party to mev-share. |