USD Prices (Legacy)

Historical price table - still functional but no new tokens will be added

Prices USD (Legacy)

While this table remains functional for existing tokens, no new tokens will be added. For complete coverage including new tokens, please use prices.minute, prices.hour, or prices.day tables instead.

The prices.usd table provides historical price data for a fixed set of tokens. While the table continues to update for existing tokens, new tokens will only be added to the modern price tables.

Modern Alternatives

For complete token coverage, use:

• prices.day for daily historical prices
• prices.hour for hourly historical data
• prices.minute for granular historical data

Example query using modern tables:

-- For historical prices, use prices.day
SELECT
    contract_address,
    blockchain,
    symbol,
    price,
    timestamp
FROM prices.day
WHERE
    blockchain = 'ethereum'
    AND contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 -- WETH
    AND timestamp >= DATE '2023-01-01'
ORDER BY timestamp asc

Legacy Table Structure

Column name	Data type	Description
contract_address	varbinary	The unique identifier of the token
symbol	varchar	The identifier of the asset (ticker, cashtag)
price	double	The price of the asset in USD
timestamp	timestamp	The timestamp for which this price is reported
blockchain	varchar	The blockchain on which the asset exists

For more information about the current price feed, please refer to the Prices Overview.