> ## 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 | `avalanche_fuji.dex.pools` |
| Table Status | Production-Ready |
| Unique Key | `unique_id` |

### 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 |
| liquidity\_pool\_factory\_address | VARCHAR(42) | Address of the liquidity pool factory contract. |
| unique\_id | VARCHAR(16777216) | Allium's deterministic unique identifier for this row. Generated from the fields that uniquely identify the record. Stable across full refreshes. |
| content\_hash | VARCHAR(32) | Hash of this pool row's identifying attributes, used to detect changes between versions. |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp when the record was created |
| \_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp when the record was last updated |

### Related Docs

* [EVM DEX Pools](https://docs.allium.so/historical-data/supported-blockchains/evm/core-schemas/dex/pools.md)
