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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
723188	TS國泰	0.91	-0.06	0.91	0.91	0.91	0.91	30,000	27,300	2	0.94	0.95	5,000,000	0.91	1.67	0.15
723189	康和TX	---	---	---	---	---	0.11	0	0	0	0.10	0.11	5,000,000	0.11	0.41	0.01
723190	WJ凱基	---	---	---	---	---	0.34	0	0	0	0.32	0.33	5,000,000	0.33	0.85	0.01
723191	兆豐VM	---	---	---	---	---	0.37	0	0	0	0.35	0.36	5,000,000	0.36	1.39	0.01
723192	兆豐VN	1.37	+0.02	1.35	1.42	1.35	1.36	62,000	84,460	5	1.32	1.33	5,000,000	1.37	3.26	0.01
723193	兆豐VP	1.11	+0.02	1.16	1.17	1.10	1.13	189,000	213,800	8	1.10	0.00	5,000,000	1.11	2.41	0.01
723194	兆豐VQ	---	---	---	---	---	0.27	0	0	0	0.25	0.26	5,000,000	0.26	0.81	0.01
723195	兆豐VR	---	---	---	---	---	0.18	0	0	0	0.17	0.18	5,000,000	0.18	0.48	0.01
723196	兆豐VS	---	---	---	---	---	0.75	0	0	0	0.71	0.72	5,000,000	0.72	1.19	0.25
723197	U8日盛	---	---	---	---	---	0.19	0	0	0	0.18	0.19	5,000,000	0.19	0.62	0.01
723198	U9日盛	0.29	0.00	0.29	0.29	0.29	0.29	10,000	2,900	1	0.29	0.32	5,000,000	0.29	0.45	0.13
723199	YL元富	---	---	---	---	---	0.14	0	0	0	0.22	0.23	5,000,000	0.23	0.61	0.01
72319P	富邦RK	---	---	---	---	---	0.15	0	0	0	0.04	0.09	5,000,000	0.09	1.17	0.01
723200	YM元富	---	---	---	---	---	0.23	0	0	0	0.32	0.33	5,000,000	0.33	0.84	0.01
723201	兆豐VT	---	---	---	---	---	0.59	0	0	0	0.62	0.63	5,000,000	0.62	1.43	0.01
723202	兆豐VU	---	---	---	---	---	0.43	0	0	0	0.13	0.14	5,000,000	0.14	1.08	0.01
723203	國票VD	0.15	-0.09	0.18	0.18	0.14	0.15	512,000	75,700	11	0.15	0.16	5,000,000	0.15	0.66	0.01
723204	WK凱基	1.06	-0.06	1.06	1.06	1.06	1.06	74,000	78,440	1	1.06	1.08	10,000,000	1.06	1.77	0.35
723205	WL凱基	1.17	+0.16	1.00	1.17	1.00	1.08	1,880,000	2,021,470	33	1.17	1.19	5,000,000	1.17	1.83	0.51
723248	永豐VE	---	---	---	---	---	0.32	0	0	0	0.19	0.20	9,500,000	0.20	0.89	0.01
723206	WM凱基	0.52	-0.02	0.52	0.52	0.52	0.52	198,000	102,960	2	0.48	0.49	5,000,000	0.52	1.07	0.01
723207	台新V6	0.20	-0.01	0.20	0.20	0.20	0.20	50,000	10,000	1	0.20	0.21	5,000,000	0.20	0.43	0.01
723208	台新V7	---	---	---	---	---	0.51	0	0	0	0.51	0.52	5,000,000	0.51	0.98	0.04
723209	玉山X6	0.21	+0.03	0.21	0.21	0.21	0.21	10,000	2,100	1	0.20	0.21	5,000,000	0.21	0.69	0.01
723210	玉山X7	---	---	---	---	---	0.77	0	0	0	0.66	0.69	5,000,000	0.69	1.24	0.14
723211	T1群益	---	---	---	---	---	0.86	0	0	0	0.81	0.82	5,000,000	0.82	1.39	0.25
723212	T2群益	1.64	-0.10	1.72	1.72	1.62	1.66	67,000	111,500	5	1.55	1.56	10,000,000	1.64	2.76	0.52
723213	元大PT	0.32	+0.02	0.31	0.32	0.31	0.32	355,000	112,500	6	0.31	0.32	5,000,000	0.32	1.04	0.01
723214	元大WP	0.61	-0.07	0.70	0.70	0.59	0.62	559,000	345,250	23	0.59	0.60	5,000,000	0.61	1.45	0.01
723215	元大WY	0.98	+0.06	0.97	1.00	0.96	0.98	1,221,000	1,195,460	32	0.97	0.98	5,000,000	0.98	1.58	0.38
723216	永豐US	1.25	-0.04	1.20	1.25	1.19	1.20	70,000	84,300	3	1.24	1.26	5,000,000	1.25	1.97	0.53
723217	永豐UT	---	---	---	---	---	0.68	0	0	0	0.63	0.64	12,000,000	0.64	1.27	0.01
723218	永豐UU	0.63	-0.04	0.63	0.63	0.63	0.63	25,000	15,750	1	0.65	0.66	5,000,000	0.63	1.01	0.25
723219	永豐UV	0.81	-0.02	0.82	0.82	0.81	0.82	90,000	73,400	2	0.81	0.82	11,000,000	0.81	1.80	0.01
723220	V1日盛	---	---	---	---	---	0.47	0	0	0	0.47	0.48	6,000,000	0.48	1.32	0.01
723221	TT國泰	0.68	+0.02	0.68	0.68	0.68	0.68	10,000	6,800	1	0.71	0.72	5,000,000	0.68	0.84	0.52
723222	永昌ZP	---	---	---	---	---	0.91	0	0	0	0.82	0.91	5,000,000	0.91	1.54	0.28
723223	永昌ZQ	0.83	-0.07	0.83	0.83	0.83	0.83	15,000	12,450	1	0.85	0.86	5,000,000	0.83	1.27	0.39
723224	富邦UG	---	---	---	---	---	0.43	0	0	0	0.35	0.36	5,000,000	0.36	1.78	0.01
723225	富邦UH	1.18	-0.08	1.28	1.29	1.18	1.25	765,000	958,430	51	1.14	1.17	5,000,000	1.18	2.50	0.01
723226	台新V8	---	---	---	---	---	0.93	0	0	0	0.85	0.86	5,000,000	0.85	1.42	0.28
723227	永豐UW	0.55	-0.04	0.54	0.55	0.54	0.54	11,000	5,950	2	0.53	0.54	11,000,000	0.55	1.05	0.05
723228	永豐UX	---	---	---	---	---	0.31	0	0	0	0.27	0.29	12,000,000	0.29	0.61	0.01
723229	永豐UY	---	---	---	---	---	0.42	0	0	0	0.39	0.40	14,000,000	0.39	0.81	0.01
72322P	QL國泰	---	---	---	---	---	0.95	0	0	0	0.87	0.96	5,000,000	0.96	1.44	0.48
723230	永豐UZ	---	---	---	---	---	0.37	0	0	0	0.35	0.36	14,000,000	0.36	0.75	0.01
723231	永豐VA	0.40	-0.01	0.40	0.40	0.40	0.40	158,000	63,200	2	0.38	0.39	11,000,000	0.40	0.89	0.01
723232	永豐VB	---	---	---	---	---	0.10	0	0	0	0.07	0.09	11,000,000	0.09	0.50	0.01
723233	PC元大	---	---	---	---	---	1.43	0	0	0	1.19	1.22	5,000,000	1.22	1.99	0.45
723234	PF元大	1.04	+0.04	1.07	1.09	1.02	1.06	948,000	1,008,200	23	1.03	1.04	5,000,000	1.04	2.01	0.07
723235	PH元大	1.33	+0.01	1.31	1.33	1.31	1.32	110,000	145,520	4	1.32	1.34	5,000,000	1.33	2.02	0.64
723236	PP元大	0.72	-0.10	0.82	0.82	0.72	0.77	1,883,000	1,445,610	34	0.71	0.72	5,000,000	0.72	1.28	0.16
723237	PU元大	0.93	+0.01	0.95	0.97	0.91	0.93	575,000	534,700	15	0.90	0.93	5,000,000	0.93	1.74	0.12
723238	PX元大	0.15	-0.01	0.15	0.15	0.15	0.15	32,000	4,800	1	0.14	0.15	5,000,000	0.15	0.58	0.01
723239	PZ元大	0.47	-0.06	0.47	0.47	0.46	0.47	64,000	30,060	4	0.45	0.46	5,000,000	0.47	1.31	0.01
72323P	QS群益	---	---	---	---	---	0.42	0	0	0	0.13	0.14	5,000,000	0.14	0.86	0.01
723240	康和TZ	0.11	-0.01	0.11	0.11	0.11	0.11	100,000	11,000	1	0.10	0.11	5,000,000	0.11	0.45	0.01
723241	WN凱基	---	---	---	---	---	0.29	0	0	0	0.27	0.28	5,000,000	0.27	0.93	0.01
723242	WP凱基	2.30	-0.25	2.32	2.38	2.21	2.32	77,000	178,270	7	2.41	2.44	5,000,000	2.30	3.95	0.65
723243	V2日盛	0.85	-0.07	0.85	0.85	0.85	0.85	20,000	17,000	1	0.86	0.88	20,000,000	0.85	1.40	0.30
723244	V3日盛	0.31	-0.04	0.31	0.31	0.31	0.31	84,000	26,040	2	0.31	0.32	20,000,000	0.31	1.00	0.01
723245	統一W3	1.17	+0.18	0.98	1.17	0.98	1.05	5,966,000	6,255,350	64	1.16	1.19	5,000,000	1.17	1.72	0.62
723246	永豐VC	---	---	---	---	---	0.85	0	0	0	0.36	0.37	5,000,000	0.36	0.98	0.01
723247	永豐VD	1.04	-0.09	1.03	1.04	0.95	1.00	1,013,000	1,014,220	37	1.03	1.04	5,000,000	1.04	1.75	0.33
723249	永豐VF	---	---	---	---	---	0.40	0	0	0	0.35	0.36	11,000,000	0.35	0.85	0.01
723250	永豐VG	---	---	---	---	---	0.55	0	0	0	0.56	0.57	5,000,000	0.56	1.26	0.01
723251	永豐VH	0.52	-0.01	0.49	0.52	0.48	0.49	216,000	106,360	7	0.50	0.51	10,000,000	0.52	1.20	0.01
723252	兆豐VV	---	---	---	---	---	0.53	0	0	0	0.58	0.59	5,000,000	0.58	1.18	0.01
723253	兆豐VW	---	---	---	---	---	0.38	0	0	0	0.20	0.21	5,000,000	0.21	0.49	0.01
723254	富邦UJ	0.47	+0.03	0.47	0.47	0.47	0.47	100,000	47,000	1	0.48	0.49	5,000,000	0.47	1.31	0.01
723255	富邦UK	1.81	-0.07	1.87	1.87	1.79	1.82	32,000	58,300	3	1.80	1.83	5,000,000	1.81	2.68	0.94
723256	YN元富	1.01	+0.19	0.84	1.02	0.83	0.91	1,123,000	1,018,490	46	1.01	1.02	5,000,000	1.01	1.56	0.46
723257	TU國泰	---	---	---	---	---	2.05	0	0	0	1.90	1.91	5,000,000	1.91	2.76	1.06
723258	TV國泰	0.94	-0.05	0.95	0.95	0.94	0.94	10,000	9,420	2	0.94	0.96	5,000,000	0.94	1.78	0.10
723259	QD元大	0.31	0.00	0.31	0.31	0.31	0.31	15,000	4,650	2	0.30	0.31	5,000,000	0.31	0.87	0.01
723260	QE元大	1.33	-0.07	1.34	1.35	1.21	1.30	1,340,000	1,742,480	43	1.31	1.32	5,000,000	1.33	2.04	0.62
723261	QK元大	---	---	---	---	---	2.24	0	0	0	1.81	1.84	5,000,000	1.84	2.59	1.09
723262	T5群益	---	---	---	---	---	0.45	0	0	0	0.44	0.45	5,000,000	0.45	0.99	0.01
723263	T6群益	---	---	---	---	---	0.74	0	0	0	0.65	0.66	10,000,000	0.66	1.47	0.01
723264	T7群益	0.92	-0.09	0.92	0.92	0.92	0.92	2,000	1,840	1	0.95	0.96	5,000,000	0.92	2.01	0.01
723265	YY第一	---	---	---	---	---	1.18	0	0	0	0.34	0.35	10,000,000	0.35	1.04	0.01
723266	YS元富	0.21	-0.02	0.21	0.21	0.21	0.21	4,000	840	4	0.20	0.21	5,000,000	0.21	0.76	0.01
723267	YT元富	---	---	---	---	---	0.36	0	0	0	0.19	0.20	5,000,000	0.20	0.43	0.01
723268	TX國泰	0.36	-0.04	0.40	0.40	0.36	0.37	34,000	12,640	3	0.36	0.37	5,000,000	0.36	1.05	0.01
723269	台新V9	---	---	---	---	---	0.50	0	0	0	0.44	0.45	10,000,000	0.45	0.87	0.03
723270	台新W1	0.61	-0.05	0.63	0.63	0.61	0.63	207,000	130,270	2	0.56	0.58	10,000,000	0.61	1.08	0.14
723271	VG元大	1.71	-0.07	1.69	1.71	1.61	1.62	179,000	290,120	5	1.69	1.72	5,000,000	1.71	2.56	0.86
723272	VJ元大	---	---	---	---	---	0.47	0	0	0	0.46	0.47	5,000,000	0.47	1.20	0.01
723273	VL元大	0.51	-0.06	0.52	0.52	0.51	0.52	643,000	332,920	3	0.52	0.53	5,000,000	0.51	0.92	0.10
723274	VP元大	0.23	-0.03	0.23	0.23	0.23	0.23	10,000	2,300	1	0.21	0.22	5,000,000	0.23	0.64	0.01
723275	VQ元大	0.62	+0.05	0.62	0.62	0.62	0.62	50,000	31,000	1	0.23	0.63	5,000,000	0.62	1.42	0.01
723276	VR元大	0.47	-0.03	0.49	0.49	0.47	0.49	435,000	211,600	5	0.46	0.47	5,000,000	0.47	1.19	0.01
723277	U1群益	---	---	---	---	---	0.45	0	0	0	0.36	0.37	5,000,000	0.37	0.97	0.01
723278	永豐VJ	1.11	-0.06	1.15	1.15	1.08	1.11	726,000	802,970	22	1.10	1.11	11,000,000	1.11	1.85	0.37
723279	V4日盛	---	---	---	---	---	0.19	0	0	0	0.14	0.15	15,000,000	0.15	0.63	0.01
72327P	QU群益	---	---	---	---	---	0.83	0	0	0	0.17	0.18	5,000,000	0.18	1.94	0.01
723280	統一W4	0.50	+0.04	0.50	0.51	0.50	0.50	405,000	204,500	3	0.47	0.48	13,000,000	0.50	0.96	0.04
723281	統一W5	---	---	---	---	---	0.21	0	0	0	0.22	0.23	15,000,000	0.23	0.57	0.01
723282	宏遠P4	---	---	---	---	---	0.88	0	0	0	0.77	0.80	5,000,000	0.80	1.24	0.36
723283	宏遠P5	0.70	+0.01	0.72	0.72	0.70	0.71	65,000	46,100	2	0.67	0.70	5,000,000	0.70	1.22	0.16