external.flashbots Table: fact_protect_transactions Type: View
What
This table contains all the transactions received by Flashbots Protect RPC that are seen landed onchain, including the privacy setting user or application set when sending them. Read more about Flashbots Protect from documentation and website! Please reach out to the Flashbots team for any data discrepancies or questions.Columns
| Column Name | Data Type | Description |
|---|---|---|
| TX_HASH | TEXT | The Ethereum transaction hash of the protect transaction. |
| FROM_ADDRESS | TEXT | The Ethereum address of the sender initiating the transaction. |
| TO_ADDRESS | TEXT | The Ethereum address of the recipient of the transaction. |
| CREATED_AT_BLOCK_NUMBER | NUMBER | The block number at which the transaction was created (first received by Flashbots server). Note - Due to some reorg/simulation issues, there are some rows where createdatblocknumber > includedblock_number |
| TX_ID | TEXT | A row number partitioned by (txhash, createdatblocknumber, includedblocknumber) to use as part of the deterministic id for transactions who were submitted multiple times at same block, with different shared configs |
| HINTS_SELECTED | TEXT | The hints shared by the user for public streaming to searchers in the MEV-share orderflow auction (OFA). |
| NUM_OF_BUILDERS_SHARED | NUMBER | The number of block builders the transaction was shared with, higher number will likely help faster inclusion speed onchain. |
| REFUND_PERCENT | NUMBER | The percentage of OFA backrun profits refunded to the sender (user). The rest can be kept by builders or bided to payout to validator. Flashbots builders keeps 0 profit and send it to validator in the end of block payment transaction. |