Skip to main content

​
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

TableDescription
prices.usdHistorical prices with timestamps
prices.usd_dailyDaily historical prices
prices.usd_latestLatest 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 nameData typeDescription
contract_addressvarbinaryThe unique identifier of the token
symbolvarcharThe identifier of the asset (ticker, cashtag)
pricedoubleThe price of the asset in USD
timestamptimestampThe timestamp for which this price is reported
blockchainvarcharThe blockchain on which the asset exists

​
prices.usd_latest

Column nameData typeDescription
contract_addressvarbinaryThe unique identifier of the token
symbolvarcharThe identifier of the asset (ticker, cashtag)
pricedoubleThe latest price of the asset in USD
blockchainvarcharThe blockchain on which the asset exists
For more information about the current price feed, please refer to the Prices Overview.