Skip to content

Token Prices Ohlc 1m

The base.token_prices_ohlc_1m table provides historical and live OHLC (open, high, low, close) prices in USD for all tokens on Ethereum per minute, including average price and total DEX volume.

Columns

Name Type Description
average_price decimal The mean price of the token in USD in the window.
close_price decimal The close price of the token in USD for the window.
high_price decimal The maximum price of the token in USD in the window.
low_price decimal The minimum price of the token in USD in the window.
open_price decimal The open price 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 that is priced in USD.
token_symbol text The symbol of the token that is priced in USD.
volume decimal The total volume of the token in the window (normalized by token decimals).
__block_number integer The last block number in the batch that the data was updated in.
__confirmed boolean Flag indicating whether the token prices 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.