Pools
The base.dex.pools table contains pool creation events across various indexed protocols for uniswap v2 and v3 liquidity pools.
Table Columns
| Column Name | Description | Example |
|---|---|---|
protocol | Version of the protocol. | uniswap_v2 |
project | Name of the project. | pancakeswap |
liquidity_pool_factory_address | Address of the liquidity pool factory. | 0x02a84c1b3bbd7401a5f7fa98a384ebc70bb5749e |
liquidity_pool_address | Address of the liquidity pool. | 0x59943ef5242a271e7993658a11399f127b1785be |
token0_address | Address of token0 in this LP. | 0x4200000000000000000000000000000000000006 |
token0_symbol | Symbol of token0 in this LP. | WETH |
token0_decimals | Decimals of token0 in this LP. | 18 |
token1_address | Address of token1 in this LP. | 0x4b678d9ab356ec999ce996c1c9971026db0fa2d2 |
token1_symbol | Symbol of token1 in this LP. | |
token1_decimals | Decimals of token1 in this LP. | nan |
fee | The fee collected upon every swap in the pool, denominated in hundredths of a bip. | 3000 |
tick_spacing | The spacing between usable ticks. | |
transaction_hash | Transaction hash the pool creation. | 0xa7f118b9aa9d6f6ff2435f17433c8d65fc164ce37116097c2687231d66b15655 |
log_index | Log index of the transaction. | 4 |
block_timestamp | Block timestamp of the pool creation. | 2023-09-29 15:13:13+00:00 |
block_number | Block number of the pool creation. | 4605523 |
block_hash | Block hash of the pool creation. | 0x22357d0dc488372075d07df24a1c0fbc4d4c909812f2647605a75a6b597494bd |
Last updated