tushare的mysql的sql结构文件

tushare 是一个开源的金融数据库

注册地址 https://tushare.pro/register?reg=285215

 

这里分享部分数据的sql结构文件，文件放到了gitee上： https://gitee.com/betterwgo/db_tushare.git

 

目前包含以下数据的sql结构：

balancesheet --- 资产负债表
cashflow --- 现金流量表
daily --- 日线行情
daily_basic --- 每日指标
dividend --- 分红送股
fina_indicator --- 财务指标
fina_mainbz --- 主营业务构成
income --- 利润表
stock_basic --- 股票列表
namechange --- 股票曾用名
pledge_detail --- 质押详情
pledge_stat --- 质押统计
stk_holdertrade --- 高管增减持
stock_company --- 上市公司基本信息

欢迎补充和勘误

 

样例：

DROP TABLE IF EXISTS `stock_basic`;
CREATE TABLE `stock_basic`  (
  `ts_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'TS代码',
  `symbol` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '股票代码',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '股票名称',
  `area` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在地域',
  `industry` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属行业 ',
  `fullname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '股票全称',
  `enname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '英文全称',
  `market` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '市场类型（主板/中小板/创业板/科创板）',
  `exchange` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '交易所代码',
  `curr_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '交易货币',
  `list_status` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上市状态：L上市D退市P暂停上市',
  `list_date` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上市日期',
  `delist_date` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退市日期',
  `is_hs` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否沪深港通标的，N否H沪股通S深股通',
  PRIMARY KEY (`ts_code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '股票列表' ROW_FORMAT = Dynamic;

 

 

 

 

 

 

 

 

 

 

 

 

---