Skip to main content
Schema: monad.defi Table: dim_dex_liquidity_pools Type: Dimension Table

​
What

This dimensional table contains comprehensive metadata for all DEX liquidity pools across supported protocols. It provides essential information about pool composition, token pairs, and configuration needed for analyzing liquidity provision and pool performance.

​
Key Use Cases

  • Finding

​
Columns

Column NameData TypeDescription
CREATION_BLOCKNUMBERThe block number when the liquidity pool was first create…
CREATION_TIMETIMESTAMP_NTZThe timestamp when the liquidity pool was deployed.
Exam… | | CREATION_TX | TEXT | The transaction hash that deployed this liquidity pool. … | | DECIMALS | TEXT | JSON object containing decimal places for each token in t… | | DIM_DEX_LIQUIDITY_POOLS_ID | TEXT | Primary key - unique identifier for each row ensuring dat… | | FACTORY_ADDRESS | TEXT | The factory contract that deployed this liquidity pool. … | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the record was first added to the Flip… | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp of the most recent update to this record. … | | PLATFORM | TEXT | The DEX protocol where the swap occurred. Example: ‘unis… | | POOL_ADDRESS | TEXT | The liquidity pool contract address where the swap execut… | | POOL_NAME | TEXT | Human-readable name for the liquidity pool. Example: ‘WE… | | SYMBOLS | TEXT | JSON object containing token symbols for the pool pair. … | | TOKENS | TEXT | JSON object containing token contract addresses in the po… |