Token price data across multiple blockchains
prices
schema exposes these main tables:
Table | Description |
---|---|
prices.latest | The most recent price for each token |
prices.day | Daily token prices (most recent price of each day) |
prices.hour | Hourly token prices |
prices.minute | Minute-by-minute token prices |
dex.trades
)dune.blockchains
tableColumn | 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 | USD price |
timestamp | timestamp | Timestamp (start of minute, hour, or day) |
decimals | int | Token decimals |
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 |
contract_address
AND blockchain
symbol
is not unique - do not use for token identification or joinsdune.blockchains
tableprices.trusted_tokens
tabledex.trades
tableprices.usd
prices.usd_daily
prices.usd_latest