Table Details
| Property | Value |
|---|---|
| Table Name | unichain_sepolia.dex.pools |
| Table Status | Beta 🌱 |
| 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 |
| 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) | The contract address of the factory that created the liquidity pool |