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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
716259	國票ZV	---	---	---	---	---	0.23	0	0	0	0.04	0.05	5,000,000	0.05	0.59	0.01
71625P	S7元大	0.62	0.00	0.62	0.62	0.62	0.62	10,000	6,200	1	0.67	0.69	5,000,000	0.62	1.05	0.19
716260	富邦UZ	---	---	---	---	---	0.07	0	0	0	0.00	0.05	5,000,000	0.05	0.50	0.01
716261	富邦VA	0.97	-0.10	0.97	0.97	0.97	0.97	10,000	9,700	1	0.65	0.70	5,000,000	0.97	2.07	0.01
716262	富邦VB	0.84	-0.11	0.84	0.84	0.84	0.84	10,000	8,400	1	0.82	0.85	5,000,000	0.84	1.68	0.01
716263	PN永豐	---	---	---	---	---	0.06	0	0	0	0.00	0.01	5,000,000	0.01	0.59	0.01
716264	PP永豐	0.20	-0.06	0.20	0.20	0.20	0.20	3,000	600	1	0.06	0.09	9,900,000	0.20	1.40	0.01
716265	PQ永豐	---	---	---	---	---	0.39	0	0	0	0.00	0.01	5,000,000	0.01	0.59	0.01
716266	日盛SL	0.01	-0.01	0.01	0.01	0.01	0.01	1,160,000	11,600	17	0.01	0.02	5,000,000	0.01	0.64	0.01
716267	日盛SM	---	---	---	---	---	4.50	0	0	0	3.06	3.15	5,000,000	3.15	4.47	1.83
716268	日盛SN	---	---	---	---	---	0.01	0	0	0	0.00	0.00	5,000,000	0.01	0.49	0.01
716269	日盛SP	---	---	---	---	---	0.01	0	0	0	0.01	0.02	5,000,000	0.01	0.62	0.01
716270	統一YM	---	---	---	---	---	0.17	0	0	0	0.01	0.02	5,000,000	0.02	0.66	0.01
716271	統一YN	---	---	---	---	---	0.01	0	0	0	0.01	0.05	5,000,000	0.01	0.29	0.01
716272	凱基ZQ	---	---	---	---	---	0.06	0	0	0	0.00	0.02	5,000,000	0.02	0.48	0.01
716273	凱基ZR	---	---	---	---	---	0.02	0	0	0	0.00	0.02	5,000,000	0.02	0.39	0.01
716274	凱基ZS	---	---	---	---	---	0.28	0	0	0	0.00	0.02	5,000,000	0.02	0.89	0.01
716275	凱基ZT	---	---	---	---	---	2.81	0	0	0	2.36	2.44	5,000,000	2.36	3.75	0.95
716276	群益UX	---	---	---	---	---	0.06	0	0	0	0.01	0.02	5,000,000	0.02	0.94	0.01
716277	群益UY	0.17	-0.12	0.17	0.17	0.17	0.17	8,000	1,360	1	0.09	0.10	5,000,000	0.17	0.83	0.01
716278	群益UZ	---	---	---	---	---	0.06	0	0	0	0.01	0.02	5,000,000	0.02	0.77	0.01
716279	國票ZW	---	---	---	---	---	2.61	0	0	0	1.61	1.62	10,000,000	1.62	3.29	0.01
716280	富邦VC	---	---	---	---	---	0.59	0	0	0	0.31	0.34	5,000,000	0.34	1.03	0.01
716281	日盛SQ	2.15	-0.30	2.15	2.15	2.15	2.15	19,000	40,850	1	1.67	1.73	5,000,000	2.15	3.03	1.27
716282	日盛SR	0.01	-0.01	0.01	0.01	0.01	0.01	495,000	4,950	1	0.00	0.00	5,000,000	0.01	0.48	0.01
716283	元富U1	---	---	---	---	---	0.24	0	0	0	0.00	0.00	5,000,000	0.04	0.40	0.01
716284	元富U2	---	---	---	---	---	0.13	0	0	0	0.00	0.05	5,000,000	0.05	0.84	0.01
716285	元富U3	---	---	---	---	---	0.26	0	0	0	0.00	0.00	5,000,000	0.04	0.63	0.01
716286	PR永豐	---	---	---	---	---	0.04	0	0	0	0.00	0.01	5,000,000	0.01	0.46	0.01
716287	PS永豐	---	---	---	---	---	0.96	0	0	0	0.44	0.54	5,000,000	0.54	1.87	0.01
716288	PT永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.68	0.01
716289	PU永豐	---	---	---	---	---	0.02	0	0	0	0.01	0.02	5,000,000	0.02	0.59	0.01
716290	PV永豐	---	---	---	---	---	0.10	0	0	0	0.00	0.01	5,000,000	0.01	0.55	0.01
716291	PW永豐	0.02	-0.14	0.08	0.08	0.02	0.05	20,000	1,000	2	0.01	0.02	9,900,000	0.02	0.95	0.01
716292	PX永豐	---	---	---	---	---	0.04	0	0	0	0.01	0.04	5,000,000	0.04	0.70	0.01
716293	PY永豐	---	---	---	---	---	0.04	0	0	0	0.00	0.01	9,900,000	0.01	0.97	0.01
716294	康和XA	---	---	---	---	---	0.01	0	0	0	0.00	0.01	10,000,000	0.01	0.46	0.01
716295	康和XB	---	---	---	---	---	0.49	0	0	0	0.16	0.26	10,000,000	0.26	0.84	0.01
716296	中信UR	---	---	---	---	---	0.05	0	0	0	0.00	0.02	5,000,000	0.02	1.01	0.01
716297	國泰RO	---	---	---	---	---	0.62	0	0	0	0.30	0.78	5,000,000	0.62	1.52	0.01
716298	元大V7	---	---	---	---	---	0.01	0	0	0	0.00	0.02	10,000,000	0.01	0.61	0.01
716299	元大V8	---	---	---	---	---	0.01	0	0	0	0.00	0.01	10,000,000	0.01	0.35	0.01
716300	元大W1	---	---	---	---	---	0.26	0	0	0	0.00	0.02	5,000,000	0.02	0.55	0.01
716301	元大W5	0.36	+0.09	0.36	0.36	0.36	0.36	2,000	720	1	0.00	0.00	5,000,000	0.36	1.76	0.01
716302	群益VA	---	---	---	---	---	0.01	0	0	0	0.00	0.00	5,000,000	0.01	0.52	0.01
716303	群益VB	---	---	---	---	---	0.04	0	0	0	0.01	0.02	10,000,000	0.02	0.51	0.01
716304	群益VC	---	---	---	---	---	0.01	0	0	0	0.00	0.01	10,000,000	0.01	0.20	0.01
716305	群益VD	---	---	---	---	---	0.06	0	0	0	0.02	0.03	5,000,000	0.03	0.43	0.01
716306	群益VE	---	---	---	---	---	1.65	0	0	0	1.49	1.56	5,000,000	1.56	2.15	0.97
716307	統一YP	---	---	---	---	---	0.09	0	0	0	0.01	0.02	5,000,000	0.02	0.64	0.01
716308	統一YQ	---	---	---	---	---	0.11	0	0	0	0.05	0.06	5,000,000	0.06	0.52	0.01
716309	凱基ZW	---	---	---	---	---	0.19	0	0	0	0.00	0.08	5,000,000	0.08	0.87	0.01
716310	凱基ZX	---	---	---	---	---	0.06	0	0	0	0.00	0.01	5,000,000	0.01	0.72	0.01
716311	凱基ZY	1.37	-0.84	1.46	1.46	1.37	1.43	15,000	21,450	2	1.37	1.47	5,000,000	1.37	2.63	0.11
716312	凱基ZZ	---	---	---	---	---	0.01	0	0	0	0.00	0.02	5,000,000	0.01	0.72	0.01
716313	富邦VD	---	---	---	---	---	0.01	0	0	0	0.00	0.02	5,000,000	0.01	0.46	0.01
716314	元富U4	---	---	---	---	---	0.02	0	0	0	0.00	0.00	10,000,000	0.02	0.86	0.01
716315	元大PA	---	---	---	---	---	0.08	0	0	0	0.00	0.00	10,000,000	0.02	0.69	0.01
716316	元大PK	---	---	---	---	---	0.19	0	0	0	0.00	0.02	5,000,000	0.01	0.72	0.01
716317	元大PM	---	---	---	---	---	0.01	0	0	0	0.00	0.00	5,000,000	0.01	0.88	0.01
716318	元大PN	---	---	---	---	---	0.21	0	0	0	0.00	0.02	5,000,000	0.02	0.62	0.01
716319	元大PP	---	---	---	---	---	0.04	0	0	0	0.00	0.02	5,000,000	0.02	1.84	0.01
716320	元大W9	1.31	-0.71	1.31	1.31	1.31	1.31	20,000	26,200	2	0.00	1.45	10,000,000	1.31	2.13	0.49
716321	RZ兆豐	---	---	---	---	---	0.10	0	0	0	0.00	0.02	5,000,000	0.02	0.75	0.01
716322	SA兆豐	---	---	---	---	---	0.04	0	0	0	0.00	0.02	5,000,000	0.02	0.51	0.01
716323	統一YR	0.26	+0.02	0.18	0.32	0.11	0.17	642,000	107,500	56	0.25	0.26	16,000,000	0.26	1.11	0.01
716324	PA凱基	---	---	---	---	---	0.02	0	0	0	0.01	0.02	5,000,000	0.02	0.31	0.01
716325	PB凱基	---	---	---	---	---	0.15	0	0	0	0.04	0.05	5,000,000	0.05	0.52	0.01
716326	PC凱基	---	---	---	---	---	1.83	0	0	0	1.61	1.68	5,000,000	1.68	3.06	0.30
716327	SV第一	---	---	---	---	---	0.10	0	0	0	0.00	0.10	5,000,000	0.10	0.50	0.01
716328	國泰SO	---	---	---	---	---	0.10	0	0	0	0.00	0.10	5,000,000	0.05	0.89	0.01
716329	群益VF	---	---	---	---	---	0.06	0	0	0	0.00	0.00	5,000,000	0.02	1.40	0.01
716330	PZ永豐	---	---	---	---	---	0.02	0	0	0	0.00	0.01	5,000,000	0.01	0.51	0.01
716331	QA永豐	---	---	---	---	---	0.08	0	0	0	0.00	0.01	5,000,000	0.01	0.61	0.01
716332	QB永豐	---	---	---	---	---	0.11	0	0	0	0.00	0.01	11,000,000	0.01	1.36	0.01
716333	QC永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.26	0.01
716334	QD永豐	---	---	---	---	---	1.81	0	0	0	1.69	1.76	5,000,000	1.76	2.81	0.71
716335	QE永豐	---	---	---	---	---	0.42	0	0	0	0.00	0.01	5,000,000	0.01	0.32	0.01
716336	QF永豐	0.02	-0.02	0.02	0.02	0.02	0.02	100,000	2,000	1	0.01	0.03	5,000,000	0.02	0.91	0.01
716337	QG永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.82	0.01
716338	QH永豐	---	---	---	---	---	0.03	0	0	0	0.00	0.01	5,000,000	0.01	0.46	0.01
716339	康和XD	---	---	---	---	---	0.14	0	0	0	0.00	0.10	5,000,000	0.09	0.84	0.01
716340	康和XE	---	---	---	---	---	0.15	0	0	0	0.00	0.01	5,000,000	0.01	0.26	0.01
716341	SW第一	---	---	---	---	---	1.05	0	0	0	1.40	1.50	5,000,000	1.50	2.80	0.20
716342	中信US	---	---	---	---	---	0.05	0	0	0	0.03	0.04	5,000,000	0.03	0.49	0.01
716343	PA國泰	---	---	---	---	---	0.13	0	0	0	0.04	0.09	5,000,000	0.09	0.96	0.01
716344	國泰UO	---	---	---	---	---	1.36	0	0	0	1.45	0.00	5,000,000	1.59	2.07	1.11
716345	群益VG	---	---	---	---	---	0.61	0	0	0	0.00	0.10	5,000,000	0.02	0.62	0.01
716346	群益VH	---	---	---	---	---	0.11	0	0	0	0.01	0.02	5,000,000	0.02	0.85	0.01
716347	群益VJ	0.19	0.00	0.19	0.23	0.17	0.18	330,000	60,200	5	0.16	0.17	5,000,000	0.19	1.26	0.01
716348	國票ZX	---	---	---	---	---	0.08	0	0	0	0.00	0.01	12,000,000	0.01	0.51	0.01
716349	富邦VE	---	---	---	---	---	0.08	0	0	0	0.06	0.15	5,000,000	0.08	1.11	0.01
716350	富邦VF	3.24	+0.02	3.24	3.24	3.24	3.24	10,000	32,400	1	3.57	3.66	5,000,000	3.24	5.30	1.14
716351	元大PR	---	---	---	---	---	0.04	0	0	0	0.00	0.10	10,000,000	0.04	0.61	0.01
716352	元大PU	---	---	---	---	---	0.01	0	0	0	0.00	0.02	10,000,000	0.01	1.04	0.01
716353	元大PV	---	---	---	---	---	0.40	0	0	0	0.68	0.72	5,000,000	0.68	1.62	0.01
716354	元大PW	---	---	---	---	---	0.08	0	0	0	0.00	0.02	5,000,000	0.01	0.51	0.01
716355	元大PY	---	---	---	---	---	1.91	0	0	0	1.22	1.32	5,000,000	1.22	2.52	0.01
716356	日盛SS	---	---	---	---	---	0.01	0	0	0	0.00	0.00	15,000,000	0.01	0.51	0.01
716357	日盛ST	---	---	---	---	---	0.01	0	0	0	0.01	0.02	5,000,000	0.01	0.35	0.01