Skip to main content

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.
ColumnTypeDescription
chain_idBIGINTEVM chain identifier; see Chain.
path_idBYTEA32B hash identifying the undirected path (cycle).
block_numberBIGINTBlock when path first observed.
block_timeTIMESTAMPTZBlock time.
tx_indexINTEGERTransaction index.
log_indexINTEGERLog index.
pool_uidsBYTEA[]Pool UIDs in canonical cycle order.
token_cycleBYTEA[]Token cycle (e.g. A,B,A or A,B,C,A) in canonical order.
_tracing_idBYTEAUnique tracing ID.
_parent_tracing_idsBYTEA[]Parent tracing IDs.
_created_atTIMESTAMPTZRecord creation time.
_updated_atTIMESTAMPTZRecord last update time.

Arbitrage path status (blockdb_evm.b0701_arb_path_status_v1)

Primary key: (path_id, block_number, tx_index, log_index).
ColumnTypeDescription
chain_idBIGINTEVM chain identifier; see Chain.
path_idBYTEAFK to b0701_arb_paths_v1.path_id.
block_numberBIGINTEvent block.
block_timeTIMESTAMPTZBlock time.
tx_indexINTEGERTransaction index.
log_indexINTEGERLog index.
is_activeBOOLEANPath active flag.
trigger_pool_uidBYTEAPool whose change triggered the status event.
_tracing_idBYTEAUnique tracing ID.
_parent_tracing_idsBYTEA[]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