Real-time minute-by-minute price data for tokens across all supported blockchains
The prices.minute
table provides the most granular price data for tokens across multiple blockchains, with minute-level precision. This is the highest resolution price data available in the Dune platform.
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’) |
timestamp | timestamp | Minute timestamp |
price | double | Token price in USD |
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 |
The minute prices are built through these steps:
This table is ideal for high-frequency analysis and examining short-term price movements. It’s particularly useful for studying price impacts of specific events or transactions with high temporal precision.
The prices.minute
table is updated hourly based on the upstream data pipeline. As a result, prices typically have a latency of approximately 1 hour from real-time.
Here are some examples of how to use the prices tables.
prices.hour
or prices.day
for longer time ranges if minute-level precision is not requiredcontract_address
and blockchain
for precise token identification, never use symbol
for joins or filtersReal-time minute-by-minute price data for tokens across all supported blockchains
The prices.minute
table provides the most granular price data for tokens across multiple blockchains, with minute-level precision. This is the highest resolution price data available in the Dune platform.
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’) |
timestamp | timestamp | Minute timestamp |
price | double | Token price in USD |
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 |
The minute prices are built through these steps:
This table is ideal for high-frequency analysis and examining short-term price movements. It’s particularly useful for studying price impacts of specific events or transactions with high temporal precision.
The prices.minute
table is updated hourly based on the upstream data pipeline. As a result, prices typically have a latency of approximately 1 hour from real-time.
Here are some examples of how to use the prices tables.
prices.hour
or prices.day
for longer time ranges if minute-level precision is not requiredcontract_address
and blockchain
for precise token identification, never use symbol
for joins or filters