Token Liquidity Ohlc 1d
The optimism.token_liquidity_ohlc_1d table provides 1-day OHLC (open, high, low, close) liquidity bars in USD for all tokens across all DEX pools.
Columns
| Name | Type | Description |
|---|---|---|
| average_liquidity | decimal |
The mean liquidity of the token in USD in the window. |
| close_liquidity | decimal |
The close liquidity of the token in USD for the window. |
| high_liquidity | decimal |
The maximum liquidity of the token in USD in the window. |
| low_liquidity | decimal |
The minimum liquidity of the token in USD in the window. |
| open_liquidity | decimal |
The open liquidity of the token in USD for the window. |
| timestamp | timestamp |
The timestamp of the OHLC bar (in ISO-8601 format). |
| token_address | address |
The address of the token. |
| __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 |
|---|
| __last_modified |
| __indexer_id WHERE __confirmed = false |
| __indexer_id, __block_number |
| token_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.