Skip to main content
POST
/
v1
/
evm
/
entities
/
pools
curl -X POST "https://api.blockdb.io/v1/evm/entities/pools" \
  -H "Authorization: Bearer $BLOCKDB_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
  "chain_id": 1,
  "from_block": 12345678,
  "to_block": 12345999,
  "from_timestamp": "2025-10-29T00:00:00Z",
  "to_timestamp": "2025-11-11T00:00:00Z",
  "exchange_ids": [
    2,
    3
  ],
  "pool_type_ids": [
    201,
    302,
    3303
  ],
  "contract_address": "1234567890abcdef1234567890abcdef12345678"
}'

{
  "meta": {
    "chain_id": 1,
    "request_window": {
      "from_block": 12345678,
      "to_block": 12345999,
      "from_timestamp": "2025-10-29T00:00:00Z",
      "to_timestamp": "2025-11-11T00:00:00Z"
    },
    "resolved_window": {
      "from_block": 12345678,
      "to_block": 12345999,
      "from_timestamp": "2025-10-29T00:00:00Z",
      "to_timestamp": "2025-11-11T00:00:00Z"
    },
    "filters": {
      "contract_address": "1234567890abcdef1234567890abcdef12345678",
      "pool_uids": null,
      "exchange_ids": [
        1,
        2
      ],
      "pool_type_ids": [
        1,
        2,
        4
      ]
    }
  },
  "data": [
    {
      "pool_uid": "88e6a0c2ddd26feeb64f039a2c41296fcb3f5640000000000000000000000000",
      "exchange_id": 1,
      "type_id": 2,
      "block_number": 567890,
      "block_time": "2018-07-07T12:34:56.000Z",
      "tx_index": 4,
      "log_index": 2,
      "factory": "1f98431c8ad98523631ae4a59f267346ea31f984",
      "contract_id": "88e6a0c2ddd26feeb64f039a2c41296fcb3f564000000000000",
      "tokens": [
        "c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2",
        "a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48"
      ],
      "contract_address": "88e6a0c2ddd26feeb64f039a2c41296fcb3f5640",
      "pool_id": null,
      "pairnum": 42,
      "asset_managers": null,
      "amp": null,
      "weights": [
        0.5,
        0.5
      ],
      "tick_spacing": null,
      "_tracing_id": "0211000000000000000000000000000000000001",
      "_parent_tracing_ids": [
        "0103000000000000000000000000000000000001",
        "0103000000000000000000000000000000000002"
      ],
      "_created_at": "2025-11-11T18:42:15.123Z",
      "_updated_at": "2025-11-11T18:42:15.123Z"
    }
  ],
  "cursor": null,
  "page_count": 1
}

​
Overview

  • Dataset ID: 0211 - Liquidity Pools
  • Description: Canonical list of pools; child time-series tables FK to blockdb_evm.b0211_liquidity_pools_v1(pool_uid).
  • CSV Sample: Download
  • JSON Sample: Download

​
Parameters

​
chain_id
number
required
Target EVM network. See the Chain enumeration for supported values.

​
Range Filters (mutually exclusive)

​
from_block
number
Starting block number (inclusive) for the query. Use with to_block.
​
to_block
number
Ending block number (inclusive) for the query. Use with from_block.
​
from_timestamp
string
Starting timestamp (ISO-8601). If it falls between blocks, the next block after this timestamp is used. Use with to_timestamp.
​
to_timestamp
string
Ending timestamp (ISO-8601). If it falls between blocks, the last block before this timestamp is used. Use with from_timestamp.
Validation rule:
You must provide either a block range, a time range, or at least one direct selector.
Providing more than one option results in HTTP 400.
Providing none results in HTTP 400.

​
Pool Selectors

​
contract_address
string
Specific pool contract address to return (hex string, 20 bytes, no 0x prefix). May be used on its own, without a block or time range.
​
pool_uids
string[]
Internal BlockDB pool ids to return (each a 32-byte hex string, no 0x prefix). May be used on its own, without a block or time range.
​
exchange_ids
number[]
Filter snapshots by exchange IDs. See the DigitalExchange enumeration for supported values.
​
pool_type_ids
number[]
Filter pools by archetype. See the PoolType enumeration for supported values.

​
Response Fields

​
Meta

​
meta
object
Echo of request metadata applied to the response.
​
meta.chain_id
number
EVM chain ID echoed from the request.
​
meta.request_window
object
Pure echo of the window you sent (from_block/to_block/from_timestamp/to_timestamp); unset bounds are null.
​
meta.resolved_window
object | null
The concrete window the query actually executed against, after resolving the request. For a block range on a time-bucketed endpoint (OHLC/VWAP/VWAP-aggregate/fiat VWAP), from_timestamp/to_timestamp hold the resolved timestamp window (and from_block/to_block echo your request). For a time range on a block-keyed endpoint, from_block/to_block hold the resolved block range (and the timestamps echo your request). null for selector-only requests (no window). No extra database work is done — these are the values the query already computed.
​
meta.resolved_window.from_block
number | null
Resolved/echoed start block of the executed window.
​
meta.resolved_window.to_block
number | null
Resolved/echoed end block of the executed window.
​
meta.resolved_window.from_timestamp
string | null
Resolved/echoed start timestamp (ISO-8601) of the executed window.
​
meta.resolved_window.to_timestamp
string | null
Resolved/echoed end timestamp (ISO-8601) of the executed window.
​
meta.filters
object
Filter parameters echoed from the request.

​
Data

​
data
object[]
Array of pool objects. Each row matches the linked dataset.
​
data.pool_uid
string
Internal BlockDB pool id (32-byte hex string, no 0x prefix).
​
data.exchange_id
number
Exchange/DEX identifier. See the DigitalExchange enumeration for supported values.
​
data.type_id
number
Pool type identifier. See the PoolType enumeration for supported values.
​
data.block_number
number
Block number where the pool was first recognized.
​
data.block_time
string
Block time (ISO-8601).
​
data.tx_index
number
Zero-based transaction index within the block.
​
data.log_index
number
Zero-based log index within the transaction.
​
data.factory
string
Factory or pool-manager contract address (hex, 20 bytes, no 0x prefix).
​
data.tokens
string[]
Token contract addresses that compose the pool (each hex, 20 bytes, no 0x prefix).
​
data.contract_id
string | null
Incarnation ID for v2/v3 pools: 20B address + 4B creation block + 2B tx_index (hex-encoded). NULL for v4-style pools.
​
data.contract_address
string | null
On-chain pool contract address when applicable (hex, 20 bytes, no 0x prefix).
​
data.pool_id
string | null
Protocol-specific pool id when applicable (for example Uniswap V4), hex string without 0x.
​
data.pairnum
number | null
Ordinal for the pair within the exchange, when applicable.
​
data.asset_managers
string[] | null
Asset manager contract addresses for Balancer-style pools (hex strings), or null.
​
data.amp
number | null
Amplification parameter for stable pools, when applicable.
​
data.weights
number[] | null
Token weights for weighted pools, when applicable.
​
data.tick_spacing
number | null
Tick spacing for concentrated-liquidity pools, when applicable.
​
data._tracing_id
string
Row-level lineage hash (hex string, no 0x prefix).
​
data._parent_tracing_ids
string[]
Lineage references of immediate parents (hex strings).
​
data._created_at
string
Record creation timestamp (ISO-8601).
​
data._updated_at
string
Last update timestamp (ISO-8601).

​
Envelope Fields

​
cursor
string | null
Cursor token for pagination.
​
page_count
number
Number of records returned in data.
curl -X POST "https://api.blockdb.io/v1/evm/entities/pools" \
  -H "Authorization: Bearer $BLOCKDB_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
  "chain_id": 1,
  "from_block": 12345678,
  "to_block": 12345999,
  "from_timestamp": "2025-10-29T00:00:00Z",
  "to_timestamp": "2025-11-11T00:00:00Z",
  "exchange_ids": [
    2,
    3
  ],
  "pool_type_ids": [
    201,
    302,
    3303
  ],
  "contract_address": "1234567890abcdef1234567890abcdef12345678"
}'

{
  "meta": {
    "chain_id": 1,
    "request_window": {
      "from_block": 12345678,
      "to_block": 12345999,
      "from_timestamp": "2025-10-29T00:00:00Z",
      "to_timestamp": "2025-11-11T00:00:00Z"
    },
    "resolved_window": {
      "from_block": 12345678,
      "to_block": 12345999,
      "from_timestamp": "2025-10-29T00:00:00Z",
      "to_timestamp": "2025-11-11T00:00:00Z"
    },
    "filters": {
      "contract_address": "1234567890abcdef1234567890abcdef12345678",
      "pool_uids": null,
      "exchange_ids": [
        1,
        2
      ],
      "pool_type_ids": [
        1,
        2,
        4
      ]
    }
  },
  "data": [
    {
      "pool_uid": "88e6a0c2ddd26feeb64f039a2c41296fcb3f5640000000000000000000000000",
      "exchange_id": 1,
      "type_id": 2,
      "block_number": 567890,
      "block_time": "2018-07-07T12:34:56.000Z",
      "tx_index": 4,
      "log_index": 2,
      "factory": "1f98431c8ad98523631ae4a59f267346ea31f984",
      "contract_id": "88e6a0c2ddd26feeb64f039a2c41296fcb3f564000000000000",
      "tokens": [
        "c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2",
        "a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48"
      ],
      "contract_address": "88e6a0c2ddd26feeb64f039a2c41296fcb3f5640",
      "pool_id": null,
      "pairnum": 42,
      "asset_managers": null,
      "amp": null,
      "weights": [
        0.5,
        0.5
      ],
      "tick_spacing": null,
      "_tracing_id": "0211000000000000000000000000000000000001",
      "_parent_tracing_ids": [
        "0103000000000000000000000000000000000001",
        "0103000000000000000000000000000000000002"
      ],
      "_created_at": "2025-11-11T18:42:15.123Z",
      "_updated_at": "2025-11-11T18:42:15.123Z"
    }
  ],
  "cursor": null,
  "page_count": 1
}
Last modified on May 29, 2026