CnOpenData 中国上市公司股票复权行情数据

CnOpenData_wj

于 2024-06-27 10:41:13 发布

阅读量275

点赞数 4

文章标签： big data

本文链接：https://blog.csdn.net/CnOpenData_wj/article/details/140006661

版权

中国上市公司股票复权行情数据是CnOpenData与通联数据合作的数据库，包含14张表格，分别是：

股票前复权因子表：获取沪深京股票用来调整历史行情的前复权因子数据，包含除权除息日、除权除息事项具体数据、本次复权因子、累积复权因子以及对应的生效日期区间。该因子用来调整历史行情，不作为预测使用，于除权除息日进行计算调整。只在发生分红、配股、股改事件的除权除息日才有复权因子记录。
股票后复权因子表：获取沪深京股票用来调整历史行情的后复权因子数据（以上市价格为基准），包含除权除息日、除权除息事项具体数据、本次复权因子、累积复权因子以及对应的生效日期区间。该因子用来调整历史行情，不作为预测使用，于除权除息日进行计算调整。只在发生分红、配股、股改事件的除权除息日才有复权因子记录。
股票成交量复权因子表：获取沪深京股票用来调整历史行情的成交量复权因子，包含单次和累积成交量前/后复权因子。该因子用来调整历史行情，不作为预测使用，于除权除息日进行计算调整。只在发生分红、配股、股改事件的除权除息日才有复权因子记录。
股票前复权日行情表
股票前复权日行情（现金分红）表：获取现金分红法计算的沪深股票前复权收盘日行情，包含前复权调整后的昨收价、开盘价、最高价、最低价、收盘价等。于除权除息日对历史行情的调整，更新时间为9:00前。
股票后复权日行情表
股票前复权周行情表：获取沪深京股票前复权周行情，在前复权日行情基础上计算，包含经前复权调整的昨收价、开盘价、最高价、最低价、收盘价、成交量、成交金额等字段。于除权除息日对历史行情的调整，更新时间为9:00前（含科创板）。
股票后复权周行情：获取沪深京股票后复权周行情，在后复权日行情基础上计算，包含经后复权调整的昨收价、开盘价、最高价、最低价、收盘价、成交量、成交金额等字段（含科创板）。
股票前复权月行情表：获取沪深京股票前复权月行情，在前复权日行情基础上计算，包含经前复权调整的昨收价、开盘价、最高价、最低价、收盘价、成交量、成交金额等字段。于除权除息日对历史行情的调整，更新时间为9:00前（含科创板）
股票后复权月行情表：获取沪深京股票后复权月行情，在后复权日行情基础上计算，包含经后复权调整的昨收价、开盘价、最高价、最低价、收盘价、成交量、成交金额等字段（含科创板）。
股票前复权季行情表：获取沪深京股票前复权季行情，在前复权日行情基础上计算，包含经前复权调整的昨收价、开盘价、最高价、最低价、收盘价、成交量、成交金额等字段。于除权除息日对历史行情的调整，更新时间为9:30前（含科创板）。
股票后复权季行情表：获取沪深京股票后复权季行情，在后复权日行情基础上计算，包含经后复权调整的昨收价、开盘价、最高价、最低价、收盘价、成交量、成交金额等字段（含科创板）。
股票前复权年行情表：获取沪深京股票前复权年行情，在前复权日行情基础上计算，包含经前复权调整的昨收价、开盘价、最高价、最低价、收盘价、成交量、成交金额等字段。于除权除息日对历史行情的调整，更新时间为9:30前（含科创板）。
股票后复权年行情表：获取沪深京股票后复权年行情，在后复权日行情基础上计算，包含经后复权调整的昨收价、开盘价、最高价、最低价、收盘价、成交量、成交金额等字段（含科创板）。

时间区间

截至2023.10

字段展示

股票前复权因子表-英文字段	股票前复权因子表-中文字段	股票后复权因子表-英文字段	股票后复权因子表-中文字段	股票成交量复权因子表-英文字段	股票成交量复权因子表-中文字段	股票前复权日行情表-英文字段	股票前复权日行情表-中文字段	股票前复权日行情表（现金分红）-英文字段	股票前复权日行情表（现金分红）-中文字段	股票后复权日行情表-英文字段	股票后复权日行情表-中文字段
ID	信息编码	ID 自增ID	ID	自增ID	ID	信息编码	ID	信息编码	ID	自增ID
SECURITY_ID	证券内部ID	SECURITY_ID	证券内部ID	SECURITY_ID	证券内部编码	SECURITY_ID	证券内部ID	SECURITY_ID	证券内部ID	SECURITY_ID	证券内部ID
TICKER_SYMBOL	交易代码	TICKER_SYMBOL	交易代码	TICKER_SYMBOL	证券交易代码	TICKER_SYMBOL	交易代码	TICKER_SYMBOL	交易代码	TICKER_SYMBOL	交易代码
EX_DIV_DATE	除权除息日	EXCHANGE_CD	交易市场代码	EXCHANGE_CD	交易市场	EXCHANGE_CD	交易市场代码	EXCHANGE_CD	交易市场代码	EXCHANGE_CD	交易市场代码
PER_CASH_DIV	每股派现	EX_DIV_DATE	除权除息日	EX_DIV_DATE	除权除息日	TRADE_DATE	交易日期	TRADE_DATE	交易日期	TRADE_DATE	交易日期
PER_SHARE_DIV_RATIO	每股送股比例	PER_CASH_DIV	每股派现	PER_SHARE_DIV_RATIO	每股送股比例	ACT_PRE_CLOSE_PRICE	昨收盘	PRE_CLOSE_PRICE	昨收盘	PER_CASH_DIV	每股派现
PER_SHARE_TRANS_RATIO	每股转增股比例	PER_SHARE_DIV_RATIO	每股送股比例	PER_SHARE_TRANS_RATIO	每股转增股比例	OPEN_PRICE	实际昨收盘	ACT_PRE_CLOSE_PRICE	实际昨收盘	PER_SHARE_DIV_RATIO	每股送股比例
ALLOTMENT_RATIO	每股配股比例	PER_SHARE_TRANS_RATIO	每股转增股比例	ALLOTMENT_RATIO	每股配股比例	HIGHEST_PRICE	今开盘	OPEN_PRICE	今开盘	PER_SHARE_TRANS_RATIO	每股转增股比例
ALLOTMENT_PRICE	配股价	ALLOTMENT_RATIO	每股配股比例	SPLITS_RATIO	拆分比例	LOWEST_PRICE	最高价	HIGHEST_PRICE	最高价	ALLOTMENT_RATIO	每股配股比例
PRE_CLOSE_PRICE	昨收盘	ALLOTMENT_PRICE	配股价	ADJ_FACTOR_3	单次成交量复权因子（后复权）	CLOSE_PRICE	最低价	LOWEST_PRICE	最低价	ALLOTMENT_PRICE	配股价
ACT_PRE_CLOSE_PRICE	实际昨收盘	SPLITS_RATIO	拆分比例	ACCUM_ADJ_FACTOR_3	累积成交量复权因子（后复权）	PRE_CLOSE_PRICE	今收盘	CLOSE_PRICE	今收盘	OPEN_PRICE	开盘价
ADJ_FACTOR_1	复权因子(前复权)	CLOSE_PRICE	收盘价	END_DATE_AF	后复权截止日期	PRE_CLOSE_PRICE_1	昨收盘(前复权)	PRE_CLOSE_PRICE_1	昨收盘(前复权)	HIGHEST_PRICE	最高价
ACCUM_ADJ_FACTOR	累积复权因子	ADJ_FACTOR_2	复权因子(后复权)	ADJ_FACTOR_4	单次成交量复权因子（前复权）	OPEN_PRICE_1	今开盘(前复权)	OPEN_PRICE_1	今开盘(前复权)	LOWEST_PRICE	最低价
END_DATE	累积复权因子截止日期	ACCUM_ADJ_FACTOR_2	累积复权因子(后复权)	ACCUM_ADJ_FACTOR_4	累积成交量复权因子（前复权）	HIGHEST_PRICE_1	最高价(前复权)	HIGHEST_PRICE_1	最高价(前复权)	CLOSE_PRICE	收盘价
UPDATE_TIME	更新时间	END_DATE	累积复权因子截止日期	END_DATE	前复权截止日期	LOWEST_PRICE_1	最低价(前复权)	LOWEST_PRICE_1	最低价(前复权)	PRE_CLOSE_PRICE_2	昨收盘(后复权)
		UPDATE_TIME	更新时间	UPDATE_TIME	更新时间	CLOSE_PRICE_1	今收盘(前复权)	CLOSE_PRICE_1	今收盘(前复权)	OPEN_PRICE_2	开盘价(后复权)
						ADJ_FACTOR_1	成交量(前复权)	TURNOVER_VOL	成交量(前复权)	HIGHEST_PRICE_2	最高价(后复权)
						ACCUM_ADJ_FACTOR	复权因子(前复权)	UPDATE_TIME	更新时间	LOWEST_PRICE_2	最低价(后复权)
						TURNOVER_VOL	累积复权因子			CLOSE_PRICE_2	收盘价(后复权)
						UPDATE_TIME	更新时间			ACCUM_ADJ_FACTOR_2	成交量（后复权）
										TURNOVER_VOL	累计复权因子(后复权)
										UPDATE_TIME	更新时间

股票前复权周行情表-英文字段	股票前复权周行情表-中文字段	股票后复权周行情表-英文字段	股票后复权周行情表-中文字段	股票前复权月行情表-英文字段	股票前复权月行情表-中文字段	股票后复权月行情表-英文字段	股票后复权月行情表-中文字段	股票前复权季行情表-英文字段	股票前复权季行情表-中文字段	股票后复权季行情表-英文字段	股票后复权季行情表-中文字段	股票前复权年行情表-英文字段	股票前复权年行情表-中文字段	股票后复权年行情表-英文字段	股票后复权年行情表-中文字段
ID	自增ID	ID	自增ID	ID	自增ID	ID	自增ID	ID	自增ID	ID	自增ID	ID	自增ID	ID	自增ID
SECURITY_ID	证券内部ID	SECURITY_ID	证券内部代码	SECURITY_ID	证券内部代码	SECURITY_ID	证券内部代码	SECURITY_ID	证券内部代码	SECURITY_ID	证券内部代码	SECURITY_ID	证券内部代码	SECURITY_ID	证券内部代码
END_DATE	交易日期	END_DATE	交易日	END_DATE	交易日	END_DATE	交易日	TICKER_SYMBOL	证券交易代码	TICKER_SYMBOL	证券交易代码	TICKER_SYMBOL	证券交易代码	TICKER_SYMBOL	证券交易代码
TRADE_DAYS	交易天数	TRADE_DAYS	交易天数	TRADE_DAYS	交易天数	TRADE_DAYS	交易天数	END_DATE	交易日	END_DATE	交易日	END_DATE	交易日	END_DATE	交易日
PRE_CLOSE_PRICE	上周收盘	PRE_CLOSE_PRICE	上周收盘	PRE_CLOSE_PRICE	上月收盘	PRE_CLOSE_PRICE	上月收盘	TRADE_DAYS	交易天数	TRADE_DAYS	交易天数	TRADE_DAYS	交易天数	TRADE_DAYS	交易天数
OPEN_PRICE	本周开盘	OPEN_PRICE	本周开盘	OPEN_PRICE	本月开盘	OPEN_PRICE	本月开盘	PRE_CLOSE_PRICE	前收盘	PRE_CLOSE_PRICE	前收盘	PRE_CLOSE_PRICE	前收盘	PRE_CLOSE_PRICE	前收盘
HIGHEST_PRICE	本周最高	HIGHEST_PRICE	本周最高	HIGHEST_PRICE	本月最高	HIGHEST_PRICE	本月最高	OPEN_PRICE	开盘价	OPEN_PRICE	开盘价	OPEN_PRICE	开盘价	OPEN_PRICE	开盘价
LOWEST_PRICE	本周最低	LOWEST_PRICE	本周最低	LOWEST_PRICE	本月最低	LOWEST_PRICE	本月最低	HIGHEST_PRICE	最高价	HIGHEST_PRICE	最高价	HIGHEST_PRICE	最高价	HIGHEST_PRICE	最高价
CLOSE_PRICE	本周收盘	CLOSE_PRICE	本周收盘	CLOSE_PRICE	本月收盘	CLOSE_PRICE	本月收盘	LOWEST_PRICE	最低价	LOWEST_PRICE	最低价	LOWEST_PRICE	最低价	LOWEST_PRICE	最低价
TURNOVER_VOL	成交量	TURNOVER_VOL	成交量	TURNOVER_VOL	成交量	TURNOVER_VOL	成交量	CLOSE_PRICE	收盘价	CLOSE_PRICE	收盘价	CLOSE_PRICE	收盘价	CLOSE_PRICE	收盘价
TURNOVER_VALUE	成交金额	TURNOVER_VALUE	成交金额	TURNOVER_VALUE	成交金额	TURNOVER_VALUE	成交金额	TURNOVER_VOL	成交量	TURNOVER_VOL	成交量	TURNOVER_VOL	成交量	TURNOVER_VOL	成交量
CHG	涨跌额	CHG	涨跌额	CHG	涨跌额	CHG	涨跌额	TURNOVER_VALUE	成交金额	TURNOVER_VALUE	成交金额	TURNOVER_VALUE	成交金额	TURNOVER_VALUE	成交金额
CHG_PCT	涨跌幅	CHG_PCT	涨跌幅	CHG_PCT	涨跌幅	CHG_PCT	涨跌幅	CHG	涨跌额	CHG	涨跌额	CHG	涨跌额	CHG	涨跌额
W_RETURN	周回报率	W_RETURN	周回报率	M_RETURN	月回报率	M_RETURN	月回报率	CHG_PCT	涨跌幅	CHG_PCT	涨跌幅	CHG_PCT	涨跌幅	CHG_PCT	涨跌幅
W_TURNOVER_RATE	周累计换手率	W_TURNOVER_RATE	周累计换手率	M_TURNOVER_RATE	月累计换手率	M_TURNOVER_RATE	月累计换手率	UPDATE_TIME	更新时间	UPDATE_TIME	更新时间	UPDATE_TIME	更新时间	UPDATE_TIME	更新时间
W_AVG_TURNOVER_RATE	周平均换手率	W_AVG_TURNOVER_RATE	周平均换手率	M_AVG_TURNOVER_RATE	月平均换手率	M_AVG_TURNOVER_RATE	月平均换手率
W_VAR_RETURN_100	周回报率方差	W_VAR_RETURN_100	周回报率方差	M_VAR_RETURN_24	月回报率方差(24)	M_VAR_RETURN_24	月回报率方差(24)
W_SD_RETURN_100	周回报率标准差	W_SD_RETURN_100	周回报率标准差	M_SD_RETURN_24	月回报率标准差(24)	M_SD_RETURN_24	月回报率标准差(24)
W_AVG_RETURN_100	周平均回报率	W_AVG_RETURN_100	周平均回报率	M_AVG_RETURN_24	月平均回报率(24)	M_AVG_RETURN_24	月平均回报率(24)
UPDATE_TIME	更新时间	UPDATE_TIME	更新时间	M_VAR_RETURN_60	月回报率方差(60)	M_VAR_RETURN_60	月回报率方差(60)
				M_SD_RETURN_60	月回报率标准差(60)	M_SD_RETURN_60	月回报率标准差(60)
				M_AVG_RETURN_60	月平均回报率(60)	M

样本数据

股票前复权因子表

ID	SECURITY_ID	TICKER_SYMBOL	EX_DIV_DATE	PER_CASH_DIV	PER_SHARE_DIV_RATIO	PER_SHARE_TRANS_RATIO	ALLOTMENT_RATIO	ALLOTMENT_PRICE	PRE_CLOSE_PRICE	ACT_PRE_CLOSE_PRICE	ADJ_FACTOR_1	ACCUM_ADJ_FACTOR	END_DATE	UPDATE_TIME
信息编码	证券内部ID	交易代码	除权除息日	每股派现	每股送股比例	每股转增股比例	每股配股比例	配股价	昨收盘	实际昨收盘	复权因子(前复权)	累积复权因子	累积复权因子截止日期	更新时间
37042371	76434	001236	2023-01-11	0.03000000					13.4200	13.4500	0.9977695167	0.9977695167	1753-01-01	2023-01-11 08:37:15.750
37042372	1722	002027	2023-01-11	0.14000000					6.8900	7.0300	0.9800853485	0.9397881535	2022-08-03	2023-07-03 08:35:43.540
37042373	77204	605009	2023-01-16	0.50000000					50.7800	51.2800	0.9902496100	0.9547342738	2022-06-10	2023-10-20 08:35:54.373
37042374	77310	601686	2023-01-20	0.15000000					6.1000	6.2500	0.9760000000	0.9760000000	2022-01-26	2023-01-20 08:36:09.327
37042375	29203	300475	2023-02-16				0.08944230	10.0700	18.3600	19.1000	0.9611855771	0.9561076155	2022-07-19	2023-07-05 08:35:52.847
37042376	1312	600666	2023-02-20			1.50000000			1.7900	2.8400	0.6302816901	0.6302816901	2017-05-26	2023-02-20 08:35:56.473
37042377	278	000651	2023-02-27	1.00000000					35.5600	36.5600	0.9726477024	0.9469841746	2022-08-05	2023-08-09 08:35:57.600
37042378	30535	002803	2023-03-10	0.26300000					16.7500	17.0100	0.9845385068	0.9731565588	2021-07-12	2023-09-25 08:35:45.850
37042379	77891	301059	2023-03-14	0.30000000		0.90000000			15.2900	29.3600	0.5209379033	0.5209379033	2022-05-16	2023-03-14 08:35:56.380
37042380	77962	301076	2023-03-22	0.60000000		0.30000000			23.6200	31.3000	0.7544851315	0.7544851315	2022-05-31	2023-03-22 08:37:07.153
37042381	75923	300721	2023-03-23	0.15000000		0.90000000			21.1500	40.3300	0.5243582549	0.5243582549	2022-05-27	2023-03-23 08:36:05.020
37042382	78391	001207	2023-03-29	0.20000000					16.1800	16.3800	0.9877899878	0.9877899878	2022-07-04	2023-03-29 08:35:44.303
37042383	75648	300818	2023-03-29	0.40000000		0.50000000			21.5300	32.7000	0.6585117227	0.6585117227	2021-06-03	2023-03-29 08:35:44.303
37042384	2199	002138	2023-03-29	0.20000000					25.4900	25.6900	0.9922148696	0.9922148696	2022-04-20	2023-03-29 08:35:44.303
37042385	29782	300496	2023-03-30	0.33700000					107.9800	108.3200	0.9968888479	0.9968888479	2022-04-12	2023-03-30 08:35:58.677
37042386	518	000975	2023-03-30	0.28000000					12.5200	12.8000	0.9781250000	0.9781250000	2022-05-13	2023-03-30 08:35:58.677
37042387	2764	300033	2023-03-30	2.50000000					173.8300	176.3300	0.9858220382	0.9858220382	2022-03-30	2023-03-30 08:35:58.677
37042388	77	200055	2023-04-03	0.05699954					2.0100	2.0700	0.9724639903	0.9724639903	2022-05-23	2023-04-03 08:35:46.370
37042389	76	000055	2023-04-03	0.05000000					4.7700	4.8200	0.9896265560	0.9896265560	2022-05-23	2023-04-03 08:35:46.370
37042390	39084	300700	2023-04-04			0.80000000			18.3500	33.0300	0.5555555556	0.5555555556	2021-06-01	2023-04-04 08:36:25.410
37042391	2437	002240	2023-04-06	0.65000000					33.9300	34.5800	0.9812030075	0.9812030075	2022-05-30	2023-04-06 08:35:56.990
37042392	2702	002315	2023-04-07	0.90000000					21.6300	22.5300	0.9600532623	0.9600532623	2022-04-21	2023-04-07 08:36:05.433
37042393	78265	301179	2023-04-07	0.52000000		0.80000000			28.5400	51.8900	0.5499882230	0.5499882230	2022-04-29	2023-04-07 08:36:05.433
37042394	39066	300708	2023-04-10	0.04000000					11.8700	11.9100	0.9966414777	0.9966414777	2022-03-14	2023-04-10 08:36:28.207
37042395	76675	300796	2023-04-10	0.12000000		0.80000000			13.4700	24.3600	0.5528188287	0.5528188287	2022-06-02	2023-04-10 08:36:28.207
37042396	75639	300654	2023-04-10	0.08000000		0.70000000			7.4600	12.7700	0.5845501866	0.5845501866	2022-05-30	2023-04-10 08:36:28.207
37042397	30011876	603856	2023-04-11	0.17400000					11.1200	11.2900	0.9845881311	0.9845881311	2022-07-05	2023-04-11 08:35:54.223
37042398	869	600305	2023-04-11	0.11000000					11.7200	11.8300	0.9907016061	0.9907016061	2022-07-01	2023-04-11 08:35:54.223
37042399	1241	600605	2023-04-11	0.10000000					14.0800	14.1800	0.9929478138	0.9929478138	2022-05-27	2023-04-11 08:35:54.223
37042400	30067	603317	2023-04-11	0.32000000		0.40000000			17.2800	24.4600	0.7064595258	0.7064595258	2022-05-20	2023-04-11 08:35:54.223
37042401	78487	600955	2023-04-12	0.16600000					21.8400	22.0100	0.9924579736	0.9924579736	2022-04-20	2023-04-12 08:36:05.060
37042402	4744	300354	2023-04-12	0.17700000					44.4700	44.6500	0.9960358343	0.9960358343	2022-04-29	2023-04-12 08:36:05.060
37042403	4735	603166	2023-04-13	0.10000000					5.8800	5.9800	0.9832775920	0.9832775920	2022-05-10	2023-04-13 08:36:01.060
37042404	115	000408	2023-04-13	0.96000000					23.1600	24.1100	0.9605972625	0.9275309515	2022-08-19	2023-08-24 08:36:16.340
37042405	1710	002014	2023-04-14	0.40000000					8.5900	8.9900	0.9555061179	0.9555061179	2022-04-14	2023-04-14 08:35:49.780
37042406	75248	603305	2023-04-14	0.12000000		0.40000000			24.1000	33.8600	0.7117542823	0.7117542823	2022-04-28	2023-04-14 08:35:49.780
37042407	30854	002865	2023-04-17	0.59711780	0.39807850				93.4200	131.2000	0.7120120926	0.7120120926	2021-05-26	2023-04-17 08:36:03.200
37042408	77800	301299	2023-04-17	0.80000000					62.9000	63.7000	0.9874411303	0.9815353820	1753-01-01	2023-09-26 08:35:59.637
37042409	777	600211	2023-04-17	0.74600000					63.3300	64.0800	0.9883583021	0.9647445736	2022-04-19	2023-09-26 08:35:59.637
37042410	3158	300059	2023-04-18	0.07000000		0.20000000			18.1300	21.8300	0.8306611696	0.8306611696	2022-04-20	2023-04-18 08:36:18.500

股票后复权因子表

ID	SECURITY_ID	TICKER_SYMBOL	EXCHANGE_CD	EX_DIV_DATE	PER_CASH_DIV	PER_SHARE_DIV_RATIO	PER_SHARE_TRANS_RATIO	ALLOTMENT_RATIO	ALLOTMENT_PRICE	SPLITS_RATIO	CLOSE_PRICE	ADJ_FACTOR_2	ACCUM_ADJ_FACTOR_2	END_DATE	UPDATE_TIME
自增ID	证券内部ID	交易代码	交易市场代码	除权除息日	每股派现	每股送股比例	每股转增股比例	每股配股比例	配股价	拆分比例	收盘价	复权因子(后复权)	累积复权因子(后复权)	累积复权因子截止日期	更新时间
48402	76434	001236	XSHE	2023-01-11	0.03000000						13.150	1.00223546947734	1.0022354695	9999-12-31	2023-01-11 15:19:42.473
48403	1722	002027	XSHE	2023-01-11	0.14000000						6.760	1.02031930334484	14.1011201255	2023-07-02	2023-07-03 08:35:50.277
48404	77204	605009	XSHG	2023-01-16	0.50000000						49.930	1.00984639620307	1.5577114035	2023-05-23	2023-05-24 08:35:56.667
48405	77310	601686	XSHG	2023-01-20	0.15000000						6.090	1.02459016393443	1.0770819573	9999-12-31	2023-01-20 15:16:23.327
48406	29203	300475	XSHE	2023-02-16				0.08944230	10.0700		18.120	1.04038181993649	2.2540534276	2023-07-04	2023-07-05 08:35:59.997
48407	1312	600666	XSHG	2023-02-20			1.50000000				1.880	1.58659217887377	17.9747594555	9999-12-31	2023-02-20 15:16:18.243
48408	278	000651	XSHE	2023-02-27	1.00000000						35.210	1.0281214848218	193.5753687334	2023-08-08	2023-08-09 08:36:04.860
48409	30535	002803	XSHE	2023-03-10	0.26300000						16.950	1.01570430520819	3.0384063888	2023-09-24	2023-09-25 08:35:53.017
48410	77891	301059	XSHE	2023-03-14	0.30000000		0.90000000				14.220	1.91961459065519	1.9505163065	9999-12-31	2023-03-14 15:22:21.573
48411	77962	301076	XSHE	2023-03-22	0.60000000		0.30000000				23.110	1.32540716609205	1.7511650005	9999-12-31	2023-03-22 15:13:21.237
48412	75923	300721	XSHE	2023-03-23	0.15000000		0.90000000				20.510	1.90709308121927	1.9446540645	9999-12-31	2023-03-23 15:13:24.073
48413	78391	001207	XSHE	2023-03-29	0.20000000						15.700	1.01236093942114	1.0417729365	9999-12-31	2023-03-29 15:13:23.007
48414	75648	300818	XSHE	2023-03-29	0.40000000		0.50000000				21.490	1.51857585146677	1.5314481571	9999-12-31	2023-03-29 15:13:23.007
48415	2199	002138	XSHE	2023-03-29	0.20000000						26.410	1.0078462142007	6.8053280176	9999-12-31	2023-03-29 15:13:23.007
48416	29782	300496	XSHE	2023-03-30	0.33700000						107.780	1.00312086157504	3.9894703283	9999-12-31	2023-03-30 15:13:22.150
48417	518	000975	XSHE	2023-03-30	0.28000000						12.680	1.0223642172524	10.6542235749	9999-12-31	2023-03-30 15:13:22.153
48418	2764	300033	XSHE	2023-03-30	2.50000000						175.000	1.01438186736613	9.0873832977	9999-12-31	2023-03-30 15:13:22.153
48419	77	200055	XSHE	2023-04-03	0.05699954						2.060	1.02831571140388	9.4832384535	9999-12-31	2023-04-03 15:13:20.430
48420	76	000055	XSHE	2023-04-03	0.05000000						4.850	1.01048218031045	9.9913719494	9999-12-31	2023-04-03 15:13:20.433
48421	39084	300700	XSHE	2023-04-04			0.80000000

股票成交量复权因子表

ID	SECURITY_ID	TICKER_SYMBOL	EXCHANGE_CD	EX_DIV_DATE	PER_SHARE_DIV_RATIO	PER_SHARE_TRANS_RATIO	ALLOTMENT_RATIO	SPLITS_RATIO	ADJ_FACTOR_3	ACCUM_ADJ_FACTOR_3	END_DATE_AF	ADJ_FACTOR_4	ACCUM_ADJ_FACTOR_4	END_DATE	UPDATE_TIME
自增ID	证券内部编码	证券交易代码	交易市场	除权除息日	每股送股比例	每股转增股比例	每股配股比例	拆分比例	单次成交量复权因子（后复权）	累积成交量复权因子（后复权）	后复权截止日期	单次成交量复权因子（前复权）	累积成交量复权因子（前复权）	前复权截止日期	更新时间
13565	1312	600666	XSHG	2023-02-20		1.50000000			0.4000000000	0.0597692905	9999-12-31	2.5000000000	2.5000000000	2017-05-26	2023-02-20 08:36:11.807
13566	77891	301059	XSHE	2023-03-14		0.90000000			0.5263157895	0.5263157895	9999-12-31	1.9000000000	1.9000000000	1753-01-01	2023-03-14 08:36:06.350
13567	77962	301076	XSHE	2023-03-22		0.30000000			0.7692307692	0.5917159763	9999-12-31	1.3000000000	1.3000000000	2022-05-31	2023-03-22 08:37:21.890
13568	75923	300721	XSHE	2023-03-23		0.90000000			0.5263157895	0.5263157895	9999-12-31	1.9000000000	1.9000000000	1753-01-01	2023-03-23 08:36:16.430
13569	75648	300818	XSHE	2023-03-29		0.50000000			0.6666666667	0.6666666667	9999-12-31	1.5000000000	1.5000000000	1753-01-01	2023-03-29 08:35:59.860
13570	39084	300700	XSHE	2023-04-04		0.80000000			0.5555555556	0.4273504274	9999-12-31	1.8000000000	1.8000000000	2021-06-01	2023-04-04 08:36:39.470
13571	78265	301179	XSHE	2023-04-07		0.80000000			0.5555555556	0.5555555556	9999-12-31	1.8000000000	1.8000000000	1753-01-01	2023-04-07 08:36:16.957
13572	75639	300654	XSHE	2023-04-10		0.70000000			0.5882352941	0.3016591252	9999-12-31	1.7000000000	1.7000000000	2020-06-17	2023-04-10 08:36:41.583
13573	76675	300796	XSHE	2023-04-10		0.80000000			0.5555555556	0.3968253969	9999-12-31	1.8000000000	1.8000000000	2022-06-02	2023-04-10 08:36:41.583
13574	30067	603317	XSHG	2023-04-11		0.40000000			0.7142857143	0.4105090312	9999-12-31	1.4000000000	1.4000000000	2021-05-24	2023-04-11 08:36:08.777
13575	75248	603305	XSHG	2023-04-14		0.40000000			0.7142857143	0.5102040817	9999-12-31	1.4000000000	1.4000000000	2022-04-28	2023-04-14 08:36:04.167
13576	30854	002865	XSHE	2023-04-17	0.39807850				0.7152674188	0.7152674188	9999-12-31	1.3980785000	1.3980785000	1753-01-01	2023-04-17 08:36:13.367
13577	3158	300059	XSHE	2023-04-18		0.20000000			0.8333333333	0.0128179034	9999-12-31	1.2000000000	1.2000000000	2022-04-20	2023-04-18 08:36:30.480
13578	79970	836395	XBEI	2023-04-19		1.00000000			0.5000000000	0.5000000000	9999-12-31	2.0000000000	2.0000000000	1753-01-01	2023-04-19 08:37:39.947
13579	78129	688091	XSHG	2023-04-20		0.10000000			0.9090909091	0.6684491978	9999-12-31	1.1000000000	1.1000000000	2022-10-20	2023-04-20 08:36:18.783
13580	79053	301369	XSHE	2023-04-20		0.50000000			0.6666666667	0.6666666667	9999-12-31	1.5000000000	1.5000000000	1753-01-01	2023-04-20 08:36:18.783
13581	2711	002756	XSHE	2023-04-21		0.30000000			0.7692307692	0.4273504274	9999-12-31	1.3000000000	1.3000000000	2016-06-20	2023-04-21 08:36:34.350
13582	30200	300453	XSHE	2023-04-24	0.20000000	0.10000000			0.7692307692	0.1602564103	9999-12-31	1.3000000000	1.3000000000	2021-04-29	2023-04-24 08:36:09.810
13583	76982	605111	XSHG	2023-04-24		0.40000000			0.7142857143	0.3644314869	9999-12-31	1.4000000000	1.4000000000	2022-04-27	2023-04-24 08:36:09.810
13584	78972	688290	XSHG	2023-04-24		0.20000000			0.8333333333	0.8333333333	9999-12-31	1.2000000000	1.2000000000	1753-01-01	2023-04-24 08:36:09.810
13585	79131	688301	XSHG	2023-04-24		0.40000000			0.7142857143	0.7142857143	9999-12-31	1.4000000000	1.4000000000	1753-01-01	2023-04-24 08:36:09.810
13586	2970	002407	XSHE	2023-04-25		0.40000000			0.7142857143	0.1373626374	9999-12-31	1.4000000000	1.4000000000	2016-05-12	2023-04-25 08:37:10.533
13587	3203	002459	XSHE	2023-04-25		0.40000000			0.7142857143	0.3924646782	9999-12-31	1.4000000000	1.4000000000	2022-06-17	2023-04-25 08:37:10.533
13588	30622	300586	XSHE	2023-04-26		0.30000000			0.7692307692	0.1619433198	9999-12-31	1.3000000000	1.3000000000	2020-06-01	2023-04-26 08:36:57.473
13589	76318	300750	XSHE	2023-04-26		0.80000000			0.5555555556	0.5555555556	9999-12-31	1.8000000000	1.8000000000	1753-01-01	2023-04-26 08:36:57.473
13590	78017	301193	XSHE	2023-04-26		0.60000000			0.6250000000	0.6250000000	9999-12-31	1.6000000000	1.6000000000	1753-01-01	2023-04-26 08:36:57.473
13591	29514	603866	XSHG	2023-04-27	0.20000000				0.8333333333	0.3036929057	9999-12-31	1.2000000000	1.2000000000	2022-04-22	2023-04-27 08:36:25.510
13592	76437	300765	XSHE	2023-04-27		0.80000000			0.5555555556	0.2035002035	9999-12-31	1.8000000000	1.8000000000	2021-04-28	2023-04-27 08:36:25.510
13593	77604	688314	XSHG	2023-04-27		0.40000000			0.7142857143	0.7142857143	9999-12-31	1.4000000000	1.4000000000	1753-01-01	2023-04-27 08:36:25.510
13594	78629	001206	XSHE	2023-04-28		0.40000000			0.7142857143	0.5102040817	9999-12-31	1.4000000000	1.4000000000	2022-09-15	2023-04-28 08:36:26.397
13595	78853	001308	XSHE	2023-04-28		0.30000000			0.7692307692	0.5917159763	9999-12-31	1.3000000000	1.3000000000	2022-06-01	2023-04-28 08:36:26.397
13596	706318	002871	XSHE	2023-04-28		0.30000000			0.7692307692	0.3120611640	9999-12-31	1.3000000000	1.3000000000	2021-05-28	2023-04-28 08:36:26.397
13597	76069	002943	XSHE	2023-05-04		0.30000000			0.7692307692	0.7692307692	9999-12-31	1.3000000000	1.3000000000	1753-01-01	2023-05-04 08:36:01.950
13598	78325	301153	XSHE	2023-05-04		0.80000000			0.5555555556	0.5555555556	9999-12-31	1.8000000000	1.8000000000	1753-01-01	2023-05-04 08:36:01.950
13599	3176	300087	XSHE	2023-05-05		0.40000000			0.7142857143	0.0613081258	9999-12-31	1.4000000000	1.4000000000	2022-04-28	2023-05-05 08:36:42.623
13600	4980	300390	XSHE	2023-05-05		0.30000000			0.7692307692	0.1282051282	9999-12-31	1.3000000000	1.3000000000	2019-05-28	2023-05-05 08:36:42.623
13601	76195	605368	XSHG	2023-05-05		0.40000000			0.7142857143	0.7142857143	9999-12-31	1.4000000000	1.4000000000	1753-01-01	2023-05-05 08:36:42.623
13602	78381	301226	XSHE	2023-05-05		0.60000000			0.6250000000	0.6250000000	9999-12-31	1.6000000000	1.6000000000	1753-01-01	2023-05-05 08:36:42.623
13603	78622	603219	XSHG	2023-05-05		0.40000000			0.7142857143	0.7142857143	9999-12-31	1.4000000000	1.4000000000	1753-01-01	2023-05-05 08:36:42.623
13604	98	000100	XSHE	2023-05-08		0.10000000			0.9090909091	0.3636363636	9999-12-31	1.1000000000	1.1000000000	2011-05-19	2023-05-08 08:36:12.697

股票前复权日行情表

ID	SECURITY_ID	TICKER_SYMBOL	EXCHANGE_CD	TRADE_DATE	ACT_PRE_CLOSE_PRICE	OPEN_PRICE	HIGHEST_PRICE	LOWEST_PRICE	CLOSE_PRICE	PRE_CLOSE_PRICE	PRE_CLOSE_PRICE_1	OPEN_PRICE_1	HIGHEST_PRICE_1	LOWEST_PRICE_1	CLOSE_PRICE_1	ADJ_FACTOR_1	ACCUM_ADJ_FACTOR	UPDATE_TIME	TURNOVER_VOL
信息编码	证券内部ID	交易代码	交易市场代码	交易日期	昨收盘	实际昨收盘	今开盘	最高价	最低价	今收盘	昨收盘(前复权)	今开盘(前复权)	最高价(前复权)	最低价(前复权)	今收盘(前复权)	成交量(前复权)	复权因子(前复权)	累积复权因子	更新时间
15637541	2	000001	XSHE	2023-10-11	11.020	11.090	11.090	10.960	10.980	11.020	11.020	11.090	11.090	10.960	10.980	1.0000000000	1.0000000000	72411569	2023-10-11 15:07:47.463
15637542	4	000002	XSHE	2023-10-11	12.820	12.850	12.870	12.660	12.770	12.820	12.820	12.850	12.870	12.660	12.770	1.0000000000	1.0000000000	52314028	2023-10-11 15:07:47.463
15637543	10	000005	XSHE	2023-10-11	1.450	1.450	1.460	1.430	1.450	1.450	1.450	1.450	1.460	1.430	1.450	1.0000000000	1.0000000000	4968100	2023-10-11 15:07:47.463
15637544	12	000006	XSHE	2023-10-11	4.380	4.380	4.440	4.320	4.400	4.380	4.380	4.380	4.440	4.320	4.400	1.0000000000	1.0000000000	20909000	2023-10-11 15:07:47.463
15637552	8	000004	XSHE	2023-10-11	17.340	18.230	18.500	17.480	17.560	17.340	17.340	18.230	18.500	17.480	17.560	1.0000000000	1.0000000000	37402699	2023-10-11 15:07:47.463
15637553	14	000007	XSHE	2023-10-11	4.340	4.340	4.340	4.270	4.300	4.340	4.340	4.340	4.340	4.270	4.300	1.0000000000	1.0000000000	793078	2023-10-11 15:07:47.463
15637545	17	000009	XSHE	2023-10-11	10.490	10.490	10.590	10.470	10.470	10.490	10.490	10.490	10.590	10.470	10.470	1.0000000000	1.0000000000	10330867	2023-10-11 15:07:47.463
15637546	19	000010	XSHE	2023-10-11	3.460	3.500	3.520	3.360	3.410	3.460	3.460	3.500	3.520	3.360	3.410	1.0000000000	1.0000000000	46959200	2023-10-11 15:07:47.463
15637547	27	000014	XSHE	2023-10-11	11.740	11.760	11.800	11.600	11.670	11.740	11.740	11.760	11.800	11.600	11.670	1.0000000000	1.0000000000	4517060	2023-10-11 15:07:47.463
15637548	29	000016	XSHE	2023-10-11	4.290	4.300	4.300	4.240	4.250	4.290	4.290	4.300	4.300	4.240	4.250	1.0000000000	1.0000000000	7569800	2023-10-11 15:07:47.463
15637554	16	000008	XSHE	2023-10-11	2.360	2.370	2.370	2.350	2.360	2.360	2.360	2.370	2.370	2.350	2.360	1.0000000000	1.0000000000	16301430	2023-10-11 15:07:47.463
15637555	21	000011	XSHE	2023-10-11	9.520	9.560	9.580	9.380	9.420	9.520	9.520	9.560	9.580	9.380	9.420	1.0000000000	1.0000000000	4936326	2023-10-11 15:07:47.463
15637557	24	000012	XSHE	2023-10-11	5.460	5.460	5.500	5.440	5.460	5.460	5.460	5.460	5.500	5.440	5.460	1.0000000000	1.0000000000	8790938	2023-10-11 15:07:47.463
15637560	31	000017	XSHE	2023-10-11	4.340	4.340	4.370	4.270	4.280	4.340	4.340	4.340	4.370	4.270	4.280	1.0000000000	1.0000000000	3807692	2023-10-11 15:07:47.463
15637549	35	000019	XSHE	2023-10-11	7.170	7.200	7.200	7.110	7.130	7.170	7.170	7.200	7.200	7.110	7.130	1.0000000000	1.0000000000	2436200	2023-10-11 15:07:47.463
15637551	37	000020	XSHE	2023-10-11	11.850	11.800	11.970	11.750	11.900	11.850	11.850	11.800	11.970	11.750	11.900	1.0000000000	1.0000000000	2270601	2023-10-11 15:07:47.463
15637563	42	000023	XSHE	2023-10-11	6.100	6.110	6.120	6.070	6.110	6.100	6.100	6.110	6.120	6.070	6.110	1.0000000000	1.0000000000	340000	2023-10-11 15:07:47.463
15637564	45	000025	XSHE	2023-10-11	15.560	15.530	15.560	15.320	15.380	15.560	15.560	15.530	15.560	15.320	15.380	1.0000000000	1.0000000000	2546040	2023-10-11 15:07:47.463
15637566	52	000029	XSHE	2023-10-11	11.240	11.240	11.400	10.990	11.190	11.240	11.240	11.240	11.400	10.990	11.190	1.0000000000	1.0000000000	3817790	2023-10-11 15:07:47.463
15637568	54	000030	XSHE	2023-10-11	5.450	5.480	5.480	5.300	5.310	5.450	5.450	5.480	5.480	5.300	5.310	1.0000000000	1.0000000000	6514158	2023-10-11 15:07:47.463
15637569	59	000034	XSHE	2023-10-11	28.750	28.600	29.120	28.160	28.350	28.750	28.750	28.600	29.120	28.160	28.350	1.0000000000	1.0000000000	22645334	2023-10-11 15:07:47.463
15637570	60	000035	XSHE	2023-10-11	5.900	5.920	6.080	5.790	5.820	5.900	5.900	5.920	6.080	5.790	5.820	1.0000000000	1.0000000000	32235645	2023-10-11 15:07:47.463
15637571	61	000036	XSHE	2023-10-11	3.840	3.840	3.850	3.780	3.790	3.840	3.840	3.840	3.850	3.780	3.790	1.0000000000	1.0000000000	6669607	2023-10-11 15:07:47.463
15637572	62	000037	XSHE	2023-10-11	8.590	8.620	8.650	8.500	8.550	8.590	8.590	8.620	8.650	8.500	8.550	1.0000000000	1.0000000000	5422532	2023-10-11 15:07:47.463
15637574	39	000021	XSHE	2023-10-11	17.890	18.000	18.180	17.720	17.880	17.890	17.890	18.000	18.180	17.720	17.880	1.0000000000	1.0000000000	27567982	2023-10-11 15:07:47.463
15637578	47	000026	XSHE	2023-10-11	11.180	11.230	11.310	11.160	11.230	11.180	11.180	11.230	11.310	11.160	11.230	1.0000000000	1.0000000000	3496161	2023-10-11 15:07:47.463
15637580	49	000027	XSHE	2023-10-11	6.300	6.290	6.330	6.250	6.250	6.300	6.300	6.290	6.330	6.250	6.250	1.0000000000	1.0000000000	10885667	2023-10-11 15:07:47.463
15637581	50	000028	XSHE	2023-10-11	30.210	30.210	30.870	30.210	30.430	30.210	30.210	30.210	30.870	30.210	30.430	1.0000000000	1.0000000000	5651253	2023-10-11 15:07:47.463
15637583	56	000031	XSHE	2023-10-11	3.580	3.590	3.600	3.530	3.550	3.580	3.580	3.590	3.600	3.530	3.550	1.0000000000	1.0000000000	17006234	2023-10-11 15:07:47.463
15637584	57	000032	XSHE	2023-10-11	22.580	22.580	23.050	22.330	22.690	22.580	22.580	22.580	23.050	22.330	22.690	1.0000000000	1.0000000000	13754903	2023-10-11 15:07:47.463
15637573	67	000040	XSHE	2023-10-11	3.720	3.720	3.740	3.690	3.710	3.720	3.720	3.720	3.740	3.690	3.710	1.0000000000	1.0000000000	9161859	2023-10-11 15:07:47.463
15637585	68	000042	XSHE	2023-10-11	6.490	6.490	6.520	6.430	6.480	6.490	6.490	6.490	6.520	6.430	6.480	1.0000000000	1.0000000000	3235573	2023-10-11 15:07:47.463
15637587	70	000045	XSHE	2023-10-11	11.220	11.180	11.520	11.070	11.380	11.220	11.220	11.180	11.520	11.070	11.380	1.0000000000	1.0000000000	12284997	2023-10-11 15:07:47.463
15637589	76	000055	XSHE	2023-10-11	4.790	4.820	4.830	4.780	4.800	4.790	4.790	4.820	4.830	4.780	4.800	1.0000000000	1.0000000000	5984050	2023-10-11 15:07:47.463
15637591	78	000056	XSHE	2023-10-11	2.960	2.970	3.180	2.930	3.020	2.960	2.960	2.970	3.180	2.930	3.020	1.0000000000	1.0000000000	27169185	2023-10-11 15:07:47.463
15637593	84	000061	XSHE	2023-10-11	6.950	6.930	6.950	6.710	6.750	6.950	6.950	6.930	6.950	6.710	6.750	1.0000000000	1.0000000000	9698800	2023-10-11 15:07:47.463
15637594	85	000062	XSHE	2023-10-11	11.450	11.460	11.570	11.370	11.510	11.450	11.450	11.460	11.570	11.370	11.510	1.0000000000	1.0000000000	5578499	2023-10-11 15:07:47.463
15637595	86	000063	XSHE	2023-10-11	32.930	33.010	34.380	33.010	33.920	32.930	32.930	33.010	34.380	33.010	33.920	1.0000000000	1.0000000000	80007662	2023-10-11 15:07:47.463
15637596	87	000065	XSHE	2023-10-11	13.280	13.140	13.430	12.940	13.050	13.280	13.280	13.140	13.430	12.940	13.050	1.0000000000	1.0000000000	26538938	2023-10-11 15:07:47.463
15637598	65	000039	XSHE	2023-10-11	6.790	6.800	6.820	6.760	6.770	6.790	6.790	6.800	6.820	6.760	6.770	1.0000000000	1.0000000000	10151052	2023-10-11 15:07:47.463

股票前复权日行情（现金分红）表

ID	SECURITY_ID	TICKER_SYMBOL	EXCHANGE_CD	TRADE_DATE	PRE_CLOSE_PRICE	ACT_PRE_CLOSE_PRICE	OPEN_PRICE	HIGHEST_PRICE	LOWEST_PRICE	CLOSE_PRICE	PRE_CLOSE_PRICE_1	OPEN_PRICE_1	HIGHEST_PRICE_1	LOWEST_PRICE_1	CLOSE_PRICE_1	TURNOVER_VOL	UPDATE_TIME
信息编码	证券内部ID	交易代码	交易市场代码	交易日期	昨收盘	实际昨收盘	今开盘	最高价	最低价	今收盘	昨收盘(前复权)	今开盘(前复权)	最高价(前复权)	最低价(前复权)	今收盘(前复权)	成交量(前复权)	更新时间
15616434	12	000006	XSHE	2023-10-11	4.380	4.380	4.380	4.440	4.320	4.400	4.380	4.380	4.440	4.320	4.400	20909000	2023-10-11 15:07:36.000
15616436	14	000007	XSHE	2023-10-11	4.340	4.340	4.340	4.340	4.270	4.300	4.340	4.340	4.340	4.270	4.300	793078	2023-10-11 15:07:36.000
15616438	16	000008	XSHE	2023-10-11	2.360	2.360	2.370	2.370	2.350	2.360	2.360	2.370	2.370	2.350	2.360	16301430	2023-10-11 15:07:36.000
15616440	17	000009	XSHE	2023-10-11	10.490	10.490	10.490	10.590	10.470	10.470	10.490	10.490	10.590	10.470	10.470	10330867	2023-10-11 15:07:36.000
15616443	19	000010	XSHE	2023-10-11	3.460	3.460	3.500	3.520	3.360	3.410	3.460	3.500	3.520	3.360	3.410	46959200	2023-10-11 15:07:36.000
15616446	21	000011	XSHE	2023-10-11	9.520	9.520	9.560	9.580	9.380	9.420	9.520	9.560	9.580	9.380	9.420	4936326	2023-10-11 15:07:36.000
15616449	22	200011	XSHE	2023-10-11	4.320	4.320	4.260	4.340	4.260	4.340	4.320	4.260	4.340	4.260	4.340	18200	2023-10-11 15:07:36.000
15616452	24	000012	XSHE	2023-10-11	5.460	5.460	5.460	5.500	5.440	5.460	5.460	5.460	5.500	5.440	5.460	8790938	2023-10-11 15:07:36.000
15616458	25	200012	XSHE	2023-10-11	2.420	2.420	2.420	2.420	2.400	2.420	2.420	2.420	2.420	2.400	2.420	335288	2023-10-11 15:07:36.000
15616505	35	000019	XSHE	2023-10-11	7.170	7.170	7.200	7.200	7.110	7.130	7.170	7.200	7.200	7.110	7.130	2436200	2023-10-11 15:07:36.000
15616509	36	200019	XSHE	2023-10-11	3.370	3.370	3.370	3.370	3.350	3.360	3.370	3.370	3.370	3.350	3.360	25700	2023-10-11 15:07:36.000
15616517	37	000020	XSHE	2023-10-11	11.850	11.850	11.800	11.970	11.750	11.900	11.850	11.800	11.970	11.750	11.900	2270601	2023-10-11 15:07:36.000
15616524	38	200020	XSHE	2023-10-11	2.150	2.150	2.110	2.170	2.100	2.150	2.150	2.110	2.170	2.100	2.150	5600	2023-10-11 15:07:36.000
15616562	45	000025	XSHE	2023-10-11	15.560	15.560	15.530	15.560	15.320	15.380	15.560	15.530	15.560	15.320	15.380	2546040	2023-10-11 15:07:36.000
15616568	46	200025	XSHE	2023-10-11	3.540	3.540	3.500	3.540	3.490	3.540	3.540	3.500	3.540	3.490	3.540	12800	2023-10-11 15:07:36.000
15616622	52	000029	XSHE	2023-10-11	11.240	11.240	11.240	11.400	10.990	11.190	11.240	11.240	11.400	10.990	11.190	3817790	2023-10-11 15:07:36.000
15616633	53	200029	XSHE	2023-10-11	2.330	2.330	2.330	2.330	2.200	2.300	2.330	2.330	2.330	2.200	2.300	105700	2023-10-11 15:07:36.000
15616638	54	000030	XSHE	2023-10-11	5.450	5.450	5.480	5.480	5.300	5.310	5.450	5.480	5.480	5.300	5.310	6514158	2023-10-11 15:07:36.000
15616644	55	200030	XSHE	2023-10-11	2.560	2.560	2.560	2.570	2.540	2.560	2.560	2.560	2.570	2.540	2.560	13000	2023-10-11 15:07:36.000
15616652	56	000031	XSHE	2023-10-11	3.580	3.580	3.590	3.600	3.530	3.550

票前复权月行情表

ID	SECURITY_ID	END_DATE	TRADE_DAYS	PRE_CLOSE_PRICE	OPEN_PRICE	HIGHEST_PRICE	LOWEST_PRICE	CLOSE_PRICE	TURNOVER_VOL	TURNOVER_VALUE	CHG	CHG_PCT	M_RETURN	M_TURNOVER_RATE	M_AVG_TURNOVER_RATE	M_VAR_RETURN_24	M_SD_RETURN_24	M_AVG_RETURN_24	M_VAR_RETURN_60	M_SD_RETURN_60	M_AVG_RETURN_60	UPDATE_TIME
自增ID	证券内部代码	交易日	交易天数	上月收盘	本月开盘	本月最高	本月最低	本月收盘	成交量	成交金额	涨跌额	涨跌幅	月回报率	月累计换手率	月平均换手率	月回报率方差(24)	月回报率标准差(24)	月平均回报率(24)	月回报率方差(60)	月回报率标准差(60)	月平均回报率(60)	更新时间
106988723	2	2023-09-28	20	11.130	11.190	11.590	11.030	11.200	1362561302	15368730470.910	0.070	0.00628931	0.00628931	0.0703	0.0035	0.00848853	0.09213324	-0.01380319	0.00873037	0.09343645	0.00573959	2023-09-28 15:14:21.000
106994095	2	2023-10-31	4	11.200	11.160	11.200	10.960	11.110	309374979	3428345846.800	-0.090	-0.00803571	-0.00803571	0.0159	0.0040	0.00802674	0.08959210	-0.01778618	0.00872781	0.09342273	0.00581761	2023-10-12 15:13:51.000
106988724	4	2023-09-28	20	13.640	13.880	14.330	13.020	13.080	1085029228	14858115097.120	-0.560	-0.04105572	-0.04105572	0.1116	0.0056	0.01422045	0.11924954	-0.00915052	0.00948333	0.09738242	-0.00177487	2023-09-28 15:14:21.000
106994096	4	2023-10-31	4	13.080	13.060	13.060	12.660	12.840	187291563	2403768193.840	-0.240	-0.01834862	-0.01834862	0.0192	0.0048	0.01338654	0.11570021	-0.00385257	0.00948790	0.09740586	-0.00203265	2023-10-12 15:13:51.000
106988725	8	2023-09-28	20	16.470	16.200	17.500	15.050	16.030	190241095	3121736139.790	-0.440	-0.02671524	-0.02671524	1.5063	0.0753	0.01835191	0.13546920	0.00259534	0.02570108	0.16031556	0.01152685	2023-09-28 15:14:21.000
106994097	8	2023-10-31	4	16.030	16.040	18.500	15.710	17.320	78051099	1359779721.110	1.290	0.08047411	0.08047411	0.6181	0.1545	0.01794093	0.13394374	0.01075612	0.02575886	0.16049567	0.01324544	2023-10-12 15:13:51.000
106988726	10	2023-09-28	20	1.410	1.410	1.520	1.360	1.450	183344348	264111382.770	0.040	0.02836879	0.02836879	0.1732	0.0087	0.01415811	0.11898784	-0.00740626	0.01060971	0.10300344	-0.00594658	2023-09-28 15:14:21.000
106994098	10	2023-10-31	4	1.450	1.440	1.470	1.410	1.450	26337283	37957501.720	0.000	0.00000000	0.00000000	0.0249	0.0062	0.01406858	0.11861106	-0.00898604	0.01053619	0.10264595	-0.00475610	2023-10-12 15:13:51.000
106988727	12	2023-09-28	20	5.230	5.260	5.350	4.490	4.540	606501396	2899729835.630	-0.690	-0.13193117	-0.13193117	0.4493	0.0225	0.02349433	0.15327861	0.01180570	0.01728440	0.13147017	0.00608440	2023-09-28 15:14:21.000
106994099	12	2023-10-31	4	4.540	4.540	4.540	4.320	4.440	68221396	300638430.490	-0.100	-0.02202643	-0.02202643	0.0506	0.0127	0.02323908	0.15244370	0.01386064	0.01706531	0.13063427	0.00755855	2023-10-12 15:13:51.000
106988728	14	2023-09-28	20	5.080	5.100	5.100	4.440	4.500	38551832	180497341.820	-0.580	-0.11417323	-0.11417323	0.1247	0.0062	0.01475575	0.12147325	0.00998307	0.02736374	0.16541989	0.00660796	2023-09-28 15:14:21.000
106994100	14	2023-10-31	4	4.500	4.460	4.500	4.270	4.300	4381734	19025872.380	-0.200	-0.04444444	-0.04444444	0.0142	0.0036	0.01484476	0.12183907	0.00665368	0.02729734	0.16521906	0.00710179	2023-10-12 15:13:51.000
106988729	16	2023-09-28	20	2.360	2.360	2.550	2.350	2.440	573982324	1399307426.500	0.080	0.03389831	0.03389831	0.2136	0.0107	0.01235277	0.11114304	0.00872101	0.00783003	0.08848748	-0.00616594	2023-09-28 15:14:21.000
106994101	16	2023-10-31	4	2.440	2.430	2.440	2.350	2.390	91141104	217177867.220	-0.050	-0.02049180	-0.02049180	0.0339	0.0085	0.01232069	0.11099861	0.00916348	0.00783216	0.08849947	-0.00654557	2023-10-12 15:13:51.000
106988730	17	2023-09-28	20	10.660	10.670	10.930	10.080	10.420	179967629	1886246632.910	-0.240	-0.02251407	-0.02251407	0.0706	0.0035	0.01720799	0.13117923	-0.01657429	0.03332838	0.18256061	0.03123917	2023-09-28 15:14:21.000
106994102	17	2023-10-31	4	10.420	10.400	10.670	10.260	10.560	45405107	476112878.510	0.140	0.01343570	0.01343570	0.0177	0.0044	0.01674116	0.12938763	-0.01977117	0.03286723	0.18129321	0.03368940	2023-10-12 15:13:51.000
106988731	19	2023-09-28	20	3.230	3.190	3.800	2.800	3.530	1817212354	5949512245.620	0.300	0.09287926	0.09287926	3.4802	0.1740	0.01720311	0.13116064	0.00588404	0.01124991	0.10606561	0.00010510	2023-09-28 15:14:21.000
106994103	19	2023-10-31	4	3.530	3.410	3.710	3.330	3.390	267409472	930468223.260	-0.140	-0.03966006	-0.03966006	0.5121	0.1280	0.01708887	0.13072440	0.00128769	0.01113440	0.10551965	0.00096553	2023-10-12 15:13:51.000
106988732	21	2023-09-28	20	10.880	11.070	11.190	9.680	9.770	168035378	1710592468.640	-1.110	-0.10202206	-0.10202206	0.3192	0.0160	0.00983551	0.09917416	-0.00052822	0.02537414	0.15929262	0.01087437	2023-09-28 15:14:21.000
106994104	21	2023-10-31	4	9.770	9.740	9.830	9.380	9.520	16875126	161684236.660	-0.250	-0.02558854	-0.02558854	0.0321	0.0080	0.00951393	0.09753937	0.00212070	0.02436706	0.15609952	0.01434990	2023-10-12 15:13:51.000
106988733	22	2023-09-28	20	4.540	4.520	4.700	4.380	4.430	1214610	5529101.600	-0.110	-0.02422907	-0.02422907	0.0181	0.0009	0.00362468	0.06020533	-0.00419880	0.00715480	0.08458606	0.00483681	2023-09-28 15:14:21.000
106994105	22	2023-10-31	4	4.430	4.350	4.420	4.210	4.320	318504	1373219.340	-0.110	-0.02483070	-0.02483070	0.0047	0.0012	0.00351265	0.05926762	-0.00279348	0.00634354	0.07964634	0.00799933	2023-10-12 15:13:51.000
106988734	24	2023-09-28	20	5.890	5.890	5.920	5.590	5.640	199491999	1148090039.010	-0.250	-0.04244482	-0.04244482	0.1018	0.0051	0.00880019	0.09380933	-0.01723534	0.01246374	0.11164113	0.01116849	2023-09-28 15:14:21.000
106994106	24	2023-10-31	4	5.640	5.640	5.650	5.420	5.520	48129892	265730360.020	-0.120	-0.02127660	-0.02127660	0.0246	0.0062	0.00851402	0.09227146	-0.01408098	0.01206432	0.10983770	0.01322922	2023-10-12 15:13:51.000
106988735	25	2023-09-28	20	2.490	2.480	2.530	2.430	2.460	10443419	25789741.120	-0.030	-0.01204819	-0.01204819	0.0092	0.0005	0.00239023	0.04888996	-0.01075566	0.00451469	0.06719148	0.00435791	2023-09-28 15:14:21.000
106994107	25	2023-10-31	4	2.460	2.450	2.450	2.400	2.420	2554701	6178873.420	-0.040	-0.01626016	-0.01626016	0.0023	0.0006	0.00200500	0.04477728	-0.00712676	0.00427317	0.06536945	0.00602184	2023-10-12 15:13:51.000
106988736	27	2023-09-28	20	14.120	14.370	14.430	11.900	12.110	191267041	2492329327.180	-2.010	-0.14235127	-0.14235127	0.7901	0.0395	0.02127479	0.14585880	0.03935223	0.01463161	0.12096118	0.01217026	2023-09-28 15:14:21.000
106994108	27	2023-10-31	4	12.110	12.130	12.130	11.600	11.670	22311835	261393597.470	-0.440	-0.03633361	-0.03633361	0.0923	0.0231	0.02136526	0.14616859	0.03871171	0.01422221	0.11925692	0.01406432	2023-10-12 15:13:51.000
106988737	29	2023-09-28	20	4.300	4.310	4.580	4.170	4.300	163463738	710587303.960	0.000	0.00000000	0.00000000	0.1022	0.0051	0.00947220	0.09732522	-0.01069268	0.02498606	0.15806979	0.01117204	2023-09-28 15:14:21.000
106994109	29	2023-10-31	4	4.300	4.280	4.380	4.240	4.370	32377119	139014748.570	0.070	0.01627907	0.01627907	0.0202	0.0051	0.00911426	0.09546861	-0.00575569	0.02452995	0.15662041	0.01396861	2023-10-12 15:13:51.000
106988738	30	2023-09-28	20	1.420	1.410	1.450	1.190	1.240	5208621	6954509.840	-0.180	-0.12676056	-0.12676056	0.0066	0.0003	0.00240332	0.04902371	-0.02767404	0.00487784	0.06984153	-0.00842622	2023-09-28 15:14:21.000
106994110	30	2023-10-31	4	1.240	1.220	1.230	1.150	1.170	1266000	1511113.260	-0.070	-0.05645161	-0.05645161	0.0014	0.0004	0.00231237	0.04808713	-0.02663162	0.00438552	0.06622326	-0.00628844	2023-10-12 15:13:51.000
106988739	31	2023-09-28	20	4.500	4.540	4.670	4.290	4.440	73487905	331315885.430	-0.060	-0.01333333	-0.01333333	0.2425	0.0121	0.01094278	0.10460776	0.01487922	0.01344108	0.11593565	0.00556379	2023-09-28 15:14:21.000
106994111	31	2023-10-31	4	4.440	4.440	4.560	4.200	4.220	18900393	81648822.660	-0.220	-0.04954955	-0.04954955	0.0624	0.0156	0.01097825	0.10477714	0.01460037	0.01339355	0.11573052	0.00591822	2023-10-12 15:13:51.000
106988740	32	2023-09-28	20	1.030	1.030	1.030	0.960	0.990	1692890	1680180.760	-0.040	-0.03883495	-0.03883495	0.0069	0.0003	0.00556697	0.07461210	-0.01452966	0.01474460	0.12142734	-0.00629686	2023-09-28 15:14:21.000
106994112	32	2023-10-31	4	0.990	0.970	0.980	0.930	0.960	283674	267926.820	-0.030	-0.03030303	-0.03030303	0.0011	0.0003	0.00557720	0.07468065	-0.01523673	0.01474948	0.12144743	-0.00641431	2023-10-12 15:13:51.000
106988741	35	2023-09-28	20	7.240	7.250	7.480	7.240	7.300	59714862	439200835.560	0.060	0.00828729	0.00828729	0.1434	0.0072	0.00924359	0.09614359	0.00965843	0.00930703	0.09647296	0.00306686	2023-09-28 15:14:21.000
106994113	35	2023-10-31	4	7.300	7.300	7.300	7.110	7.230	12310301	88340207.530	-0.070	-0.00958904	-0.00958904	0.0296	0.0074	0.00910369	0.09541327	0.01132891	0.00879398	0.09377622	0.00574272	2023-10-12 15:13:51.000
106988742	36	2023-09-28	20	3.440	3.440	3.450	3.310	3.380	761517	2579155.450	-0.060	-0.01744186	-0.01744186	0.0147	0.0007	0.00082701	0.02875772	0.00303076	0.00214301	0.04629264	0.00211282	2023-09-28 15:14:21.000
106994114	36	2023-10-31	4	3.380	3.350	3.380	3.310	3.340	81475	272420.450	-0.040	-0.01183432	-0.01183432	0.0017	0.0004	0.00081559	0.02855860	0.00332557	0.00189883	0.04357552	0.00388132	2023-10-12 15:13:51.000

股票后复权月行情表

ID	SECURITY_ID	END_DATE	TRADE_DAYS	PRE_CLOSE_PRICE	OPEN_PRICE	HIGHEST_PRICE	LOWEST_PRICE	CLOSE_PRICE	TURNOVER_VOL	TURNOVER_VALUE	CHG	CHG_PCT	M_RETURN	M_TURNOVER_RATE	M_AVG_TURNOVER_RATE	M_VAR_RETURN_24	M_SD_RETURN_24	M_AVG_RETURN_24	M_VAR_RETURN_60	M_SD_RETURN_60	M_AVG_RETURN_60	UPDATE_TIME
自增ID	证券内部代码	交易日	交易天数	上月收盘	本月开盘	本月最高	本月最低	本月收盘	成交量	成交金额	涨跌额	涨跌幅	月回报率	月累计换手率	月平均换手率	月回报率方差(24)	月回报率标准差(24)	月平均回报率(24)	月回报率方差(60)	月回报率标准差(60)	月平均回报率(60)	更新时间
98903461	2	2023-09-28	20	1492.196	1500.240	1553.868	1478.789	1501.581	16427499	15368730470.910	9.385	0.00628939	0.00628939	0.0703	0.0035	0.00849160	0.09214988	-0.01380242	0.00873147	0.09344236	0.00574014	2023-09-28 17:22:18.000
98903462	4	2023-09-28	20	2266.026	2305.897	2380.656	2163.025	2172.992	19572957	14858115097.120	-93.034	-0.04105602	-0.04105602	0.1116	0.0056	0.01421785	0.11923861	-0.00915082	0.00948302	0.09738078	-0.00177456	2023-09-28 17:22:18.000
98903463	8	2023-09-28	20	112.555	110.710	119.594	102.851	109.548	47377397	3121736139.790	-3.007	-0.02671583	-0.02671583	1.5063	0.0753	0.01835181	0.13546885	0.00259531	0.02570097	0.16031522	0.01152673	2023-09-28 17:22:18.000
98903464	10	2023-09-28	20	13.855	13.855	14.936	13.363	14.248	28243831	264111382.770	0.393	0.02836521	0.02836521	0.1732	0.0087	0.01415946	0.11899352	-0.00740471	0.01060979	0.10300385	-0.00594638	2023-09-28 17:22:18.000
98903465	12	2023-09-28	20	380.179	382.360	388.902	326.387	330.021	17436165	2899729835.630	-50.158	-0.13193259	-0.13193259	0.4493	0.0225	0.02349221	0.15327167	0.01180713	0.01728323	0.13146569	0.00608388	2023-09-28 17:22:18.000
98903466	14	2023-09-28	20	61.116	61.357	61.357	53.417	54.138	4301154	180497341.820	-6.978	-0.11417632	-0.11417632	0.1247	0.0062	0.01475519	0.12147095	0.00998261	0.02736353	0.16541926	0.00660771	2023-09-28 17:22:18.000
98903467	16	2023-09-28	20	63.474	63.474	68.584	63.205	65.626	25717028	1399307426.500	2.152	0.03390365	0.03390365	0.2136	0.0107	0.01235274	0.11114286	0.00872154	0.00782898	0.08848153	-0.00616544	2023-09-28 17:22:18.000
98903468	17	2023-09-28	20	108.140	108.241	110.879	102.256	105.705	20533541	1886246632.910	-2.435	-0.02251711	-0.02251711	0.0706	0.0035	0.01720501	0.13116787	-0.01657459	0.03332250	0.18254451	0.03123552	2023-09-28 17:22:18.000
98903469	19	2023-09-28	20	34.802	34.371	40.943	30.169	38.034	202813882	5949512245.620	3.232	0.09286823	0.09286823	3.4802	0.1740	0.01720425	0.13116498	0.00588473	0.01125057	0.10606871	0.00010545	2023-09-28 17:22:18.000
98903470	21	2023-09-28	20	49.485	50.349	50.895	44.027	44.437	53742910	1710592468.640	-5.048	-0.10201071	-0.10201071	0.3192	0.0160	0.00983345	0.09916378	-0.00052889	0.02537579	0.15929781	0.01087478	2023-09-28 17:22:18.000
98903471	22	2023-09-28	20	20.747	20.656	21.479	20.016	20.245	539974	5529101.600	-0.502	-0.02419627	-0.02419627	0.0181	0.0009	0.00362269	0.06018875	-0.00420270	0.00715247	0.08457226	0.00483624	2023-09-28 17:22:18.000
98903472	24	2023-09-28	20	202.219	202.219	203.249	191.920	193.636	12423624	1148090039.010	-8.583	-0.04244408	-0.04244408	0.1018	0.0051	0.00879482	0.09378070	-0.01723603	0.01246087	0.11162826	0.01116784	2023-09-28 17:22:18.000
98903473	25	2023-09-28	20	75.823	75.518	77.041	73.996	74.909	881262	25789741.120	-0.914	-0.01205439	-0.01205439	0.0092	0.0005	0.00239378	0.04892631	-0.01075082	0.00451930	0.06722572	0.00436079	2023-09-28 17:22:18.000
98903474	27	2023-09-28	20	157.683	160.474	161.145	132.891	135.236	22883795	2492329327.180	-22.447	-0.14235523	-0.14235523	0.7901	0.0395	0.02127870	0.14587221	0.03935530	0.01463389	0.12097063	0.01217161	2023-09-28 17:22:18.000
98903475	29	2023-09-28	20	98.145	98.373	104.535	95.177	98.145	12230731	710587303.960	0.000	0.00000000	0.00000000	0.1022	0.0051	0.00946996	0.09731373	-0.01069483	0.02498084	0.15805327	0.01116901	2023-09-28 17:22:18.000
98903476	30	2023-09-28	20	32.752	32.521	33.444	27.447	28.600	487152	6954509.840	-4.152	-0.12677088	-0.12677088	0.0066	0.0003	0.00240176	0.04900777	-0.02766809	0.00487929	0.06985191	-0.00842294	2023-09-28 17:22:18.000
98903477	31	2023-09-28	20	14.656	14.786	15.210	13.972	14.461	24876926	331315885.430	-0.195	-0.01330513	-0.01330513	0.2425	0.0121	0.01094004	0.10459467	0.01487958	0.01343886	0.11592610	0.00556339	2023-09-28 17:22:18.000
98903478	32	2023-09-28	20	2.471	2.471	2.471	2.303	2.375	754911	1680180.760	-0.096	-0.03885067	-0.03885067	0.0069	0.0003	0.00555931	0.07456077	-0.01452805	0.01474166	0.12141525	-0.00629541	2023-09-28 17:22:18.000
98903479	35	2023-09-28	20	39.511	39.565	40.821	39.511	39.838	15051213	439200835.560	0.327	0.00827618	0.00827618	0.1434	0.0072	0.00924630	0.09615770	0.00965979	0.00930968	0.09648667	0.00306728	2023-09-28 17:22:18.000
98903480	36	2023-09-28	20	2.094	2.094	2.100	2.015	2.057	264879	2579155.450	-0.0