Overview
- Dataset ID:
0301 - Tables:
blockdb_evm.b0301_liquidity_pools_reserves_v1— One row per pool per on-chain observation event.blockdb_evm.b0301_liquidity_pools_reserves_details_v1— Granular tick/bin/range rows for a snapshot; joinsnapshot_idto parent_tracing_id.
- API: POST /evm/reserves
Snapshot columns (blockdb_evm.b0301_liquidity_pools_reserves_v1)
Primary key: (pool_uid, block_number, tx_index, log_index).
| Column | Type | Description |
|---|---|---|
chain_id | BIGINT | EVM chain identifier; see Chain. |
pool_uid | BYTEA | Pool surrogate key; FK → b0211_liquidity_pools_v1.pool_uid. |
exchange_id | INTEGER | Exchange identifier. |
type_id | INTEGER | Liquidity pool type identifier. |
block_number | BIGINT | Block when this state was observed. |
block_time | TIMESTAMPTZ | Block time. |
tx_index | INTEGER | Transaction index within the block. |
log_index | INTEGER | Log index within the transaction. |
reserves | NUMERIC(78,0)[] | Current reserves per token for even-style pools (raw units). |
current_tick | INTEGER | Current tick (concentrated liquidity, e.g. Uniswap v3). |
current_sqrt_price | NUMERIC(49,0) | Q64.96 sqrt price integer. |
current_bin | INTEGER | Current bin id for bin-style AMMs. |
_tracing_id | BYTEA | BlockDB tracing ID; unique. |
_parent_tracing_ids | BYTEA[] | Parent tracing IDs. |
_created_at | TIMESTAMPTZ | Record creation time. |
_updated_at | TIMESTAMPTZ | Record last update time. |
CHECK (ck_b0301_reserves_has_payload) requires at least one of: reserves, current_tick, current_bin, or (per DDL) liquidity_values, amounts0 when those columns exist in your deployed schema. The shipped DDL file references liquidity_values / amounts0 in the payload check; confirm deployed columns match your environment.
Details columns (blockdb_evm.b0301_liquidity_pools_reserves_details_v1)
Join: details.snapshot_id = reserves._tracing_id.
| Column | Type | Description |
|---|---|---|
chain_id | BIGINT | EVM chain identifier; see Chain. |
snapshot_id | BYTEA | Parent snapshot _tracing_id. |
tick | INTEGER | Single-tick locator (v3-style). |
lower_tick | INTEGER | Range lower bound. |
upper_tick | INTEGER | Range upper bound. |
bin_id | INTEGER | Single-bin locator. |
liquidity | NUMERIC(38,0) | Engine-native liquidity (e.g. Uniswap v3 (L)). |
amount0 | NUMERIC(78,0) | Token0 amount at locator (decimals-adjusted). |
amount1 | NUMERIC(78,0) | Token1 amount at locator (decimals-adjusted). |
(snapshot_id, tick), per (snapshot_id, bin_id), or per (snapshot_id, lower_tick, upper_tick) range.
Use cases
- Pool state backtesting and simulation
- Liquidity distribution analysis (ticks/bins)
- TVL and pricing model inputs
Related datasets
Liquidity pools
Pool registry keyed by
pool_uid.Swap fees
Per-swap economics tied to the same pool events.