Prices
Latest Prices
Most recent price data for tokens across all supported blockchains
prices.latest
Overview
The prices.latest
table provides the most recently available price for each token across all supported blockchains. This table is ideal for calculating current token values or displaying up-to-date prices.
Table Schema
Column | Type | Description |
---|---|---|
blockchain | varchar | Blockchain identifier (e.g., ‘ethereum’, ‘arbitrum’) |
contract_address | varbinary | Token contract address (fixed address for native tokens) |
symbol | varchar | Token symbol (e.g., ‘ETH’, ‘USDC’) |
price | double | Most recent token price in USD |
decimals | int | Token decimals |
timestamp | timestamp | Timestamp when this price was recorded |
volume | double | Trading volume in USD (from price source) |
source | varchar | Data source (‘coinpaprika’ or ‘dex.trades’) |
source_timestamp | timestamp | Exact timestamp of the source data point |
Implementation Details
The latest prices are built by:
- Taking the most recent price observation from each data source
- Selecting the latest observation per token across all sources
- Refreshed hourly to ensure prices stay current
Usage
This table is perfect for querying the current price of tokens without needing to filter by timestamp or perform additional aggregations. It’s designed for efficiency when you just need the most recent price.
Usage Examples
Here are some examples of how to use the prices tables.
Get current prices for major tokens:
Calculate total USD value of token holdings:
Get prices for native tokens across multiple blockchains:
Data Quality Notes
- Native tokens (like ETH, BNB) are assigned fixed addresses for consistency
- For native tokens, use
dune.blockchains
table to get the standardized address for each blockchain - The timestamp column shows when the price was last updated, useful for determining freshness
- For historical analysis, use
prices.day
,prices.hour
, orprices.minute
instead - Always use
contract_address
andblockchain
for precise token identification, never usesymbol
for joins or filters
Was this page helpful?