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.
||The block number at which the DEX swap occurred for pricing the token.|
||The price of the token in USD.|
||The timestamp of the DEX swap (in ISO-8601 format).|
||The address of the token that is priced in USD.|
||The symbol of the token that is priced in USD.|
||The last block number in the batch that the data was updated in.|
||Flag indicating whether the transfer has been confirmed.|
||The date at which this row was last updated (in ISO-8601 format).|
|__indexer_id WHERE __confirmed = false|
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.