Skip to main content
Schema: crosschain.defi Table: dim_dex_liquidity_pools Type: View

What

A comprehensive dim table holding blockchain and platform specific decentralized exchange pools.

Columns

Column NameData TypeDescription
BLOCKCHAINTEXTBlockchain, Network, or Platform the token price is recorded on.
PLATFORMTEXTThe name of the platform that the liquidity pool belongs to or swap occurred on, typically a concatenation of the protocol and version.
PROTOCOLTEXTThe name of the protocol.
PROTOCOL_VERSIONTEXTThe version of the protocol.
CREATION_BLOCKNUMBERThe block number of when this pool was created.
CREATION_TIMETIMESTAMP_NTZThe block timestamp of when this pool was created.
CREATION_TXTEXTThe transaction where this contract was created.
FACTORY_ADDRESSTEXTFACTORY_ADDRESS column
POOL_ADDRESSTEXTThe contract address for the liquidity pool.
POOL_NAMETEXTThe name of the liquidity pool, where available. In some cases, the pool name is a concatenation of symbols or token addresses.
TOKENSOBJECTThe address for the token included in the liquidity pool, as a JSON object
SYMBOLSOBJECTThe symbol for the token included in the liquidity pool, as a JSON object, where available.
DECIMALSOBJECTThe number of decimals for the token included in the liquidity pool, as a JSON object, where available.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.
DIM_DEX_LIQUIDITY_POOLS_IDTEXTThe unique identifier for each row in the table.