Skip to content

Token Prices Ohlc 1h

The ethereum.token_prices_ohlc_1h table provides historical and live OHLC (open, high, low, close) prices in USD for all tokens on Ethereum per hour, 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 block number at which the event took place in.
__confirmed boolean Flag indicating whether the token prices have been confirmed.
__last_modified timestamp The date at which this row was last updated (in ISO-8601 format).

Indexes

Index
token_address, timestamp
__last_modified
__indexer_id WHERE __confirmed = false
__indexer_id, __block_number

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.