> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Liquidity Pools

### Table Details

| Property            | Value                                                        |
| ------------------- | ------------------------------------------------------------ |
| Table Name          | `casper.dex.liquidity_pools`                                 |
| Table Status        | Production-Ready                                             |
| Search Optimization | `liquidity_pool_address`, `token0_address`, `token1_address` |

### Table Columns

| Column Name              | Data Type         | Description                                                     |
| ------------------------ | ----------------- | --------------------------------------------------------------- |
| project                  | VARCHAR(16777216) | Name of the DEX protocol's project (e.g., Casperswap).          |
| protocol                 | VARCHAR(16777216) | Specific protocol variant or version identifier.                |
| liquidity\_pool\_address | VARCHAR(16777216) | Address of the liquidity pool contract.                         |
| factory\_address         | VARCHAR(16777216) | Address of the factory contract that created the pool.          |
| token0\_address          | VARCHAR(16777216) | Address of token0 (the first token in the pool by sort order).  |
| token0\_name             | VARCHAR(16777216) | Human-readable name of token0.                                  |
| token0\_symbol           | VARCHAR(16777216) | Ticker symbol of token0.                                        |
| token0\_decimals         | NUMBER(38,0)      | Decimals of token0.                                             |
| token1\_address          | VARCHAR(16777216) | Address of token1 (the second token in the pool by sort order). |
| token1\_name             | VARCHAR(16777216) | Human-readable name of token1.                                  |
| token1\_symbol           | VARCHAR(16777216) | Ticker symbol of token1.                                        |
| token1\_decimals         | NUMBER(38,0)      | Decimals of token1.                                             |
| pool\_name               | VARCHAR(16777216) | Human-readable pool identifier (e.g., "CSPR-USDC").             |
| transaction\_hash        | VARCHAR(16777216) | Hash of the transaction that created the pool.                  |
| block\_timestamp         | TIMESTAMP\_NTZ(9) | Timestamp of the block this event was included in.              |
| block\_number            | NUMBER(38,0)      | Height of the block this event was included in.                 |
| block\_hash              | VARCHAR(16777216) | Hash of the block this event was included in.                   |
| \_created\_at            | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.        |
| \_updated\_at            | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.   |