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
- CSV Sample: Download
- JSON Sample: Download
Sample Viewer
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
Arbitrage paths
Path topology and activation status.