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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
717245	日盛VR	---	---	---	---	---	0.02	0	0	0	0.01	0.02	5,000,000	0.02	0.48	0.01
717246	日盛VS	0.13	-0.17	0.13	0.13	0.13	0.13	90,000	11,700	1	0.11	0.12	5,000,000	0.13	0.68	0.01
717247	PC元大	1.16	-0.20	1.22	1.22	1.16	1.20	4,000	4,820	2	1.43	1.53	5,000,000	1.16	2.16	0.13
717248	PF元大	---	---	---	---	---	0.29	0	0	0	0.25	0.26	5,000,000	0.26	0.70	0.01
717249	TM第一	---	---	---	---	---	2.13	0	0	0	0.35	0.39	5,000,000	0.39	1.49	0.01
71724P	富邦UV	---	---	---	---	---	0.14	0	0	0	0.00	0.10	10,000,000	0.10	0.97	0.01
717250	統一U1	---	---	---	---	---	1.62	0	0	0	1.08	1.18	13,000,000	1.18	1.82	0.54
717251	統一U2	0.30	-0.18	0.30	0.33	0.29	0.32	640,000	204,950	10	0.30	0.31	5,000,000	0.30	0.68	0.01
717252	國泰RE	1.94	-0.05	1.32	1.94	1.32	1.57	61,000	95,730	7	0.00	1.94	5,000,000	1.94	2.94	0.91
717253	國泰RF	0.51	-0.26	0.52	0.54	0.49	0.52	259,000	133,990	20	0.49	0.50	5,000,000	0.51	1.06	0.01
717254	群益V4	0.10	-0.01	0.11	0.11	0.06	0.08	798,000	64,180	24	0.09	0.10	12,258,000	0.10	0.52	0.01
717255	群益V5	---	---	---	---	---	0.46	0	0	0	0.10	0.11	8,000,000	0.11	1.39	0.01
717256	群益V6	0.10	+0.07	0.05	0.10	0.05	0.07	220,000	16,200	3	0.10	0.11	7,000,000	0.10	0.75	0.01
717257	群益V7	---	---	---	---	---	4.06	0	0	0	2.54	2.64	7,000,000	2.54	3.92	1.16
717258	TP凱基	0.52	-0.25	0.56	0.56	0.48	0.52	1,001,000	524,730	20	0.51	0.52	5,000,000	0.52	1.07	0.01
717259	大展R1	---	---	---	---	---	0.01	0	0	0	0.01	0.00	10,000,000	0.01	0.67	0.01
71725P	元大S2	---	---	---	---	---	0.09	0	0	0	0.00	0.02	5,000,000	0.02	0.96	0.01
717260	大展R2	---	---	---	---	---	0.09	0	0	0	0.01	0.02	10,000,000	0.02	0.82	0.01
717261	元富QJ	---	---	---	---	---	0.40	0	0	0	0.19	0.20	5,000,000	0.20	0.75	0.01
717262	元富QK	0.14	+0.06	0.07	0.14	0.07	0.09	150,000	14,000	2	0.11	0.12	5,000,000	0.14	1.14	0.01
717263	元富QL	2.22	-0.22	2.22	2.22	2.22	2.22	4,000	8,880	1	2.49	2.51	5,000,000	2.22	3.24	1.20
717264	康和YN	---	---	---	---	---	0.02	0	0	0	0.01	0.02	5,000,000	0.02	0.42	0.01
717265	WH永豐	---	---	---	---	---	3.20	0	0	0	1.65	1.73	5,000,000	1.65	2.75	0.55
717266	國泰RG	0.88	-0.35	0.70	0.88	0.70	0.79	96,000	75,860	8	0.89	0.98	5,000,000	0.88	1.84	0.01
717267	日盛VT	0.09	-0.08	0.09	0.09	0.09	0.09	20,000	1,800	1	0.11	0.14	5,000,000	0.09	0.94	0.01
717268	國票QE	0.14	-0.08	0.10	0.14	0.10	0.12	420,000	49,000	4	0.13	0.14	5,000,000	0.14	0.62	0.01
717269	PH元大	0.20	-0.03	0.14	0.20	0.14	0.17	21,000	3,580	3	0.19	0.21	5,000,000	0.20	0.86	0.01
71726P	元大S5	---	---	---	---	---	0.02	0	0	0	0.00	0.02	5,000,000	0.02	1.33	0.01
717270	群益V8	---	---	---	---	---	0.42	0	0	0	0.18	0.19	10,000,000	0.19	0.80	0.01
717271	WI永豐	---	---	---	---	---	0.66	0	0	0	0.30	0.33	11,000,000	0.33	1.29	0.01
717272	統一U3	---	---	---	---	---	0.08	0	0	0	0.07	0.10	15,000,000	0.08	0.32	0.01
717273	統一U4	0.06	-0.03	0.05	0.06	0.05	0.05	35,000	1,850	2	0.06	0.07	5,000,000	0.06	0.35	0.01
717274	統一U5	0.29	-0.15	0.29	0.30	0.29	0.30	418,000	124,330	12	0.29	0.33	5,000,000	0.29	0.62	0.01
717275	統一U6	0.05	-0.03	0.05	0.08	0.05	0.05	188,000	9,430	6	0.05	0.06	16,000,000	0.05	0.54	0.01
717276	統一U7	0.19	0.00	0.15	0.19	0.14	0.17	447,000	78,110	5	0.19	0.20	5,000,000	0.19	0.72	0.01
717277	TQ凱基	0.45	-0.21	0.48	0.49	0.45	0.47	1,379,000	642,240	19	0.45	0.46	5,000,000	0.45	0.96	0.01
717278	日盛VU	---	---	---	---	---	0.42	0	0	0	0.01	0.02	5,000,000	0.02	1.37	0.01
717279	日盛VV	0.19	-0.10	0.20	0.20	0.19	0.19	104,000	19,800	2	0.21	0.23	5,000,000	0.19	1.13	0.01
71727P	富邦UX	---	---	---	---	---	0.10	0	0	0	0.00	0.05	10,000,000	0.05	1.20	0.01
717280	PK元大	---	---	---	---	---	1.63	0	0	0	0.00	0.00	5,000,000	1.62	2.20	1.04
717281	PM元大	---	---	---	---	---	0.09	0	0	0	0.04	0.05	5,000,000	0.05	0.59	0.01
717282	P2富邦	---	---	---	---	---	2.18	0	0	0	1.50	1.60	5,000,000	1.55	2.34	0.76
717283	P3富邦	0.20	-0.05	0.25	0.25	0.20	0.21	77,000	15,900	7	0.21	0.22	5,000,000	0.20	1.22	0.01
717284	國泰RH	3.24	+0.23	2.42	3.24	2.42	2.97	66,000	196,230	10	3.20	3.25	5,000,000	3.24	5.85	0.59
717285	元富QM	0.95	-0.61	0.72	0.97	0.72	0.96	133,000	127,410	3	0.94	0.96	5,000,000	0.95	2.39	0.01
717286	元富QN	0.52	-0.01	0.35	0.52	0.35	0.46	274,000	125,370	13	0.49	0.50	13,000,000	0.52	1.24	0.01
717287	元富QP	---	---	---	---	---	0.03	0	0	0	0.01	0.04	5,000,000	0.03	0.72	0.01
717288	元富QT	0.14	+0.03	0.07	0.14	0.07	0.10	119,000	11,400	13	0.12	0.13	5,000,000	0.14	0.83	0.01
717289	UK兆豐	0.65	-0.12	0.49	0.65	0.49	0.60	40,000	24,200	4	0.64	0.67	5,000,000	0.65	1.65	0.01
71728P	群益UL	---	---	---	---	---	0.05	0	0	0	0.00	0.00	10,000,000	0.02	0.76	0.01
717290	UL兆豐	---	---	---	---	---	0.11	0	0	0	0.00	0.03	5,000,000	0.03	0.67	0.01
717291	UM兆豐	---	---	---	---	---	0.05	0	0	0	0.04	0.05	5,000,000	0.05	0.63	0.01
717292	UN兆豐	---	---	---	---	---	3.10	0	0	0	2.42	2.43	5,000,000	2.43	3.58	1.28
717293	康和YR	---	---	---	---	---	1.17	0	0	0	0.40	0.46	5,000,000	0.46	0.97	0.01
717294	WJ永豐	---	---	---	---	---	0.24	0	0	0	0.11	0.12	11,000,000	0.12	1.06	0.01
717295	WK永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	12,000,000	0.01	0.73	0.01
717296	WL永豐	---	---	---	---	---	0.42	0	0	0	0.00	0.01	13,000,000	0.01	0.48	0.01
717297	WM永豐	0.50	-0.35	0.30	0.55	0.30	0.32	90,000	29,250	4	0.50	0.53	5,000,000	0.50	1.19	0.01
717298	WN永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	10,000,000	0.01	0.52	0.01
717299	WP永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	13,000,000	0.01	0.37	0.01
71729P	群益UM	---	---	---	---	---	0.27	0	0	0	0.00	0.00	5,000,000	0.01	0.74	0.01
717300	TR凱基	---	---	---	---	---	0.17	0	0	0	0.11	0.12	5,000,000	0.12	0.64	0.01
717301	TS凱基	---	---	---	---	---	0.82	0	0	0	0.56	0.57	5,000,000	0.57	1.24	0.01
717302	TT凱基	---	---	---	---	---	1.09	0	0	0	0.27	0.37	5,000,000	0.37	1.07	0.01
717303	TU凱基	0.05	-0.02	0.05	0.05	0.05	0.05	490,000	24,500	47	0.05	0.06	5,000,000	0.05	0.69	0.01
717304	群益V9	0.42	-0.01	1.60	1.60	0.09	0.31	200,000	62,200	20	0.38	0.40	7,000,000	0.42	2.35	0.01
717305	群益W1	---	---	---	---	---	0.55	0	0	0	0.00	0.00	15,000,000	0.02	0.57	0.01
717306	群益W2	---	---	---	---	---	0.46	0	0	0	0.01	0.02	15,000,000	0.02	0.85	0.01
717307	群益W3	1.40	-0.52	1.37	1.40	1.32	1.36	36,000	48,920	5	1.38	1.41	5,000,000	1.40	2.49	0.31
717308	群益W4	---	---	---	---	---	0.10	0	0	0	0.00	0.50	5,000,000	0.02	0.48	0.01
717309	群益W5	---	---	---	---	---	0.60	0	0	0	0.39	0.40	10,000,000	0.39	1.03	0.01
71730P	RF兆豐	---	---	---	---	---	0.05	0	0	0	0.00	0.02	5,000,000	0.02	0.42	0.01
717310	群益W6	---	---	---	---	---	0.04	0	0	0	0.02	0.03	7,000,000	0.02	0.62	0.01
717311	群益W7	---	---	---	---	---	0.04	0	0	0	0.00	0.01	7,000,000	0.01	2.01	0.01
717312	群益W8	---	---	---	---	---	0.05	0	0	0	0.03	0.04	7,000,000	0.03	1.03	0.01
717313	群益W9	---	---	---	---	---	0.13	0	0	0	0.02	0.03	6,000,000	0.03	1.13	0.01
717314	國票QF	0.27	-0.11	0.23	0.27	0.23	0.25	112,000	28,240	3	0.31	0.32	5,000,000	0.27	1.21	0.01
717315	國票QG	---	---	---	---	---	0.04	0	0	0	0.01	0.02	10,500,000	0.02	0.78	0.01
717316	國票QH	0.85	+0.20	0.30	0.85	0.30	0.70	74,000	51,730	5	0.92	0.93	5,000,000	0.85	2.59	0.01
717317	康和YG	---	---	---	---	---	0.16	0	0	0	0.03	0.10	20,000,000	0.10	0.65	0.01
717318	康和YS	---	---	---	---	---	0.49	0	0	0	0.10	0.11	5,000,000	0.11	0.59	0.01
717319	WQ永豐	---	---	---	---	---	0.05	0	0	0	0.03	0.04	13,000,000	0.04	0.40	0.01
71731P	RG兆豐	---	---	---	---	---	0.02	0	0	0	0.00	0.01	5,000,000	0.01	0.86	0.01
717320	WR永豐	---	---	---	---	---	0.02	0	0	0	0.02	0.07	12,000,000	0.02	0.97	0.01
717321	PW元大	0.84	-0.07	0.74	0.86	0.71	0.81	289,000	235,050	13	0.84	0.00	5,000,000	0.84	1.57	0.11
717322	PX元大	---	---	---	---	---	0.03	0	0	0	0.00	0.03	5,000,000	0.03	0.58	0.01
717323	PZ元大	0.26	+0.12	0.05	0.50	0.05	0.12	561,000	66,940	31	0.24	0.25	5,000,000	0.26	2.19	0.01
717324	QA元大	0.61	-0.38	0.49	0.68	0.47	0.58	355,000	204,150	13	0.56	0.00	5,000,000	0.61	1.70	0.01
717325	QB元大	---	---	---	---	---	0.08	0	0	0	0.00	0.10	5,000,000	0.10	0.95	0.01
717326	元富QU	0.15	-0.07	0.15	0.15	0.15	0.15	10,000	1,500	1	0.16	0.17	10,000,000	0.15	0.73	0.01
717327	元富QV	0.46	-0.02	0.44	0.46	0.44	0.45	145,000	65,300	3	0.44	0.46	12,000,000	0.46	1.09	0.01
717328	元富QW	---	---	---	---	---	0.14	0	0	0	0.01	0.04	5,000,000	0.04	0.59	0.01
717329	元富QX	0.25	+0.06	0.13	0.26	0.13	0.19	570,000	106,400	48	0.13	0.23	10,000,000	0.25	2.18	0.01
71732P	RP兆豐	---	---	---	---	---	0.02	0	0	0	0.00	0.01	5,000,000	0.01	0.51	0.01
717330	元富QY	---	---	---	---	---	0.47	0	0	0	0.01	0.04	5,000,000	0.04	0.61	0.01
717331	P4富邦	0.56	+0.18	0.28	0.58	0.28	0.46	520,000	237,200	15	0.54	0.56	10,000,000	0.56	1.91	0.01
717332	PA群益	0.03	-0.01	0.03	0.03	0.03	0.03	50,000	1,500	2	0.02	0.03	7,000,000	0.03	0.54	0.01
717333	PB群益	---	---	---	---	---	0.17	0	0	0	0.00	0.00	7,000,000	0.02	0.78	0.01
717334	PC群益	0.20	-0.09	0.10	0.20	0.10	0.10	31,000	3,200	2	0.21	0.22	5,000,000	0.20	1.85	0.01
717335	統一U8	0.90	-0.26	0.91	0.97	0.88	0.90	181,000	163,010	12	0.90	0.92	14,000,000	0.90	1.41	0.39