Skip to content

Token Prices

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

Indexes

Index
token_address, block_number
__indexer_id, __block_number
__indexer_id WHERE __confirmed = false
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.