Overview
Definitions and status for undirected arbitrage cycles. Both tables are created from b0701_arb_paths_v1.sql.
Arbitrage paths (blockdb_evm.b0701_arb_paths_v1)
Primary key: path_id.
| Column | Type | Description |
|---|
chain_id | BIGINT | EVM chain identifier; see Chain. |
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. |
Arbitrage path status (blockdb_evm.b0701_arb_path_status_v1)
Primary key: (path_id, block_number, tx_index, log_index).
| Column | Type | Description |
|---|
chain_id | BIGINT | EVM chain identifier; see Chain. |
path_id | BYTEA | FK to b0701_arb_paths_v1.path_id. |
block_number | BIGINT | Event block. |
block_time | TIMESTAMPTZ | Block time. |
tx_index | INTEGER | Transaction index. |
log_index | INTEGER | Log index. |
is_active | BOOLEAN | Path active flag. |
trigger_pool_uid | BYTEA | Pool whose change triggered the status event. |
_tracing_id | BYTEA | Unique tracing ID. |
_parent_tracing_ids | BYTEA[] | Parent tracing IDs. |
No _created_at / _updated_at columns on this table in the published DDL.
Arbitrage opportunities
Profit estimates per path and on-chain position.
Last modified on March 21, 2026