Interday Query Script Files

The Interday query scripts are located in the <RAP Enablement Installation Directory>/databases/iq/queries directory in the RAP enablement package.

Interday Query Script File Descriptions

Script Name

Description

interday_tick_qry1.sql

Determines the volume-weighted price of a security, considering only the ticks in a specified three-day interval.

interday_tick_qry2.sql

Determines the top 10 percentage losers for the specified date on the specified exchanges, sorted by percentage loss. The loss is calculated as a percentage of the last trade price of the previous day.

interday_tick_qry3.sql

Finds the most active stocks in the COMPUTER industry for the last three days.