BlockDB/MEV-Arbitrage-Opportunities-Ethereum-And-EVM-Cryptocurrency-Data

---
license: cc-by-nc-4.0
tags:
- ethereum
- evm
- blockchain
- cryptocurrency
- crypto
- onchain-data
- defi
- arbitrage
- mev
- tabular
- datasets
- pandas
- polars
- duckdb
pretty_name: BlockDB Arbitrage Opportunities - Sample
size_categories:
- 1M<n<10M
dataset_info:
homepage: https://docs.blockdb.io/api-reference/evm/overview
---


## Sample Notice

This dataset contains **a small sample** of the full BlockDB Arbitrage Opportunities dataset.
It is provided **for evaluation, research, and interoperability testing only**.

If you need full historical coverage, real-time streaming, or end-of-day (EOD) exports
please contact us directly:

📧 **[e-mail]**
🌐 https://www.blockdb.io

**Hub:** [BlockDB/Arb-Opportunities](https://huggingface.co/datasets/BlockDB/Arb-Opportunities)

## Dataset Overview

Estimated arbitrage profitability at specific on-chain observation points: `path_id`, directional `is_reversed`, aligned `pool_uids`, `token_path`, and `amounts`, plus profit in the start token and USD.
Delivered in archive + real-time via the [BlockDB API](https://docs.blockdb.io/api-reference/evm/overview) (REST + WebSocket).

## Chains and Coverage

ETH, BSC, Base, Arbitrum, Unichain, Avalanche, Polygon, Celo, Linea, Optimism (others on request).
Full history from chain genesis; reorg-aware real-time ingestion and updates.

## Schema

Column definitions match the [data catalog](../../data-catalog/evm/) (Postgres types).

| Column | Type | Description |
| --- | --- | --- |
| `block_number` | `BIGINT` | Observation block. |
| `block_time` | `TIMESTAMPTZ` | Block time. |
| `tx_index` | `INTEGER` | Transaction index. |
| `log_index` | `INTEGER` | Log index. |
| `path_id` | `BYTEA` | 32B path id (`octet_length` = 32). |
| `is_reversed` | `BOOLEAN` | True if evaluated in reversed direction. |
| `pool_uids` | `BYTEA[]` | Pool UIDs in evaluated order. |
| `token_path` | `BYTEA[]` | Tokens in evaluated order. |
| `amounts` | `NUMERIC(78,18)[]` | Per-hop amounts aligned with `token_path`. |
| `profit_in_tokens` | `NUMERIC(78,18)` | Profit in `token_path[0]` units. |
| `token_price_usd` | `NUMERIC(78,18)` | Price of `token_path[0]` in USD. |
| `profit_in_usd` | `NUMERIC(78,18)` | Profit in USD. |
| `_tracing_id` | `BYTEA` | Unique tracing ID. |
| `_parent_tracing_ids` | `BYTEA[]` | Parent tracing IDs. |
| `_created_at` | `TIMESTAMPTZ` | Record creation time. |
| `_updated_at` | `TIMESTAMPTZ` | Record last update time. |

### Notes

• Primary key (logical): (path_id, is_reversed, block_number, tx_index, log_index).

## Lineage

`_tracing_id` and `_parent_tracing_ids` link each opportunity to path, pricing, and reserve subgraphs.

## Common Use Cases

• Historical arbitrage P&amp;L distributions
• Strategy research with row-level auditability
See the [API endpoint reference](https://docs.blockdb.io/api-reference/evm/overview) for filter parameters, pagination, and WebSocket subscription options.

## Quality

• Verifiable lineage: deterministic cryptographic hashes per row
• Reorg-aware ingestion: continuity and consistency across forks
• Complete historical coverage: from chain genesis to present