Arbitrage Opportunities | EVM Blockchain Data

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

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.

Path topology and activation status.