Interday queries  Interday query examples

Chapter 3: Sample Queries

Script files

The Interday query scripts are located in the \Scripts\RAP_Queries\IQ folder. See the table below for a description of each script file.

Script name

Description

interday_tick_qry1.sql

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

interday_tick_qry2.sql

Determine 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

Find the most active stocks in the “COMPUTER” industry for last three days.





Copyright © 2005. Sybase Inc. All rights reserved. Interday query examples

View this book as PDF