SQL: SELECT * FROM this ORDER BY _id_ ASC || 上櫃股票行情

本站大部份資料在 2016 年後就未更新，若資料內無明確標示資料時間，請預設該資料為過時資料並斟酌使用，謝謝

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
717427	PU群益	0.19	+0.02	0.15	0.21	0.15	0.18	229,000	41,130	13	0.19	0.20	5,000,000	0.19	0.94	0.01
717428	統一V8	0.19	+0.04	0.19	0.19	0.19	0.19	168,000	31,920	1	0.18	0.19	5,000,000	0.19	0.64	0.01
717429	康和YM	0.10	-0.08	0.10	0.11	0.10	0.10	600,000	61,000	6	0.05	0.13	20,000,000	0.10	0.54	0.01
71742P	凱基ZV	---	---	---	---	---	1.03	0	0	0	0.99	1.09	5,000,000	0.99	1.41	0.57
717430	康和ZA	---	---	---	---	---	1.68	0	0	0	1.25	1.30	5,000,000	1.25	2.21	0.29
717431	康和ZB	---	---	---	---	---	0.24	0	0	0	0.05	0.15	5,000,000	0.15	0.84	0.01
717432	日盛WB	---	---	---	---	---	2.07	0	0	0	1.25	1.29	5,000,000	1.25	2.28	0.22
717433	日盛WC	0.06	-0.07	0.06	0.06	0.06	0.06	100,000	6,000	1	0.10	0.11	5,000,000	0.06	0.75	0.01
717434	日盛WD	0.07	-0.02	0.07	0.07	0.07	0.07	297,000	20,790	6	0.08	0.09	5,000,000	0.07	0.75	0.01
717435	QZ元大	0.10	-0.13	0.10	0.10	0.10	0.10	77,000	7,700	1	0.08	0.09	5,000,000	0.10	1.02	0.01
717436	VJ兆豐	0.10	+0.01	0.10	0.10	0.10	0.10	10,000	1,000	1	0.09	0.10	5,000,000	0.10	0.67	0.01
717437	VK兆豐	0.34	-0.07	0.32	0.34	0.32	0.33	30,000	9,800	2	0.33	0.34	5,000,000	0.34	1.20	0.01
717438	XA永豐	---	---	---	---	---	0.17	0	0	0	0.11	0.12	5,000,000	0.11	0.60	0.01
717439	XB永豐	---	---	---	---	---	0.21	0	0	0	0.21	0.22	5,000,000	0.21	0.91	0.01
71743P	元富U5	0.57	+0.20	0.57	0.57	0.57	0.57	1,000	570	1	0.59	0.60	5,000,000	0.57	1.42	0.01
717440	XC永豐	0.26	-0.24	0.27	0.27	0.25	0.26	149,000	38,290	6	0.25	0.26	5,000,000	0.26	0.89	0.01
717441	XD永豐	1.12	+0.17	0.86	1.16	0.86	1.08	251,000	271,620	11	1.08	1.12	11,000,000	1.12	1.89	0.33
717442	XE永豐	---	---	---	---	---	0.25	0	0	0	0.00	0.01	11,000,000	0.01	0.62	0.01
717443	XF永豐	---	---	---	---	---	1.70	0	0	0	1.16	1.23	13,000,000	1.16	2.13	0.19
717444	XG永豐	---	---	---	---	---	0.31	0	0	0	0.20	0.21	12,000,000	0.21	1.14	0.01
717445	TN第一	---	---	---	---	---	2.30	0	0	0	2.00	2.10	5,000,000	2.02	2.96	1.08
717446	國泰RM	0.18	-0.07	0.22	0.22	0.11	0.15	186,000	28,220	8	0.20	0.21	5,000,000	0.18	1.33	0.01
717447	PV群益	---	---	---	---	---	0.12	0	0	0	0.03	0.04	5,000,000	0.04	1.12	0.01
717448	PW群益	0.10	-0.01	0.07	0.10	0.07	0.08	25,000	1,900	2	0.08	0.09	10,000,000	0.10	1.35	0.01
717449	PX群益	0.59	-0.11	0.45	0.61	0.45	0.54	725,000	389,250	19	0.62	0.65	7,000,000	0.59	1.48	0.01
71744P	元大PQ	---	---	---	---	---	0.56	0	0	0	0.74	0.76	5,000,000	0.74	1.16	0.32
717450	統一V9	4.71	+0.03	3.97	4.71	3.89	4.05	59,000	238,970	6	4.67	4.76	5,000,000	4.71	5.50	3.90
717451	UJ凱基	---	---	---	---	---	0.22	0	0	0	0.06	0.11	5,000,000	0.11	0.59	0.01
717452	UK凱基	0.14	+0.02	0.14	0.14	0.14	0.14	100,000	14,000	1	0.14	0.15	5,000,000	0.14	0.74	0.01
717453	國票QM	---	---	---	---	---	2.23	0	0	0	1.87	1.88	5,000,000	1.87	3.25	0.49
717454	日盛WE	2.17	-0.54	1.95	2.20	1.95	2.07	199,000	412,770	3	2.00	2.05	5,000,000	2.17	3.42	0.92
717455	日盛WF	0.47	+0.02	0.46	0.47	0.46	0.46	51,000	23,470	2	0.46	0.47	5,000,000	0.47	1.11	0.01
717456	日盛WG	---	---	---	---	---	8.45	0	0	0	0.00	0.00	5,000,000	16.00	18.00	14.00
717457	日盛WH	---	---	---	---	---	0.15	0	0	0	0.10	0.11	5,000,000	0.11	0.72	0.01
717458	RA元大	---	---	---	---	---	0.16	0	0	0	0.00	0.00	5,000,000	0.11	0.65	0.01
717459	RB元大	---	---	---	---	---	0.07	0	0	0	0.04	0.05	5,000,000	0.05	0.57	0.01
71745P	元大W7	0.86	+0.38	0.83	0.86	0.83	0.85	3,000	2,550	2	0.83	0.86	5,000,000	0.86	1.77	0.01
717460	RC元大	---	---	---	---	---	11.40	0	0	0	0.00	19.00	5,000,000	19.00	22.00	16.00
717461	RG元大	0.09	-0.02	0.10	0.11	0.09	0.10	199,000	20,230	4	0.08	0.09	5,000,000	0.09	0.95	0.01
717462	RH元大	---	---	---	---	---	0.12	0	0	0	0.03	0.13	5,000,000	0.11	0.71	0.01
717463	RK元大	0.20	+0.06	0.13	0.20	0.11	0.18	115,000	20,800	5	0.20	0.21	5,000,000	0.20	0.76	0.01
717464	P8富邦	0.17	+0.01	0.09	0.17	0.09	0.09	21,000	1,970	2	0.14	0.17	5,000,000	0.17	0.87	0.01
717465	P9富邦	---	---	---	---	---	3.55	0	0	0	1.31	1.41	10,000,000	1.41	2.29	0.53
717466	Q1富邦	---	---	---	---	---	0.07	0	0	0	0.02	0.05	10,000,000	0.05	0.71	0.01
717467	Q2富邦	---	---	---	---	---	0.06	0	0	0	0.06	0.07	10,000,000	0.06	0.86	0.01
717468	Q3富邦	---	---	---	---	---	12.85	0	0	0	12.70	13.50	5,000,000	13.00	15.20	10.80
717469	Q4富邦	---	---	---	---	---	0.13	0	0	0	0.01	0.05	10,000,000	0.05	0.55	0.01
71746P	元大W8	---	---	---	---	---	0.29	0	0	0	0.00	0.02	6,000,000	0.02	1.34	0.01
717470	元富RG	0.17	-0.12	0.17	0.17	0.17	0.17	20,000	3,400	1	0.18	0.20	5,000,000	0.17	0.81	0.01
717471	元富RJ	---	---	---	---	---	1.61	0	0	0	1.40	1.42	5,000,000	1.42	2.45	0.39
717472	XJ永豐	---	---	---	---	---	0.07	0	0	0	0.04	0.05	11,000,000	0.05	0.61	0.01
717473	XK永豐	---	---	---	---	---	1.34	0	0	0	1.24	1.31	12,000,000	1.31	2.12	0.50
717474	XL永豐	---	---	---	---	---	0.10	0	0	0	0.07	0.11	5,000,000	0.10	0.83	0.01
717475	XM永豐	---	---	---	---	---	0.03	0	0	0	0.01	0.02	5,000,000	0.02	0.51	0.01
717476	XN永豐	---	---	---	---	---	12.40	0	0	0	9.90	10.70	5,000,000	9.95	11.80	8.05
717477	XP永豐	0.22	-0.08	0.13	0.22	0.13	0.16	654,000	104,060	10	0.21	0.22	11,000,000	0.22	1.09	0.01
717478	XQ永豐	---	---	---	---	---	0.14	0	0	0	0.08	0.09	11,000,000	0.09	0.57	0.01
717479	TP第一	---	---	---	---	---	11.10	0	0	0	17.20	18.10	5,000,000	17.40	20.90	13.90
71747P	國泰TO	---	---	---	---	---	3.25	0	0	0	3.41	0.00	5,000,000	3.41	4.12	2.70
717480	國泰RN	0.07	0.00	0.07	0.07	0.07	0.07	8,000	560	1	0.02	0.07	5,000,000	0.07	0.67	0.01
717481	國泰RP	---	---	---	---	---	24.20	0	0	0	0.00	0.00	5,000,000	21.80	24.80	18.80
717482	PY群益	0.49	-0.15	0.49	0.49	0.49	0.49	10,000	4,900	1	0.52	0.61	10,000,000	0.49	1.43	0.01
717483	統一W1	---	---	---	---	---	0.35	0	0	0	0.32	0.37	15,000,000	0.35	1.21	0.01
717484	統一W2	---	---	---	---	---	6.70	0	0	0	6.95	7.35	5,000,000	6.95	8.25	5.65
717485	UL凱基	---	---	---	---	---	0.12	0	0	0	0.12	0.13	5,000,000	0.12	0.56	0.01
717486	UM凱基	---	---	---	---	---	0.17	0	0	0	0.12	0.17	5,000,000	0.17	1.02	0.01
717487	UN凱基	---	---	---	---	---	0.27	0	0	0	0.24	0.28	5,000,000	0.28	1.16	0.01
717488	TQ第一	5.55	-1.15	5.55	5.55	5.55	5.55	9,000	49,950	1	6.50	6.95	5,000,000	5.55	6.75	4.33
717489	國票QN	0.14	+0.01	0.08	0.14	0.08	0.12	1,589,000	197,560	51	0.13	0.14	13,000,000	0.14	0.78	0.01
71748P	康和XC	---	---	---	---	---	0.06	0	0	0	0.00	0.01	5,000,000	0.01	0.86	0.01
717490	國票QP	---	---	---	---	---	0.46	0	0	0	0.24	0.25	5,000,000	0.25	0.97	0.01
717491	XR永豐	---	---	---	---	---	3.52	0	0	0	2.65	2.75	5,000,000	2.72	3.85	1.59
717492	XS永豐	---	---	---	---	---	0.09	0	0	0	0.04	0.05	5,000,000	0.05	0.58	0.01
717493	XT永豐	---	---	---	---	---	6.70	0	0	0	7.95	8.40	5,000,000	8.10	9.50	6.70
717494	日盛WJ	0.86	-0.26	0.87	0.87	0.86	0.86	20,000	17,300	2	0.86	0.96	5,000,000	0.86	1.86	0.01
717495	日盛WK	0.27	-0.04	0.27	0.28	0.27	0.27	28,000	7,660	3	0.21	0.24	5,000,000	0.27	1.52	0.01
717496	日盛WL	---	---	---	---	---	3.12	0	0	0	1.74	1.83	12,000,000	1.83	3.15	0.51
717497	日盛WM	0.70	-0.53	0.70	0.70	0.70	0.70	10,000	7,000	1	0.50	0.69	12,000,000	0.70	1.69	0.01
717498	統一W3	0.57	-0.13	0.51	0.60	0.51	0.56	264,000	147,230	7	0.56	0.57	13,000,000	0.57	1.41	0.01
717499	元富RK	---	---	---	---	---	10.20	0	0	0	7.50	8.00	5,000,000	7.75	9.05	6.45
71749P	富邦VH	---	---	---	---	---	0.06	0	0	0	0.01	0.05	10,000,000	0.05	0.96	0.01
717500	國泰RR	0.81	+0.01	0.75	0.81	0.75	0.78	291,000	227,810	4	0.79	0.87	5,000,000	0.81	2.17	0.01
717501	VL兆豐	---	---	---	---	---	0.41	0	0	0	0.19	0.20	5,000,000	0.20	0.89	0.01
717502	VM兆豐	---	---	---	---	---	0.15	0	0	0	0.04	0.07	5,000,000	0.07	0.76	0.01
717503	UP凱基	0.20	0.00	0.16	0.24	0.16	0.20	482,000	95,440	11	0.17	0.18	5,000,000	0.20	0.84	0.01
717504	RM元大	---	---	---	---	---	20.40	0	0	0	0.00	0.00	5,000,000	17.10	20.10	14.10
717505	RS元大	---	---	---	---	---	0.06	0	0	0	0.01	0.02	5,000,000	0.02	0.50	0.01
717506	RX元大	---	---	---	---	---	2.66	0	0	0	2.01	2.11	5,000,000	2.11	3.67	0.55
717507	RY元大	---	---	---	---	---	6.75	0	0	0	0.00	11.70	5,000,000	11.70	13.70	9.70
717508	RZ元大	0.01	-0.01	0.01	0.01	0.01	0.01	100,000	1,000	1	0.01	0.02	5,000,000	0.01	0.68	0.01
717509	日盛WN	0.33	-0.18	0.33	0.33	0.33	0.33	41,000	13,530	1	0.37	0.38	5,000,000	0.33	1.29	0.01
71750P	元大QB	---	---	---	---	---	0.05	0	0	0	0.02	0.03	5,000,000	0.03	0.72	0.01
717510	日盛WP	0.19	+0.02	0.19	0.19	0.19	0.19	1,000	190	1	0.15	0.18	5,000,000	0.19	0.66	0.01
717511	國泰RS	1.11	-0.01	0.37	1.11	0.37	0.49	351,000	170,960	21	1.11	0.00	5,000,000	1.11	2.17	0.05
717512	QA群益	0.28	-0.03	0.21	0.28	0.21	0.24	20,000	4,900	2	0.26	0.29	5,000,000	0.28	1.12	0.01
717513	統一W4	0.21	-0.04	0.16	0.22	0.16	0.19	178,000	33,040	8	0.20	0.21	5,000,000	0.21	0.87	0.01
717514	元富RL	---	---	---	---	---	0.21	0	0	0	0.06	0.07	10,000,000	0.07	0.73	0.01
717515	元富RM	0.03	-0.01	0.04	0.04	0.03	0.03	299,000	8,990	2	0.02	0.05	10,000,000	0.03	0.83	0.01
717516	元富RN	0.33	+0.01	0.17	0.34	0.16	0.26	890,000	230,800	40	0.32	0.35	5,000,000	0.33	0.95	0.01
717517	康和ZD	---	---	---	---	---	0.47	0	0	0	0.06	0.12	5,000,000	0.10	0.50	0.01