Interday queries reflect price quotes and trade prices across multiple trading days.
These queries examine the tick data of the current day plus historical data and can provide an alert for changes to statistical models during the course of the trading day.
Interday queries are optimized for RAPStore, as these queries require data that spans several days and weeks. Use dbisql to run these scripts against the RAPStore.
See “Using Interactive SQL (dbisql)” in the Sybase IQ Utility Guide.
The Interday query scripts are located in the $RAP/RAPStore/data/scripts directory on the RAPStore server.
The Interday queries for RAPStore all begin with a commit statement which causes the data to refresh, so the query accesses the most recent data. When you write your own queries for RAPStore, precede each query with a commit statement.