SQL: SELECT * FROM this || 上櫃股票行情

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
718275	國票RL	0.23	+0.05	0.19	0.23	0.19	0.19	11,000	2,130	2	0.21	0.22	14,000,000	0.23	1.07	0.01
718276	YT凱基	---	---	---	---	---	1.11	0	0	0	0.00	0.00	6,000,000	1.12	1.56	0.66
718277	YU凱基	---	---	---	---	---	0.20	0	0	0	0.08	0.10	5,000,000	0.10	0.55	0.01
718278	V4富邦	---	---	---	---	---	0.15	0	0	0	0.10	0.12	10,000,000	0.12	1.32	0.01
718279	V5富邦	0.15	-0.03	0.11	0.17	0.11	0.15	772,000	116,550	15	0.14	0.15	10,000,000	0.15	0.65	0.01
71827P	日盛VK	0.01	0.00	0.01	0.01	0.01	0.01	110,000	1,100	2	0.01	0.02	20,000,000	0.01	0.93	0.01
718280	V6富邦	0.25	-0.01	0.19	0.26	0.19	0.22	134,000	29,010	8	0.22	0.24	10,000,000	0.25	0.68	0.01
718281	永豐PA	2.05	+0.05	1.80	2.05	1.80	1.94	27,000	52,320	5	2.05	2.15	5,000,000	2.05	2.65	1.44
718282	永豐Z1	---	---	---	---	---	0.13	0	0	0	0.11	0.13	13,000,000	0.13	0.45	0.01
718283	永豐Z2	0.04	-0.01	0.03	0.04	0.03	0.04	283,000	10,990	29	0.03	0.04	5,000,000	0.04	0.58	0.01
718284	永豐Z3	0.18	-0.04	0.17	0.18	0.17	0.17	104,000	17,720	2	0.17	0.18	5,000,000	0.18	1.02	0.01
718285	永豐Z4	---	---	---	---	---	0.94	0	0	0	0.90	1.00	5,000,000	0.90	1.37	0.43
718286	永豐Z5	---	---	---	---	---	2.00	0	0	0	1.42	1.44	5,000,000	1.42	2.28	0.56
718287	永豐Z6	---	---	---	---	---	4.00	0	0	0	1.75	1.80	10,000,000	1.80	3.13	0.47
718288	永豐Z7	---	---	---	---	---	0.03	0	0	0	0.02	0.03	10,000,000	0.03	0.69	0.01
718289	永豐Z8	0.28	+0.10	0.16	0.28	0.16	0.19	121,000	23,480	11	0.23	0.26	12,000,000	0.28	1.16	0.01
71828P	日盛VL	---	---	---	---	---	0.02	0	0	0	0.01	0.05	20,000,000	0.02	0.99	0.01
718290	永豐Z9	0.13	-0.04	0.12	0.13	0.12	0.12	51,000	6,130	2	0.13	0.14	12,000,000	0.13	0.93	0.01
718291	元富UW	---	---	---	---	---	0.17	0	0	0	0.11	0.12	10,000,000	0.12	0.95	0.01
718292	元富UX	0.32	-0.03	0.28	0.32	0.28	0.30	300,000	91,000	3	0.33	0.35	5,000,000	0.32	0.74	0.01
718293	XH兆豐	---	---	---	---	---	0.24	0	0	0	0.10	0.11	5,000,000	0.11	0.80	0.01
718294	日盛T5	---	---	---	---	---	0.05	0	0	0	0.03	0.04	5,000,000	0.04	0.56	0.01
718295	日盛T6	0.15	-0.01	0.13	0.15	0.11	0.12	126,000	15,400	12	0.15	0.16	5,000,000	0.15	0.49	0.01
718296	統一PL	0.16	-0.11	0.16	0.18	0.16	0.18	240,000	42,600	5	0.16	0.17	15,000,000	0.16	0.51	0.01
718297	統一PM	0.15	-0.02	0.12	0.15	0.12	0.14	120,000	16,750	4	0.15	0.16	17,000,000	0.15	0.71	0.01
718298	統一PN	2.05	-0.19	1.85	2.05	1.84	1.92	65,000	124,650	7	2.35	2.43	5,000,000	2.05	2.75	1.34
718299	U5元大	0.03	+0.01	0.03	0.03	0.03	0.03	10,000	300	1	0.02	0.03	5,000,000	0.03	0.80	0.01
71829P	WD永豐	---	---	---	---	---	0.11	0	0	0	0.08	0.09	5,000,000	0.09	0.88	0.01
718300	V1元大	1.30	+0.07	1.10	1.48	0.96	1.27	1,406,000	1,789,060	57	1.27	1.30	5,000,000	1.30	2.50	0.07
718301	V2元大	0.27	+0.01	0.27	0.27	0.27	0.27	3,000	810	1	0.26	0.27	5,000,000	0.27	0.55	0.01
718302	V4元大	---	---	---	---	---	0.13	0	0	0	0.07	0.14	5,000,000	0.13	0.43	0.01
718303	V5元大	0.22	-0.06	0.19	0.23	0.19	0.21	547,000	115,530	7	0.23	0.24	5,000,000	0.22	0.72	0.01
718304	V7元大	---	---	---	---	---	0.35	0	0	0	0.16	0.17	5,000,000	0.17	1.09	0.01
718305	V9元大	---	---	---	---	---	0.48	0	0	0	0.41	0.42	5,000,000	0.42	0.96	0.01
718306	康和R4	---	---	---	---	---	0.45	0	0	0	0.19	0.20	5,000,000	0.20	0.55	0.01
718307	康和R5	0.20	-0.03	0.20	0.20	0.20	0.20	30,000	6,000	1	0.22	0.23	10,000,000	0.20	0.75	0.01
718308	永豐PC	---	---	---	---	---	0.12	0	0	0	0.07	0.08	5,700,000	0.07	0.43	0.01
718309	永豐PD	---	---	---	---	---	0.17	0	0	0	0.01	0.03	5,000,000	0.03	0.45	0.01
71830P	群益U7	---	---	---	---	---	0.14	0	0	0	0.08	0.09	5,000,000	0.09	1.12	0.01
718310	永豐PE	0.16	-0.04	0.14	0.16	0.14	0.15	94,000	14,500	5	0.15	0.16	12,000,000	0.16	0.64	0.01
718311	永豐PF	---	---	---	---	---	1.33	0	0	0	1.05	1.08	5,000,000	1.08	2.24	0.01
718312	永豐PG	4.60	+0.31	3.33	4.60	3.22	3.59	184,000	660,970	19	4.43	4.53	5,000,000	4.60	6.30	2.87
718313	永豐PH	0.10	+0.01	0.10	0.10	0.10	0.10	10,000	1,000	1	0.09	0.10	5,037,000	0.10	0.50	0.01
718314	國票RM	0.30	-0.07	0.30	0.30	0.30	0.30	99,000	29,700	1	0.36	0.37	5,000,000	0.30	0.69	0.01
718315	國票RN	0.29	-0.09	0.30	0.30	0.29	0.30	61,000	18,180	2	0.30	0.31	14,000,000	0.29	1.01	0.01
718316	國票RP	---	---	---	---	---	0.66	0	0	0	0.44	0.45	5,000,000	0.44	1.11	0.01
718317	V8富邦	---	---	---	---	---	0.76	0	0	0	0.59	0.60	5,000,000	0.59	0.99	0.19
718318	V9富邦	0.20	-0.05	0.20	0.20	0.20	0.20	30,000	6,000	1	0.24	0.25	10,000,000	0.20	1.55	0.01
718319	中信VQ	---	---	---	---	---	0.61	0	0	0	0.04	0.05	5,000,000	0.05	0.63	0.01
71831P	康和YP	---	---	---	---	---	0.34	0	0	0	0.25	0.26	5,000,000	0.25	0.74	0.01
718320	中信VR	---	---	---	---	---	0.18	0	0	0	0.04	0.05	5,000,000	0.05	0.41	0.01
718321	國泰TI	0.39	+0.01	0.32	0.40	0.32	0.35	37,000	12,890	5	0.38	0.39	5,000,000	0.39	0.83	0.01
718322	國泰TJ	0.12	0.00	0.09	0.12	0.08	0.09	116,000	9,870	8	0.08	0.11	5,000,000	0.12	0.52	0.01
718323	TR群益	0.36	0.00	0.30	0.36	0.28	0.31	168,000	52,200	7	0.35	0.37	9,000,000	0.36	1.74	0.01
718324	TS群益	1.16	+0.02	1.08	1.16	1.03	1.09	71,000	77,480	7	1.19	1.20	5,000,000	1.16	2.51	0.01
718325	TT群益	---	---	---	---	---	0.14	0	0	0	0.10	0.11	10,000,000	0.11	0.48	0.01
718326	TU群益	0.58	-0.09	0.59	0.59	0.58	0.58	67,000	38,960	2	0.60	0.63	5,000,000	0.58	2.23	0.01
718327	永昌YE	---	---	---	---	---	0.05	0	0	0	0.04	0.10	10,000,000	0.05	0.36	0.01
718328	PQ元大	0.56	0.00	0.54	0.56	0.52	0.54	401,000	216,150	6	0.56	0.57	5,000,000	0.56	1.08	0.01
718329	PY元大	0.29	-0.10	0.29	0.29	0.29	0.29	5,000	1,450	1	0.31	0.32	5,000,000	0.29	0.81	0.01
71832P	PJ元大	0.14	+0.11	0.14	0.14	0.14	0.14	149,000	20,860	2	0.01	0.30	5,000,000	0.14	0.64	0.01
718330	QX元大	1.94	+0.80	1.20	1.94	1.08	1.49	2,761,000	4,115,380	135	1.90	2.10	5,000,000	1.94	2.98	0.89
718331	W3元大	0.14	-0.04	0.13	0.14	0.13	0.14	105,000	14,650	2	0.13	0.14	16,000,000	0.14	0.86	0.01
718332	W5元大	0.26	+0.06	0.12	0.30	0.10	0.20	2,041,000	406,860	41	0.26	0.27	5,000,000	0.26	1.80	0.01
718333	日盛T7	1.90	-0.48	1.92	2.14	1.90	2.02	211,000	426,660	3	1.96	2.00	10,000,000	1.90	3.40	0.40
718334	XJ兆豐	0.18	+0.03	0.18	0.18	0.18	0.18	10,000	1,800	1	0.16	0.17	5,000,000	0.18	1.16	0.01
718335	UN第一	---	---	---	---	---	0.54	0	0	0	0.01	0.10	5,000,000	0.10	1.90	0.01
718336	UP第一	---	---	---	---	---	1.07	0	0	0	0.04	0.10	10,000,000	0.10	0.68	0.01
718337	國票RQ	---	---	---	---	---	0.19	0	0	0	0.07	0.08	5,000,000	0.08	0.53	0.01
718338	國票RS	0.73	-0.30	0.70	0.78	0.70	0.75	389,000	292,880	5	0.76	0.77	5,000,000	0.73	1.31	0.15
718339	YV凱基	---	---	---	---	---	0.02	0	0	0	0.01	0.02	5,000,000	0.02	0.32	0.01
71833P	元富QQ	0.37	+0.02	0.57	0.57	0.37	0.55	11,000	6,070	2	0.37	0.39	5,000,000	0.37	1.09	0.01
718340	W1富邦	0.75	-0.01	0.78	0.78	0.75	0.76	29,000	22,050	3	0.71	0.74	10,000,000	0.75	1.28	0.22
718341	元富UY	0.92	0.00	0.81	0.92	0.81	0.83	97,000	80,990	2	0.96	0.97	5,000,000	0.92	2.13	0.01
718342	元富UZ	0.17	+0.04	0.11	0.17	0.11	0.13	70,000	9,300	7	0.19	0.20	5,000,000	0.17	0.82	0.01
718343	元富VA	0.42	-0.05	0.40	0.46	0.40	0.43	1,020,000	436,400	14	0.42	0.43	5,000,000	0.42	1.26	0.01
718344	元富VB	0.25	0.00	0.25	0.25	0.25	0.25	8,000	2,000	2	0.24	0.25	5,000,000	0.25	0.78	0.01
718345	國泰TL	0.29	-0.01	0.29	0.29	0.29	0.29	3,000	870	1	0.30	0.31	5,100,000	0.29	0.80	0.01
718346	國泰TM	---	---	---	---	---	0.83	0	0	0	0.53	0.61	5,000,000	0.59	1.22	0.01
718347	TV群益	---	---	---	---	---	0.30	0	0	0	0.04	0.05	5,000,000	0.05	0.50	0.01
718348	TW群益	0.29	-0.06	0.26	0.30	0.26	0.29	1,419,000	412,910	13	0.29	0.30	10,000,000	0.29	0.75	0.01
718349	TX群益	0.12	-0.03	0.12	0.12	0.12	0.12	20,000	2,400	1	0.12	0.13	6,000,000	0.12	1.44	0.01
71834P	元富QR	0.20	+0.08	0.20	0.20	0.13	0.17	725,000	122,400	19	0.20	0.95	10,000,000	0.20	1.17	0.01
718350	TY群益	---	---	---	---	---	0.30	0	0	0	0.25	0.26	5,000,000	0.26	1.56	0.01
718351	TZ群益	---	---	---	---	---	0.21	0	0	0	0.10	0.11	5,000,000	0.11	1.15	0.01
718352	康和R6	0.47	+0.12	0.41	0.47	0.41	0.46	119,000	54,730	2	0.48	0.49	5,000,000	0.47	1.18	0.01
718353	永豐PJ	0.34	-0.01	0.34	0.34	0.34	0.34	10,000	3,400	1	0.34	0.35	5,000,000	0.34	0.78	0.01
718354	永豐PK	0.36	-0.03	0.37	0.38	0.34	0.37	442,000	161,750	15	0.35	0.36	5,000,000	0.36	0.86	0.01
718355	永豐PL	0.40	-0.04	0.40	0.40	0.40	0.40	5,000	2,000	1	0.43	0.44	5,000,000	0.40	0.84	0.01
718356	永豐PM	---	---	---	---	---	0.22	0	0	0	0.18	0.19	11,000,000	0.19	0.78	0.01
718357	永豐PN	---	---	---	---	---	0.22	0	0	0	0.17	0.18	5,000,000	0.17	0.43	0.01
718358	永豐PP	---	---	---	---	---	1.00	0	0	0	0.83	0.85	5,000,000	0.83	1.25	0.41
718359	康和R7	3.72	-0.99	3.72	3.72	3.72	3.72	10,000	37,200	1	0.00	0.00	5,000,000	3.72	4.72	2.70
71835P	元富QS	0.74	+0.01	0.76	0.76	0.74	0.75	246,000	185,180	3	0.70	0.75	5,000,000	0.74	1.23	0.25
718360	日盛T8	0.28	-0.05	0.28	0.28	0.28	0.28	70,000	19,600	1	0.32	0.33	5,000,000	0.28	0.72	0.01
718361	統一PP	0.20	-0.05	0.23	0.23	0.20	0.22	255,000	55,200	5	0.19	0.21	5,000,000	0.20	0.56	0.01
718362	元富VC	---	---	---	---	---	0.46	0	0	0	0.26	0.27	5,000,000	0.27	0.82	0.01
718363	元富VD	---	---	---	---	---	0.41	0	0	0	0.31	0.33	5,000,000	0.33	1.29	0.01
718364	元富VE	---	---	---	---	---	0.18	0	0	0	0.05	0.06	5,000,000	0.06	0.81	0.01
718365	元富VF	0.52	+0.13	0.23	0.56	0.23	0.39	430,000	168,100	16	0.51	0.54	5,000,000	0.52	1.67	0.01