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.