USD Prices (Legacy)

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

Legacy Price Tables

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

The following legacy tables provide historical price data for a fixed set of tokens (~2,800 tokens). While these tables continue to update for existing tokens, new tokens will only be added to the modern price tables.

Legacy Tables

Table	Description
prices.usd	Historical prices with timestamps
prices.usd_daily	Daily historical prices
prices.usd_latest	Latest available price per token

Modern Alternatives

For complete token coverage, use:

• prices.latest for the most recent price
• 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

prices.usd / prices.usd_daily

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

prices.usd_latest

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 latest price of the asset in USD
blockchain	varchar	The blockchain on which the asset exists

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