Table of Contents
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
