Description

This table stores companys' performance by month. Abouts 239402 records(2014-01-21).

Table format

Field Type Null Key Default Extra
stock_id bigint(20) NO PRI NULL
date double NO PRI NULL
mth_ret double NO NULL

record example

stock_id date mth_ret
1 199201 0.010984
1 199202 -0.024365

change log

newly built

CREATE TABLE `stock_return` (
  `stock_id` bigint(20) NOT NULL,
  `date` double NOT NULL,
  `mth_ret` double NOT NULL,
  PRIMARY KEY (`stock_id`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
 
projs/clans/docs/dataset_db_stock_return.txt · Last modified: 2014/01/21 09:15 by cheungzeecn     Back to top