osmosis.defi Table: dim_liquidity_pools Type: View
Contains liquidity pool metadata for assets on the Osmosis blockchain. This table was sourced from
an API and may not contain every token.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | In this table, always Osmosis. Used to join to cross-chain tables. This column will deprecate in all tables except core.fact_blocks soon. Please modify your queries to join to the blocks table to use this field. |
| MODULE | TEXT | Module used to create liquidity pool |
| POOL_CREATED_BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block began. |
| POOL_CREATED_BLOCK_ID | NUMBER | The block height the block was recorded at. |
| POOL_ID | NUMBER | Identifier for the pool within the module |
| POOL_ADDRESS | TEXT | Address of the pool |
| ASSETS | ARRAY | List of 2 or more asset addresses belonging to the pool |
| DIM_LIQUIDITY_POOLS_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |