Flipside Docs
Search…
⌃K

Pool Stats

uniswapv3.pool_stats
Statistics for each pool, appened each time a transaction triggers a Pool Event (i.e. 'Initialize', 'Mint', 'Collect', 'Burn', 'Swap', 'Flash', 'IncreaseObservationCardinalityNext', 'SetFeeProtocol', 'CollectProtocol', etc.).
A new record is appended each time this occurs. These stats are read from the Pool contract state leveraging Flipside's fully archival Ethereum cluster.
Field
Type
Description
block_id
number
The block number at which stats computed/read.
block_timestamp
timestamp
The block timestamp at which stats were computed/read.
blockchain
string
The blockchain this pool was created on (Ethereum, will support L2s here shortly)
pool_address
address
The contract address of the pool
pool_name
string
The name of the pool
price_0_1
number
The price of token 0 in terms of token 1
price_1_0
number
The price of token 1 in terms of token 0
tick
number
The tick of the pool according to the last tick transitions that was run
protocol_fees_token_0_adjusted
number
The amount of token0 owed to the protocol, decimal adjusted
protocol_fees_token_1_adjusted
number
The amount of token1 owed to the protocol, decimal adjusted
token0_address
address
The contract address of token0
token1_address
address
The contract address of token1
token0_symbol
text
The symbol of token0
token1_symbol
text
The symbol of token1
token_0_balance
number
The balance of token0 locked in the pool contract as of this block
token_1_balance
number
The balance of token1 locked in the pool contract as of this block
token_0_balance_adjusted
number
The balance of token0 locked in the pool contract as of this block, decimal adjusted
token_1_balance_adjusted
number
The balance of token1 locked in the pool contract as of this block, decimal adjusted
unlocked
boolean
Whether the pool is currently locked to reentrancy
virtual_liquidity_adjusted
number
The virtual liquidity of the pool
virtual_reserves_token0_adjusted
number
The virtual reserves of token0, decimal adjusted, in the pool
virtual_reserves_token1_adjusted
number
The virtual reserves of token1, decimal adjusted, in the pool.
virtual_reserves_token0_usd
number
The virtual reserves of token0, converted to USD.
virtual_reserves_token1_usd
number
The virtual reserves of token1 converted to USD.
fee_growth_global0_x128
number
The fee growth as a Q128.128 fees of token0 collected per unit of liquidity for the entire life of the pool
fee_growth_global1_x128
number
The fee growth as a Q128.128 fees of token1 collected per unit of liquidity for the entire life of the pool
Last modified 1yr ago