uid | BIGINT | Stable surrogate identifier for each liquidity pool (used across datasets). |
block_number | BIGINT | Canonical block height within the originating chain. |
block_time | TIMESTAMPTZ | UTC timestamp for the block that produced this record. |
tx_index | INTEGER | Zero-based transaction index within the block, used for deterministic ordering. |
log_index | INTEGER | Zero-based log index within the transaction, uniquely identifying the emitted event. |
contract_address | BYTEA | 20B address for v2/v3-style pools (nullable for id-only v4). |
pool_id | BYTEA | 32B identifier for v4-style pools (nullable for v2/v3). |
factory | BYTEA | Address of the factory contract that deployed the pool. |
type_id | INTEGER | Foreign key into blockdb0002_liquidity_pools_types_v1 describing the pool class. |
pairnum | NUMERIC(6) | Internal index representing the slot/order of the token pair within the pool. |
tokens | BYTEA[] | Array of token addresses that compose the pool, ordered as stored on-chain. |
asset_managers | BYTEA[] | Optional array of asset manager addresses for Balancer-style custodial pools. |
amp | NUMERIC(6) | Amplification coefficient for stable or hybrid pools (NULL for constant product pools). |
weights | NUMERIC(6,5)[] | Array of normalized token weights for weighted pools (e.g., Balancer). |
tick_spacing | SMALLINT | Tick spacing parameter controlling price granularity for concentrated liquidity pools. |
_tracing_id | BYTEA | BlockDB lineage identifier that links this record to lineage APIs. |
_genesis_tracing_ids | BYTEA[] | Tracing identifiers for the raw artifacts (blocks, logs, proofs) that seeded this record. |
_parent_tracing_ids | BYTEA[] | Tracing identifiers for upstream derived records referenced during computation. |
_created_at | TIMESTAMPTZ | Record creation timestamp. |
_updated_at | TIMESTAMPTZ | Record last update timestamp. |
