Token Prices
The ethereum.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 |
The block number at which the event took place in. |
| __confirmed | boolean |
Flag indicating whether the transfer has been confirmed. |
| __last_modified | timestamp |
The date at which this row was last updated (in ISO-8601 format). |
Supported Protocols
| Protocol | |||
|---|---|---|---|
| aave-amm | aave-arc | aave-rwa | aave-v1 |
| aave-v2 | aave-v3 | compound-v2 | compound-v3 |
| convex-v1 | convex-v2 | convex-v4 | cream-v1 |
| curve-metapool | curve-plain | curve-tricrypto | curve-v1 |
| curve-v2 | ironbank-v1 | strike-v1 | synthetix-v1 |
| yearn-ironbank | yearn-v1 | yearn-yvecrv |
Indexes
| Index |
|---|
| token_address, timestamp |
| timestamp |
| block_number |
| __indexer_id, __block_number |
| __last_modified |
| __indexer_id WHERE __confirmed = false |
| token_address, block_number |
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.