Token Prices
The optimism.token_prices table provides indexed views for cleaned token prices in USD at every point in time when a token was seen in a DEX swap. For tokens that are swapped multiple times in a single block, a per-block VWAP is taken to determine the fair price.
Columns
| Name | Type | Description |
|---|---|---|
| block_number | integer |
The block number at which the DEX swap occurred for pricing the token. |
| price | numeric |
The price of the token in USD. |
| timestamp | timestamp without time zone |
The timestamp of the DEX swap (in ISO-8601 format). |
| token_address | text |
The address of the token that is priced in USD. |
| token_symbol | text |
The symbol of the token that is priced in USD. |
| __block_number | integer |
The last block number in the batch that the data was updated in. |
| __confirmed | boolean |
Flag indicating whether the transfer has been confirmed. |
| __last_modified | timestamp |
The date at which this row was last updated (in ISO-8601 format). |
Indexes
| Index |
|---|
| timestamp |
| block_number |
| token_address, timestamp |
| __last_modified |
| __indexer_id WHERE __confirmed = false |
| __indexer_id, __block_number |
| token_address, 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.