CnOpenData 股票日行情表

最新推荐文章于 2024-07-30 10:05:44 发布

原创最新推荐文章于 2024-07-30 10:05:44 发布 · 753 阅读

13 ·

CC 4.0 BY-SA版权

文章标签：

#big data

时间区间

截至2023.10

字段展示

股票日行情表-英文字段	股票日行情表表-中文字段
ID	自增ID
SECURITY_ID	证券内部ID
TICKER_SYMBOL	证券代码
EXCHANGE_CD	交易市场代码
TRADE_DATE	交易日
PRE_CLOSE_PRICE	昨收盘
ACT_PRE_CLOSE_PRICE	实际昨收盘
OPEN_PRICE	今开盘
HIGHEST_PRICE	最高价
LOWEST_PRICE	最低价
CLOSE_PRICE	今收盘
TURNOVER_VOL	成交量
TURNOVER_VALUE	成交金额
DEAL_AMOUNT	成交笔数
PE	市盈率TTM
PE1	动态市盈率
PB	流通市值
NEG_MARKET_VALUE	总市值
MARKET_VALUE	涨跌幅
CHG_PCT	日换手率
TURNOVER_RATE	市净率
UPDATE_TIME	更新时间

样本数据

ID	SECURITY_ID	TICKER_SYMBOL	EXCHANGE_CD	TRADE_DATE	PRE_CLOSE_PRICE	ACT_PRE_CLOSE_PRICE	OPEN_PRICE	HIGHEST_PRICE	LOWEST_PRICE	CLOSE_PRICE	TURNOVER_VOL	TURNOVER_VALUE	DEAL_AMOUNT	PE	PE1	PB	NEG_MARKET_VALUE	MARKET_VALUE	CHG_PCT	TURNOVER_RATE	UPDATE_TIME
自增ID	证券内部ID	证券代码	交易市场代码	交易日	昨收盘	实际昨收盘	今开盘	最高价	最低价	今收盘	成交量	成交金额	成交笔数	市盈率TTM	动态市盈率	流通市值	总市值	涨跌幅	日换手率	市净率	更新时间
15726798	240	000600	XSHE	2023-10-09	5.700	5.700	5.700	5.790	5.680	5.760	14320156	82400596.020	21434	41.8907	61.2225	1.0480	6278647104.0000	10319768064.0000	0.0105	0.0131	2023-10-09 15:05:03.120
15726799	241	000601	XSHE	2023-10-09	4.220	4.220	4.200	4.290	4.190	4.240	6973964	29630067.640	13189	-27.3619	54.6751	0.9986	4578610216.0000	4581538784.0000	0.0047	0.0065	2023-10-09 15:05:03.120
15726800	243	000603	XSHE	2023-10-09	14.410	14.410	14.250	14.670	13.860	14.490	11226199	159606154.120	13445	31.0337	81.7431	3.2802	8531852553.0000	9997655157.0000	0.0056	0.0191	2023-10-09 15:05:03.120
15726801	244	000605	XSHE	2023-10-09	6.140	6.140	6.170	6.180	5.900	5.930	6765140	40535405.600	12027	175.5218	87.0351	0.9886	2002227141.0000	2091265498.0000	-0.0342	0.0200	2023-10-09 15:05:03.123
15726802	246	000607	XSHE	2023-10-09	4.740	4.740	4.740	4.740	4.500	4.590	14995569	68742787.500	8634	46.9645	41.3935	2.8741	4061772702.0000	4671235656.0000	-0.0316	0.0169	2023-10-09 15:05:03.123
15726803	247	000608	XSHE	2023-10-09	2.890	2.890	2.870	2.910	2.760	2.780	12226600	34265933.000	14479	-5.5893	-47.2319	0.7866	2084758974.0000	2084758974.0000	-0.0381	0.0163	2023-10-09 15:05:03.123
15726804	248	000609	XSHE	2023-10-09	5.450	5.450	5.450	5.450	5.210	5.270	15273200	80479525.000	14714	-5.6494	-15.8765	3.0166	1539311665.0000	1577129185.0000	-0.0330	0.0523	2023-10-09 15:05:03.123
15726805	249	000610	XSHE	2023-10-09	16.190	16.190	15.810	15.820	15.000	15.060	17531950	264824364.200	24806	-21.0746	-35.4712	5.9366	3546387534.0000	3565423374.0000	-0.0698	0.0745	2023-10-09 15:05:03.123
15726806	251	000612	XSHE	2023-10-09	5.140	5.140	5.150	5.180	5.110	5.140	4888600	25137089.000	9506	117.8153	23.2264	1.1460	6123899314.0000	6127904916.0000	0.0000	0.0041	2023-10-09 15:05:03.123
15726807	254	000615	XSHE	2023-10-09	4.280	4.280	4.260	4.490	4.230	4.490	22104702	97210462.880	6936	-2.2154	-41.5841	-16.9122	3420348198.0000	3425778853.0000	0.0491	0.0290	2023-10-09 15:05:03.123
15726808	256	000617	XSHE	2023-10-09	6.620	6.620	6.610	6.610	6.430	6.500	56583231	367184764.010	27157	15.4795	10.5164	0.8313	82173514150.0000	82173514150.0000	-0.0181	0.0045	2023-10-09 15:05:03.123
15726809	258	000619	XSHE	2023-10-09	6.390	6.390	6.390	6.410	6.090	6.130	7223200	44489174.000	13970	-25.3760	-398.0477	0.9978	2206800000.0000	2206800000.0000	-0.0407	0.0201	2023-10-09 15:05:03.123
15726810	259	000620	XSHE	2023-10-09	1.640	1.640	1.630	1.640	1.580	1.590	18862500	30267023.800	2607	-0.8274	-1.2341	-1.8331	3015632478.0000	3015737736.0000	-0.0305	0.0099	2023-10-09 15:05:03.123
15726811	260	000622	XSHE	2023-10-09	4.520	4.520	4.740	4.740	4.490	4.610	68282377	314364110.430	32244	-270.2028	-530.6803	10.1852	1960291860.0000	1960291860.0000	0.0199	0.1606	2023-10-09 15:05:03.123
15726812	261	000623	XSHE	2023-10-09	17.260	17.260	17.160	17.240	16.880	17.160	11444476	195226754.710	22807	8.4961	9.3864	0.7417	19893778476.0000	19958885232.0000	-0.0058	0.0099	2023-10-09 15:05:03.123
15726813	262	000625	XSHE	2023-10-09	13.440	13.440	14.000	14.090	13.600	13.930	234462659	3260476788.170	185897	14.4026	9.0276	2.0335	106538491297.0000	138176169390.0000	0.0365	0.0307	2023-10-09 15:05:03.123
15726814	263	200625	XSHE	2023-10-09	3.610	3.610	3.610	3.660	3.610	3.650	3562359	12987371.510	1586	3.7738	2.3655	0.5328	5991894020.0000	36205528950.0000	0.0111	0.0022	2023-10-09 15:05:03.123
15726815	264	000626	XSHE	2023-10-09	7.120	7.120	7.100	7.110	6.880	6.900	4362000	30330832.000	8141	66.9160	2356.4221	1.1564	3463657860.0000	3511689450.0000	-0.0309	0.0087	2023-10-09 15:05:03.123
15726816	265	000627	XSHE	2023-10-09	3.120	3.120	3.120	3.120	3.050	3.090	30126914	92693989.980	21083	-170.5994	-40.7332	0.7301	14067237978.0000	15266544228.0000	-0.0096	0.0066	2023-10-09 15:05:03.123
15726817	266	000628	XSHE	2023-10-09	16.330	16.330	0.000	0.000	0.000	16.330	0	0.000	0	25.6511	30.8249	3.1391	3136568420.0000	5752732400.0000	0.0000	0.0000	2023-10-09 15:05:03.123
15726818	267	000629	XSHE	2023-10-09	3.680	3.680	3.680	3.680	3.580	3.600	43668861	157848551.940	17470	38.2810	27.7432	2.8556	30922547760.0000	33462119520.0000	-0.0217	0.0051	2023-10-09 15:05:03.123
15726819	268	000630	XSHE	2023-10-09	3.190	3.190	3.190	3.230	3.140	3.220	103386548	330077908.700	44582	14.7435	14.2742	1.5489	33894950362.0000	40787772200.0000	0.0094	0.0098	2023-10-09 15:05:03.127
15726820	269	000631	XSHE	2023-10-09	2.790	2.790	2.800	2.810	2.750	2.750	8133142	22514631.500	9751	50.0037	59.9389	1.1750	6587017525.0000	6587017525.0000	-0.0143	0.0034	2023-10-09 15:05:03.127
15726821	270	000632	XSHE	2023-10-09	4.220	4.220	4.220	4.290	4.180	4.210	11908700	50257045.000	14164	119.6367	84.2116	1.3561	1959677536.0000	1959837516.0000	-0.0024	0.0256	2023-10-09 15:05:03.127
15726822	271	000633	XSHE	2023-10-09	7.610	7.610	7.550	7.710	7.370	7.680	22984479	173415702.900	15760	1262.2237	518.8570	16.7438	2957594112.0000	2957616384.0000	0.0092	0.0597	2023-10-09 15:05:03.127
15726823	272	000635	XSHE	2023-10-09	8.590	8.590	8.760	8.760	8.480	8.500	2113031	18047743.500	7088	-3.9884	-4.3349	1.3104	2576244600.0000	2583735650.0000	-0.0105	0.0070	2023-10-09 15:05:03.127
15726824	273	000636	XSHE	2023-10-09	14.690	14.690	14.630	14.860	14.540	14.780	6814001	100208699.640	15030	388.4103	100.5120	1.4283	15939888582.0000	17100655096.0000	0.0061	0.0063	2023-10-09 15:05:03.127
15726825	274	000637	XSHE	2023-10-09	4.160	4.160	4.200	4.350	4.080	4.310	18040607	76058187.680	6822	-11.4839	-21.7318	2.7060	1586141633.0000	2240662974.0000	0.0361	0.0490	2023-10-09 15:05:03.127
15726826	275	000638	XSHE	2023-10-09	6.220	6.220	6.230	6.330	6.050	6.060	7665400	46839216.000	8786	769.9601	-101.4540	10.8522	1871174076.0000	1878694536.0000	-0.0257	0.0248	2023-10-09 15:05:03.127
15726827	276	000639	XSHE	2023-10-09	4.210	4.210	4.210	4.210	4.130	4.160	5021596	20919705.240	9426	-6.8534	-43.7996	1.3460	4490415488.0000	4490420896.0000	-0.0119	0.0047	2023-10-09 15:05:03.127
15726828	277	000650	XSHE	2023-10-09	7.150	7.150	7.130	7.140	6.980	7.040	34755097	244963101.290	29562	15.6183	13.8208	1.6942	9449925760.0000	9855565632.0000	-0.0154	0.0259	2023-10-09 15:05:03.127
15726829	278	000651	XSHE	2023-10-09	36.300	36.300	36.200	36.770	35.840	36.600	24756794	901912870.600	38885	8.0156	8.1317	1.9573	204672280080.0000	206109448620.0000	0.0083	0.0044	2023-10-09 15:05:03.127
15726797	239	000599	XSHE	2023-10-09	4.370	4.370	4.380	4.480	4.370	4.430	9901300	43808535.000	14727	-8.3393	-13.7707	1.6528	3618094851.0000	3618241927.0000	0.0137	0.0121	2023-10-09 15:05:03.120
15726796	238	000598	XSHE	2023-10-09	5.360	5.360	5.350	5.380	5.310	5.310	9151300	48758842.000	13580	9.7480	9.3586	1.0362	15763140153.0000	15853357053.0000	-0.0093	0.0031	2023-10-09 15:05:03.120
15726795	237	000597	XSHE	2023-10-09	5.250	5.250	5.250	5.280	5.190	5.240	7699529	40255865.920	12366	20.1800	27.8598	1.6210	7199918772.0000	7515817412.0000	-0.0019	0.0056	2023-10-09 15:05:03.120
15726794	236	200596	XSHE	2023-10-09	131.000	131.000	131.000	131.830	128.880	128.880	169559	22012808.770	1226	17.0153	12.2552	3.4556	15465600000.0000	68125968000.0000	-0.0162	0.0014	2023-10-09 15:05:03.120
15726793	235	000596	XSHE	2023-10-09	271.800	271.800	271.850	274.690	267.040	272.230	1282081	346963351.800	8136	35.9411	25.8863	7.2992	111233178000.0000	143900778000.0000	0.0016	0.0031	2023-10-09 15:05:03.120
15726792	234	000595	XSHE	2023-10-09	5.370	5.370	5.370	5.390	5.340	5.390	5915702	31796544.740	2812	-65.1546	-99.2951	9.6605	6134993403.0000	6137357996.0000	0.0037	0.0052	2023-10-09 15:05:03.120
15726791	232	000593	XSHE	2023-10-09	7.280	7.280	7.300	7.460	7.250	7.310	9698537	70899517.100	17098	40.7367	37.8935	2.3330	2620315553.0000	2621592610.0000	0.0041	0.0271	2023-10-09 15:05:03.120
15726790	231	000592	XSHE	2023-10-09	2.470	2.470	2.470	2.480	2.430	2.450	55269926	135466443.110	16638	-21.5028	226.1610	1.9902	4689145405.0000	4732863205.0000	-0.0081	0.0289	2023-10-09 15:05:03.120