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