Tables containing historical prices of tokens
Each historical prices dataset is structured with a top level table that contains aggregated prices across all supported exchanges. Each supported exchange then has its own subtable where prices from just that exchange are available.
Prices are available in High-Low-Open-Close (HLOC) format.
HLOC values for ETH at 1 minute granularity aggregated across all exchanges
HLOC values for BTC at 1 minute granularity aggregated across all exchanges
HLOC values for LTC at 1 minute granularity aggregated across all exchanges
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 */
Query performance can be significantly improved by adding
WHEREclauses to your query on specific indexed columns.