Interday Query Script Files

The Interday query scripts are located in $RAP/RAPStore/data/scripts directory on the RAPStore server.

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.

Related reference
TAQ Data Query Script Files
Historical Data Query Script Files
interday_tick_qry1.sql
interday_tick_qry2.sql
interday_tick_qry3.sql