> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blockdb.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Arbitrage Opportunities

> Estimated arbitrage profit and token amounts per path at a given on-chain position.

## Overview

* **Dataset ID:** `0901`
* **Table:** `blockdb_evm.b0901_arb_opportunities_v1`
* **Description:** Opportunities computed for active paths at a specific `(block_number, tx_index, log_index)`.
* **Primary key:** `(path_id, is_reversed, block_number, tx_index, log_index)`
* **API:** [POST /evm/arb/opportunities](/api-reference/evm/arbitrage/arb-opportunities)
* **CSV Sample:** [Download](https://huggingface.co/datasets/BlockDB/MEV-Arbitrage-Opportunities-Ethereum-And-EVM-Cryptocurrency-Data/resolve/main/data/blockdb_evm.b0901_arb_opportunities_v1.csv?download=true)
* **JSON Sample:** [Download](https://huggingface.co/datasets/BlockDB/MEV-Arbitrage-Opportunities-Ethereum-And-EVM-Cryptocurrency-Data/resolve/main/data/blockdb_evm.b0901_arb_opportunities_v1.json?download=true)

## Sample Viewer

<Frame>
  <iframe src="https://huggingface.co/datasets/BlockDB/MEV-Arbitrage-Opportunities-Ethereum-And-EVM-Cryptocurrency-Data/embed/viewer/default/train" frameborder="0" width="100%" height="600px" />
</Frame>

## Columns

| 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_vwap_usd`      | `NUMERIC(78,18)`   | Token-to-Fiat VWAP USD of token\_path\[0]. |
| `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.                   |

## Related datasets

<Card title="Arbitrage paths" icon="route" href="/data-catalog/evm/arbitrage/arb-paths">
  Path topology and activation status.
</Card>