Interday Query Script Files

The Interday query scripts are located in the $RAP/RAPStore/data/scripts directory on the RAPStore server. The table contains descriptions of each file located in the $RAP/RAPStore/data/scripts directory.

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.


Created October 8, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com