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..
|block_number||The block number at which the DEX swap occurred for pricing the token.||
|timestamp||The timestamp of the DEX swap (in ISO-8601 format).||
|token_address||The address of the token that is priced in USD.||
|token_symbol||The symbol of the token that is priced in USD.||
|price||The price of the token at the time of the swap in USD.||
|__confirmed||Flag indicating whether the block number the token was priced in has been confirmed.||
The following indexes are available for this table:
(token_address, timestamp) (block_number) (timestamp)
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.