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

---
license: cc-by-nc-4.0
tags:
- ethereum
- evm
- blockchain
- cryptocurrency
- crypto
- onchain-data
- defi
- arbitrage
- tabular
- datasets
- pandas
- polars
- duckdb
pretty_name: BlockDB Arbitrage Paths - 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 Paths 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

## Dataset Overview

Undirected arbitrage cycle definitions: each `path_id` is a 32-byte hash; `pool_uids` and `token_cycle` are stored in canonical order with first-observation block coordinates.
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 |
| --- | --- | --- |
| `path_id` | `BYTEA` | 32B hash identifying the undirected path (cycle). |
| `block_number` | `BIGINT` | Block when path first observed. |
| `block_time` | `TIMESTAMPTZ` | Block time. |
| `tx_index` | `INTEGER` | Transaction index. |
| `log_index` | `INTEGER` | Log index. |
| `pool_uids` | `BYTEA[]` | Pool UIDs in canonical cycle order. |
| `token_cycle` | `BYTEA[]` | Token cycle (e.g. A,B,A or A,B,C,A) in canonical order. |
| `_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: path_id.
• Pairs with dataset **0702** (path status) and **0801** (opportunities).

## Lineage

`_tracing_id` and `_parent_tracing_ids` connect path definitions to detection and reserve subgraphs.

## Common Use Cases

• Cycle enumeration and graph analytics on DEX liquidity
• Path lifecycle research (discovery → status → opportunities)
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