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

### Table Details

| Property | Value |
| - | - |
| Table Name | `stellar.dex.pools` |
| Table Status | Production-Ready |
| Unique Key | `transaction_hash`, `unique_id` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| project | VARCHAR(16777216) | Project slug of the DEX that owns the pool: `aquarius` or `aqua_router` (Aquarius), `soroswap`, `phoenix` or `sushiswap`. |
| protocol | VARCHAR(16777216) | Protocol identifier that qualifies the project: `aquarius`, `soroswap`, `phoenix` or `sushiswap_v3`. |
| date\_added | TIMESTAMP\_NTZ(9) | Date the factory/protocol contract was registered as a pool source. |
| contract\_id | VARCHAR(16777216) | Factory/router contract that emitted the pool creation event. For Phoenix, the factory contract whose diagnostic event the pool was discovered from. |
| liquidity\_pool\_address | VARCHAR(16777216) | Contract address of the liquidity pool. |
| token0\_contract\_id | VARCHAR(16777216) | Contract id of the pool's first token. Null for Phoenix pools. |
| token1\_contract\_id | VARCHAR(16777216) | Contract id of the pool's second token. Null for Phoenix pools. |
| fee\_bps | VARCHAR(16777216) | Pool swap fee as emitted at pool creation, stored as a string. Units differ by protocol: Aquarius reports basis points from its `add_pool` event, while SushiSwap V3 holds the raw fee tier from its `pool_created` event, not converted to basis points. Null for Soroswap and Phoenix. |
| event\_type | VARCHAR(16777216) | Type of the event that created the pool. For Phoenix, the type of the most recent factory diagnostic event that references the pool. Null for SushiSwap V3 pools. |
| event\_index | NUMBER(38,0) | Index of the creation event within its transaction. Null for SushiSwap V3 pools. |
| extension | VARCHAR(16777216) | XDR extension data on the creation event, used for forward-compatible changes. Null for SushiSwap V3 pools. |
| ledger\_sequence | NUMBER(38,0) | Sequence number of the Stellar ledger containing the pool creation event. |
| ledger\_close\_time | TIMESTAMP\_NTZ(9) | Timestamp (UTC) when the Stellar ledger containing the pool creation event closed and was validated by the network. |
| ledger\_hash | VARCHAR(16777216) | Hash of the Stellar ledger containing the pool creation event. |
| transaction\_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| transaction\_index | NUMBER(38,0) | Position of the transaction within its ledger. |
| transaction\_result | VARCHAR(16777216) | Stellar transaction result code. |
| transaction\_successful | VARCHAR(16777216) | Whether the creation transaction succeeded. Null for SushiSwap V3 pools. |
| unique\_id | VARCHAR(16777216) | Unique identifier of the pool creation event, carried over from the Stellar raw events tables. Null for SushiSwap V3 pools. |
| \_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. |