Overview
- Dataset ID:
0302 - Table:
blockdb0302_token_to_token_prices_swap_prints_v1 - Description: Executed swap prints (realized token_in → token_out price & sizes) per on-chain swap event. No liquidity/quotes.
This dataset captures the realized execution price from actual swap events, providing a direct view of what prices were achieved in practice. Unlike L1/L2/L3 pricing layers that model liquidity depth, swap prints represent historical execution outcomes with no forward-looking quotes.
Columns
| Column | Type | Description |
|---|---|---|
id | BIGINT | Surrogate identity for the swap print record (auto-incremented). |
pool_uid | BYTEA | Foreign key to blockdb0203_liquidity_pools_v1.uid, identifying the AMM pool where the swap occurred. |
block_number | BIGINT | Canonical block height where the swap event was observed. |
block_time | TIMESTAMPTZ | UTC timestamp of the originating block for easy temporal joins. |
tx_index | INTEGER | Zero-based transaction index inside the block; pairs with log_index to pinpoint provenance. |
log_index | INTEGER | Log index emitted by the swap event, ensuring uniqueness with tx_index and pool_uid. |
token_in | BYTEA | 20-byte address of the input token (direction of trade); decimals are normalized in price/size fields. |
token_out | BYTEA | 20-byte address of the output token for this direction of swap execution. |
amount_in | NUMERIC(78,18) | Amount of token_in executed in the swap (decimals-adjusted, direction-consistent). |
amount_out | NUMERIC(78,18) | Amount of token_out received in the swap (decimals-adjusted, direction-consistent). |
exec_price | NUMERIC(78,18) | Realized execution price: token_out per 1 token_in (decimals-adjusted). |
_tracing_id | BYTEA | Deterministic BlockDB lineage identifier for the swap print record. |
_genesis_tracing_ids | BYTEA[] | Tracing IDs for the raw artifacts (pool, block, event) that seeded this record. |
_parent_tracing_ids | BYTEA[] | Lineage references to derived upstream records used in computation (e.g., pool state snapshots). |
_created_at | TIMESTAMPTZ | Timestamp when BlockDB materialized the swap print. |
_updated_at | TIMESTAMPTZ | Last time the record was modified (usually on replay/backfill). |
Use Cases
- Execution price analysis: Analyze realized prices from actual swap executions to understand slippage and execution quality
- Historical price reconstruction: Build price time series from executed swaps without relying on liquidity models
- MEV and arbitrage detection: Identify price discrepancies by comparing swap prints across pools and chains
- Trade execution benchmarking: Compare actual execution prices against theoretical prices from depth curves
- Market microstructure research: Study price formation and execution patterns in AMM pools
- Backtesting strategies: Use historical swap prints to validate trading strategies with real execution data