> ## 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.

# Pools

The `dex.pools` table contains liquidity pools of DEX protocols indexed by Allium, consolidated into a single table.

### Table Details

| Property     | Value                                                                                                                                            |
| ------------ | ------------------------------------------------------------------------------------------------------------------------------------------------ |
| Table Name   | `hyperevm.dex.pools`                                                                                                                             |
| Table Status | Production-Ready                                                                                                                                 |
| Unique Key   | `coalesce(transaction_hash,'null')`, `coalesce(log_index,-1)`, `liquidity_pool_address`, `coalesce(project,'null')`, `coalesce(protocol,'null')` |

### Table Columns

| Column Name                       | Data Type         | Description                                                                                                                                |
| --------------------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------ |
| project                           | VARCHAR(16777216) | The project or platform name                                                                                                               |
| protocol                          | VARCHAR(16777216) | The specific protocol or version used                                                                                                      |
| liquidity\_pool\_address          | VARCHAR(42)       | The address of the liquidity pool                                                                                                          |
| pool\_id                          | VARCHAR(16777216) | (Nullable) Pool ID of the liquidity pool. Only applicable for pools where there is the concept of a pool ID (e.g., UniswapV4, BalancerV3). |
| token0\_address                   | VARCHAR(42)       | The address of the first token in the pair                                                                                                 |
| token0\_name                      | VARCHAR(16777216) | The name of the first token                                                                                                                |
| token0\_symbol                    | VARCHAR(16777216) | The symbol of the first token                                                                                                              |
| token0\_decimals                  | NUMBER(38,0)      | The number of decimal places for the first token                                                                                           |
| token1\_address                   | VARCHAR(42)       | The address of the second token in the pair                                                                                                |
| token1\_name                      | VARCHAR(16777216) | The name of the second token                                                                                                               |
| token1\_symbol                    | VARCHAR(16777216) | The symbol of the second token                                                                                                             |
| token1\_decimals                  | NUMBER(38,0)      | The number of decimal places for the second token                                                                                          |
| tokens\_array                     | VARIANT           | An array containing the addresses of all tokens for pools with more than two tokens                                                        |
| fee                               | NUMBER(38,0)      | The fee associated with the pool                                                                                                           |
| tick\_spacing                     | VARCHAR(16777216) | The spacing between ticks in the pool                                                                                                      |
| factory\_address                  | VARCHAR(42)       | The address of the factory contract that created the pool                                                                                  |
| extra\_fields                     | VARIANT           | Additional fields emitted in pool creation in JSON format                                                                                  |
| transaction\_hash                 | VARCHAR(66)       | The hash of the transaction (\*null for seed pools)                                                                                        |
| transaction\_index                | NUMBER(38,0)      | The index of the transaction within the block (\*null for seed pools)                                                                      |
| log\_index                        | NUMBER(38,0)      | The index of the log entry within the transaction (\*null for seed pools)                                                                  |
| trace\_id                         | VARCHAR(16777216) | The ID of the trace (if applicable)                                                                                                        |
| block\_timestamp                  | TIMESTAMP\_NTZ(9) | The timestamp of the block                                                                                                                 |
| block\_number                     | NUMBER(38,0)      | The number of the block                                                                                                                    |
| block\_hash                       | VARCHAR(66)       | The hash of the block                                                                                                                      |
| \_created\_at                     | TIMESTAMP\_NTZ(9) | Timestamp when the record was created                                                                                                      |
| \_updated\_at                     | TIMESTAMP\_NTZ(9) | Timestamp when the record was last updated                                                                                                 |
| liquidity\_pool\_factory\_address | VARCHAR(42)       | Address of the liquidity pool factory contract.                                                                                            |

### Related Docs

* [EVM DEX Pools](/historical-data/supported-blockchains/evm/core-schemas/dex/pools)