Skip to content

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.


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

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


token_address, timestamp
__indexer_id, __block_number
__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.