Historical market data queries compare price histories for different instruments over time.
Historical market data changes infrequently, and updates typically occur at the end of the trading day. The end-of-day data is consolidated into the historical TAQ time series in Sybase IQ as well. Stock History, Stock Quotes, and Stock Trade tables contain entries for end-of-day data records.
The historical market data queries are optimized to run with the RAP sample data in Sybase IQ. Use dbisql to run these sample queries against Sybase IQ. The output that appears for each query is derived from the large set of sample data provided in the samples folder within the RAP enablement package. See the Sybase IQ 15.4 Utility Guide > dbisql Interactive SQL Utility.