Skip to main content
Schema: blast.defi Table: dim_dex_liquidity_pools Type: View This table contains details on decentralized exchange (DEX) liquidity pools (LP) on the base blockchain, including the tokens, symbols and decimals within each pool alongside the following protocols: BLADESWAP, BLASTERSWAP, FENIX, RING, SUSHI, and THRUSTER.

​
Columns

Column NameData TypeDescription
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.
PLATFORMTEXTThe protocol or platform that the liquidity pool belongs to or swap occurred on.
FACTORY_ADDRESSTEXTThe address that created or deployed this pool, where available.
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.
Query example to access the key:value pairing within the object: SELECT DISTINCT pool_address AS unique_pools, tokens :token0 :: STRING AS token0, symbols: token0 :: STRING AS token0_symbol, decimals: token0 :: STRING AS token0_decimal FROM blast.defi.dim_dex_liquidity_pools WHERE token0 = ‘0x4200000000000000000000000000000000000006’ ; | | SYMBOLS | OBJECT | The symbol for the token included in the liquidity pool, as a JSON object, where available. Query example to access the key:value pairing within the object: SELECT DISTINCT pool_address AS unique_pools, tokens :token0 :: STRING AS token0, symbols: token0 :: STRING AS token0_symbol, decimals: token0 :: STRING AS token0_decimal FROM blast.defi.dim_dex_liquidity_pools WHERE token0_symbol = ‘WETH’ ; | | DECIMALS | OBJECT | The # of decimals for the token included in the liquidity pool, as a JSON object, where available. Query example to access the key:value pairing within the object: SELECT DISTINCT pool_address AS unique_pools, tokens :token0 :: STRING AS token0, symbols: token0 :: STRING AS token0_symbol, decimals: token0 :: STRING AS token0_decimal FROM blast.defi.dim_dex_liquidity_pools WHERE token0_decimal = 6 ; | | DIM_DEX_LIQUIDITY_POOLS_ID | TEXT | The unique identifier for each row in the table. | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |