Flashbots Mempool Dumpster

Summary

Historical dataset of mempool dumpster transactions.

Process

We ETL data from the mempool dumpster ↗, store and make the data available in BigQuery. Our dataset contains public information provided by the mempool dumpster.

BigQuery

By making the data available in BigQuery, it can be queried and joined with other public datasets, like the Ethereum Blockchain dataset or simply exported.

• Dataset: eden-data-public.flashbots Open in BigQuery ↗
• Table: eden-data-public.flashbots.mempool_dumpster Open in BigQuery ↗
• Update frequency: 24 hours
• Partitioning: Daily

BigQuery Access

You need to be logged into your Google Account with a Project selected

Example Query

You can get started with the example query below.

SELECT *
FROM `eden-data-public.flashbots.mempool_dumpster` 
WHERE DATE(block_timestamp) = CURRENT_DATE()

Working with Partioned Tables

You should usually use a WHERE clause on partitioned data to save on query costs. Learn more

See Related

• eden-data-public.flashbots.mev_share
• eden-data-public.gnosis.mev_blocker