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.