Comment on page
Prices
Tables containing historical prices of tokens
View Name | Description |
|---|---|
prices.all_pairs | Per-minute price data for supported token pairs |
prices.assets | Tokens supported on Spice AI with metadata |
The columns and their schema available for each table can be viewed with the
describe <table> command. For example:/* Show the columns available */
DESCRIBE prices.all_pairs;
DESCRIBE prices.assets;
-- etc.
Historical prices data is available in both pair specific tables named
prices.[Token0]_[Token2] (e.g. prices.btc_usdt) or in a single table containing all pairs named prices.all_pairs, which has an extra pair column to. For better performance, we recommend using the pair specific tables when you know the pairs that need to be queried at compile time and using the single table of all pairs when the pairs that need to be queried are determined dynamically at runtime.Prices are available in High-Low-Open-Close (HLOC) format.
Top level token historical token prices tables
Table Name | Description |
|---|---|
prices.[Token0]_[Token2] | HLOC values for pair [Token0]-[Token2] at 1 minute granularity |
prices.all_pairs | HLOC values for all pairs at 1 minute granularity |
The table list is also available as a SQL query using
show tables. For example:SHOW TABLES IN prices
The columns and their schema available for each table can be viewed with the
describe <table> command. For example:/* Show the columns available */
DESCRIBE prices.btc_usdt;
DESCRIBE prices.all_pairs;
Improving query performance - indexed columns
Query performance can be significantly improved by adding
WHERE clauses to your query on specific indexed columns.Table Name | Indexed Columns |
|---|---|
prices.[Token0]_[Token2] | timestamp |
prices.all_pairs | timestamp, pair |
Last modified 1mo ago