“Finance-delivery-database-factor-4.47-mysql”版本间的差异
| 第58行： | 第58行： | ||
to visualize the architecture of our mysql database. You can also connect the | to visualize the architecture of our mysql database. You can also connect the | ||
| − | mysql database with | + | mysql database with program : |
| + | |||
| + | host='192.168.0.103', | ||
| + | |||
| + | port=3306, | ||
username: usemysql | username: usemysql | ||
2017年1月16日 (一) 06:27的版本
INTRODUCTION
FactorDB v4.47 Mysql is the mysql data format version of the factor DB 4.47
http://cslt.riit.tsinghua.edu.cn/mediawiki/index.php/Finance-delivery-database-factor-4.47
This database was organized by Yaodong Wang when he worked in CSLT@Tsinghua University
as an intern. This version was released in 2017.01.16.
The total data amount is from the starting of China A market
to 2016.12.
Data Sets
The present database involves 16 data sets, listed as follows:
1. 4_28_ASHAREODPRICES (中国A股日行情)
2. 4_29_ASHARECALENDAR (中国A股交易日历)
3. 4_30_ASHARETRADINGSUSPENSION (中国A股停复牌信息)
4. 4_31_ASHAREWEEKLYYIELD (中国A股周收益率)
5. 4_32_ASHAREMONTHLYYIELD (中国A股月收益率)
6. 4_33_ASHAREEODDERIVATIVEINDICATOR (中国 A 股日行情估值指标)
7. 4_36_ASHAREMARGINTRADE (中国 A 股融资融券交易明细)
8. 4_37_ASHAREMARGINTRADESUM (中国 A 股融资融券交易汇总)
9. 4_45_ASHAREMONEYFLOW (中国 A 股资金流向数据)
10. 4_47_ASHAREL2INDICATORS (中国 A 股LEVEL2指标)
11. 4_51_ASHAREBALANCESHEET (中国 A 股资产负债表)
12. 4_52_ASHAREINCOME (中国 A 股利润表)
13. 4_53_ASHARECASHFLOW (中国 A 股现金流量表)
14. 4_54_ASHAREFINANCIALINDICATOR (中国 A 股财务指标)
15. shsz_m1 (中国A股1分钟行情)
16 sp500_day (标普500天行情)
HOW TO USE
You can access the website http://192.168.0.103/phpmyadmin/index.php
to visualize the architecture of our mysql database. You can also connect the
mysql database with program :
host='192.168.0.103',
port=3306,
username: usemysql
passwd: 123456
LINCENCE
All the copy right are reserved by Wind. Any usage of this dataset
should refer to Wind's licence files.
CONTACT
Yang Wang: wangyang@cslt.riit.tsinghua.edu.cn
Dong Wang: wangdong99@mails.tsinghua.edu.cn
