Skip to content

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.