arbitrum.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.|
||An internal identifier for the indexer that updates this row. Use block_number instead when querying.|
||Flag indicating whether the transfer has been confirmed.|
|__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.