This SQL script should be run on the RAPCache database at the end of each trading day to capture the last price of that day. This data is stored in the LAST_TRADE_PRICE table and is referenced by tick_qry3.sql. Before running the script, change the date in the two WHERE clauses to the date of the trading day for which the last trade price is to be captured.