Differences
This shows you the differences between two versions of the page.
projs:clans:docs:dataset_db_stock_return [2014/01/20 20:52] cheungzeecn |
projs:clans:docs:dataset_db_stock_return [2014/01/21 09:15] (current) cheungzeecn |
||
---|---|---|---|
Line 1: | Line 1: | ||
=====Description===== | =====Description===== | ||
This table stores companys' performance by month. | This table stores companys' performance by month. | ||
+ | Abouts 239402 records(2014-01-21). | ||
=====Table format===== | =====Table format===== | ||
Line 10: | Line 11: | ||
=====record example===== | =====record example===== | ||
- | +----------+--------+-----------+ | + | ^ stock_id ^date ^ mth_ret ^ |
- | | stock_id | date | mth_ret | | + | |
- | +----------+--------+-----------+ | + | |
| 1 | 199201 | 0.010984 | | | 1 | 199201 | 0.010984 | | ||
| 1 | 199202 | -0.024365 | | | 1 | 199202 | -0.024365 | | ||
Line 18: | Line 17: | ||
=====change log===== | =====change log===== | ||
newly built | newly built | ||
+ | <code> | ||
+ | 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 | ||
+ | </code> |