Skip to content

Pool Liquidity Ohlc 1h

The arbitrum.pool_liquidity_ohlc_1h table provides 1-hour OHLC (open, high, low, close) liquidity bars in USD for all pools across all DEXs.

Columns

Name Type Description
average_liquidity decimal The mean liquidity of the pool in USD in the window.
close_liquidity decimal The close liquidity of the pool in USD for the window.
high_liquidity decimal The maximum liquidity of the pool in USD in the window.
low_liquidity decimal The minimum liquidity of the pool in USD in the window.
open_liquidity decimal The open liquidity of the pool in USD for the window.
pool_address address The address of the liquidity pool.
timestamp timestamp The timestamp of the OHLC bar (in ISO-8601 format).
__block_number integer The last block number in the batch that the data was updated in.
__confirmed boolean Flag indicating whether the liquidity data on all pools have been confirmed.

Indexes

Index
pool_address, timestamp
__indexer_id, __block_number
__indexer_id WHERE __confirmed = false

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.