SQL

The following script contains the SQL statements for this query.

-- For each stock in a specified list of 1000 stocks, find the differences
-- between the daily high and daily low on the day of each split event
-- during a specified period.

commit
;

SELECT sh.TRADING_SYMBOL, sh.HIGH_PRICE - sh.LOW_PRICE AS D_PRICE, sh.TRADE_DATE
FROM   STOCK_HISTORY AS sh 
inner join SPLIT_EVENT A
on sh.INSTRUMENT_ID = A.INSTRUMENT_ID 
AND sh.TRADE_DATE = A.EFFECTIVE_DATE
WHERE  sh.TRADING_SYMBOL BETWEEN 'AAA' AND 'BML'
AND LENGTH(sh.TRADING_SYMBOL) = 3
and sh.TRADE_DATE BETWEEN '2005-08-04'
and '2005-10-04'
ORDER  BY sh.TRADING_SYMBOL 
;