Preserving the Small TAQ Sample Data Set

If you load the larger sample data set into RAP, the TAQ data already in RAPStore and the STOCK_HISTORY table will be lost. To preserve the old sample data, you must perform additional steps.

  1. Use a text editor to open the file load_unix_IQ_TAQ_tables.tst.
  2. Comment out these lines:
    truncate table DBA.STOCK_QUOTE;
    commit;
    truncate table DBA.STOCK_TRADE;
    commit;
    load_unix_IQ_TAQ_tables.tst is called by load_unix_IQ_TAQ_tables.sh.
    This preserves the TAQ data already in RAPStore.
  3. In load_unix_IQ_TAQ_tables.sh, comment out these lines:
    truncate table DBA.STOCK_HISTORY;
    commit;
Related concepts
TAQ Data Queries