Pool Liquidity Ohlc 1h
The optimism.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. |
| __last_modified | text |
The date at which this row was last updated (in ISO-8601 format). |
Indexes
| Index |
|---|
| timestamp |
| __last_modified |
| __indexer_id WHERE __confirmed = false |
| __indexer_id, __block_number |
| pool_address, timestamp |
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.