pool_uid | BYTEA | Stable surrogate key derived from address or pool_id (used across datasets). |
exchange_id | INTEGER | Exchange identifier (e.g., 1 for Uniswap, 2 for Sushiswap, etc.). |
type_id | INTEGER | Pool type identifier (e.g. 201 for Uniswap V2, 301 for Uniswap V3). |
block_number | BIGINT | Block number where pool was first recognized/derived. |
block_time | TIMESTAMPTZ | UTC timestamp for the block that produced this record. |
tx_index | INTEGER | Zero-based transaction index within the block. |
log_index | INTEGER | Zero-based log index within the transaction. |
factory | BYTEA | Factory/pool-manager contract address. |
tokens | BYTEA[] | Array of token addresses that compose the pool, ordered as stored on-chain. |
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). |
pairnum | NUMERIC(6) | Internal index representing the slot/order of the token pair within the pool. |
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 for concentrated liquidity pools. |
_tracing_id | BYTEA | BlockDB lineage identifier that links this record to lineage APIs. |
_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. |
