Flipside Docs
Search
K

Pools

uniswapv3.pools
Pool records are appended to this table whenever a PoolCreated event is emitted by the UniswapV3 Factory Contract.
Field
Type
Description
block_id
number
The block number that this Pool record was created at
block_timestamp
timestamp
The block timestamp that this Pool record was created at
tx_id
text
The transaction that this Pool was created at
blockchain
text
The blockchain this Pool was created on (Ethereum, will support L2s here shortly)
factory_address
address
The address of the UniswapV3 factory that initialized this Pool
fee_percent
number
The fee expressed as a decimal percentage
init_price_1_0
number
The initial price of the Pool (converted from sqrtPriceX96)
init_tick
number
The initial tick of the Pool
pool_address
address
The address of the Pool
pool_name
text
The name of the Pool (format = "token0-token1 fee tick_spacing")
tick_spacing
number
The minimum number of ticks allowed between each tick.
token0_address
address
The contract address of token0
token0_decimals
number
The number of decimals for token0 (used for decimal adjustments)
token0_name
text
The name of token0
token0_symbol
text
The symbol of token0
token1_address
address
The contract address of token1
token1_decimals
number
The number of decimals for token1 (used for decimal adjustments)
token1_name
text
The name of token1
token1_symbol
text
The symbol of token1