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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
724298	凱基T8	0.79	0.00	0.77	0.79	0.77	0.77	10,000	7,740	2	0.77	0.78	5,000,000	0.79	1.23	0.35
724299	凱基T9	0.89	+0.02	0.90	0.90	0.87	0.90	248,000	222,090	12	0.87	0.88	10,000,000	0.89	1.23	0.55
72429P	XT第一	---	---	---	---	---	0.18	0	0	0	0.14	0.15	10,000,000	0.15	1.24	0.01
724300	合庫P5	---	---	---	---	---	0.90	0	0	0	0.57	0.58	10,000,000	0.58	1.28	0.01
724301	合庫P6	1.05	-0.05	1.03	1.05	1.02	1.02	175,000	178,860	6	1.04	1.05	10,000,000	1.05	1.49	0.61
724302	SA元大	1.02	-0.06	1.06	1.09	1.02	1.06	361,000	382,660	4	0.97	0.98	10,000,000	1.02	1.64	0.40
724303	SB元大	---	---	---	---	---	0.00	0	0	0	0.72	0.73	10,000,000	0.73	1.32	0.14
724304	SD元大	0.85	-0.06	0.86	0.86	0.83	0.85	25,000	21,250	4	0.86	0.88	10,000,000	0.85	1.51	0.19
724305	SE元大	0.90	-0.03	0.90	0.90	0.90	0.90	100,000	90,000	1	0.88	0.89	10,000,000	0.90	1.67	0.13
724306	SH元大	1.06	-0.13	1.06	1.06	1.06	1.06	5,000	5,300	1	1.14	1.15	10,000,000	1.06	1.81	0.31
72430P	元大Q3	---	---	---	---	---	0.03	0	0	0	0.03	0.04	5,000,000	0.03	0.87	0.01
72431P	元大Q4	1.14	+0.31	1.05	1.20	1.03	1.08	298,000	323,250	15	1.17	1.21	5,000,000	1.14	2.56	0.01
72433P	元大S4	0.38	-0.02	0.38	0.38	0.38	0.38	139,000	52,820	14	0.37	0.38	5,000,000	0.38	0.78	0.01
72434P	UG元富	0.12	0.00	0.12	0.12	0.12	0.12	20,000	2,400	2	0.11	0.12	6,000,000	0.12	1.10	0.01
72435P	UM元富	---	---	---	---	---	0.51	0	0	0	0.19	0.20	6,000,000	0.20	1.64	0.01
72436P	TZ群益	---	---	---	---	---	1.04	0	0	0	1.00	1.02	5,000,000	1.02	2.01	0.03
72437P	UA群益	0.32	-0.03	0.31	0.33	0.31	0.32	774,000	246,240	9	0.31	0.32	8,000,000	0.32	3.19	0.01
72438P	永豐PQ	0.85	+0.06	0.89	0.90	0.85	0.89	187,000	167,150	6	0.85	0.86	5,000,000	0.85	1.54	0.16
72439P	UP元富	1.33	+0.29	1.23	1.42	1.23	1.30	120,000	156,140	13	1.32	1.33	5,000,000	1.33	2.28	0.39
72440P	R4日盛	0.10	-0.01	0.10	0.10	0.10	0.10	224,000	22,400	1	0.09	0.19	5,000,000	0.10	0.56	0.01
72441P	元大PL	0.01	-0.01	0.01	0.01	0.01	0.01	100,000	1,000	1	0.00	0.02	5,000,000	0.01	0.81	0.01
72442P	元大PX	0.66	-0.04	0.66	0.66	0.66	0.66	98,000	64,680	2	0.70	0.72	5,000,000	0.66	1.07	0.25
72443P	元大V5	0.13	-0.03	0.13	0.14	0.13	0.13	680,000	88,500	9	0.12	0.13	5,000,000	0.13	0.82	0.01
72444P	元大V9	---	---	---	---	---	0.36	0	0	0	0.29	0.30	5,000,000	0.29	0.84	0.01
72445P	永豐PV	---	---	---	---	---	0.26	0	0	0	0.14	0.15	5,000,000	0.15	0.65	0.01
72446P	RX國泰	---	---	---	---	---	0.76	0	0	0	0.83	0.87	5,000,000	0.83	1.52	0.14
72447P	RY國泰	0.62	-0.01	0.62	0.62	0.62	0.62	55,000	34,100	1	0.63	0.67	5,000,000	0.62	1.44	0.01
72448P	UG群益	0.66	-0.04	0.65	0.66	0.65	0.65	535,000	349,970	10	0.71	0.72	5,000,000	0.66	4.20	0.01
72449P	康和TD	---	---	---	---	---	0.19	0	0	0	0.06	0.10	10,000,000	0.10	0.62	0.01
72450P	UJ群益	---	---	---	---	---	0.42	0	0	0	0.39	0.40	7,000,000	0.40	1.36	0.01
72451P	TC凱基	---	---	---	---	---	0.20	0	0	0	0.12	0.22	5,000,000	0.20	1.04	0.01
72452P	永豐QI	1.10	+0.25	1.00	1.15	1.00	1.07	344,000	366,450	19	1.10	1.11	5,000,000	1.10	2.05	0.16
72453P	UL群益	---	---	---	---	---	0.01	0	0	0	0.00	0.01	8,000,000	0.01	1.15	0.01
72454P	UM群益	---	---	---	---	---	0.14	0	0	0	0.12	0.13	5,000,000	0.13	4.27	0.01
72455P	UN群益	---	---	---	---	---	0.50	0	0	0	0.53	0.54	5,000,000	0.54	3.60	0.01
72456P	永豐QP	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	1.23	0.01
72457P	TL凱基	---	---	---	---	---	0.16	0	0	0	0.02	0.03	5,000,000	0.03	0.78	0.01
72458P	UT群益	---	---	---	---	---	0.15	0	0	0	0.13	0.14	5,000,000	0.14	0.87	0.01
72459P	統一T6	0.14	+0.01	0.14	0.14	0.14	0.14	10,000	1,400	1	0.13	0.14	5,000,000	0.14	0.74	0.01
72460P	永豐QR	---	---	---	---	---	0.05	0	0	0	0.04	0.05	5,000,000	0.05	1.26	0.01
72461P	UX群益	---	---	---	---	---	0.16	0	0	0	0.15	0.16	8,000,000	0.15	0.81	0.01
72462P	UY群益	---	---	---	---	---	0.08	0	0	0	0.09	0.10	5,000,000	0.09	1.77	0.01
72463P	永豐QS	---	---	---	---	---	0.95	0	0	0	1.13	1.16	5,000,000	1.13	1.52	0.74
72464P	SA國泰	0.16	+0.01	0.16	0.16	0.16	0.16	15,000	2,400	1	0.15	0.20	5,000,000	0.16	0.96	0.01
72465P	SB國泰	0.72	+0.01	0.68	0.72	0.68	0.69	48,000	33,100	5	0.72	0.73	5,000,000	0.72	1.25	0.19
72466P	VA群益	0.26	+0.02	0.25	0.26	0.25	0.25	1,018,000	255,300	17	0.25	0.27	7,000,000	0.26	0.89	0.01
72467P	VB群益	0.25	-0.03	0.25	0.25	0.25	0.25	20,000	5,000	1	0.24	0.25	5,000,000	0.25	1.53	0.01
72468P	康和TE	0.42	-0.02	0.42	0.42	0.42	0.42	70,000	29,400	1	0.42	0.44	8,000,000	0.42	1.03	0.01
72469P	富邦SX	1.40	+0.26	1.30	1.40	1.30	1.36	25,000	34,000	3	1.41	1.44	5,000,000	1.40	2.11	0.70
72470P	VF群益	0.37	-0.03	0.37	0.37	0.37	0.37	2,000	740	1	0.36	0.37	5,000,000	0.37	1.41	0.01
72471P	VG群益	---	---	---	---	---	0.50	0	0	0	0.29	0.30	5,000,000	0.30	2.00	0.01
72472P	元大QK	---	---	---	---	---	0.22	0	0	0	0.12	0.13	5,000,000	0.13	1.04	0.01
72473P	元大QP	1.41	+0.22	1.35	1.47	1.34	1.39	625,000	869,400	20	1.41	1.42	5,000,000	1.41	2.12	0.71
72474P	VF元富	---	---	---	---	---	0.61	0	0	0	0.45	0.50	5,000,000	0.47	1.08	0.01
72475P	VG元富	0.24	+0.01	0.24	0.24	0.24	0.24	1,000	240	1	0.19	0.24	5,000,000	0.24	0.87	0.01
72476P	VH元富	---	---	---	---	---	0.51	0	0	0	0.48	0.49	5,000,000	0.49	0.98	0.01
72477P	元大RD	---	---	---	---	---	0.44	0	0	0	0.41	0.42	5,000,000	0.42	0.91	0.01
72478P	元大RK	---	---	---	---	---	0.12	0	0	0	0.12	0.13	5,000,000	0.13	1.04	0.01
72479P	VM元富	1.35	+0.23	1.35	1.35	1.35	1.35	2,000	2,700	1	1.35	1.37	5,000,000	1.35	1.92	0.79
72480P	S4日盛	---	---	---	---	---	0.26	0	0	0	0.06	0.07	15,000,000	0.07	1.42	0.01
72481P	康和TG	0.22	+0.02	0.22	0.22	0.22	0.22	20,000	4,400	1	0.21	0.22	10,000,000	0.22	0.77	0.01
72482P	康和TH	---	---	---	---	---	0.36	0	0	0	0.36	0.37	8,000,000	0.36	0.98	0.01
72483P	SI國泰	0.71	-0.02	0.71	0.72	0.70	0.71	360,000	257,300	10	0.71	0.72	5,000,000	0.71	1.35	0.07
72485P	VN群益	0.25	+0.01	0.25	0.25	0.25	0.25	10,000	2,500	1	0.23	0.24	5,000,000	0.25	1.95	0.01
72486P	VQ元富	0.10	-0.01	0.10	0.10	0.10	0.10	299,000	29,900	1	0.09	0.10	5,000,000	0.10	1.06	0.01
72487P	VR群益	0.67	-0.07	0.65	0.67	0.65	0.66	18,000	11,860	4	0.67	0.69	5,000,000	0.67	1.34	0.01
72488P	中信YV	0.63	-0.06	0.61	0.63	0.60	0.62	145,000	89,550	4	0.62	0.63	5,000,000	0.63	1.35	0.01
72489P	UJ凱基	0.22	-0.01	0.22	0.22	0.22	0.22	10,000	2,200	1	0.22	0.23	10,000,000	0.22	0.89	0.01
72490P	UK凱基	---	---	---	---	---	0.29	0	0	0	0.26	0.27	10,000,000	0.26	0.74	0.01
72492P	康和TM	0.57	+0.03	0.57	0.60	0.56	0.58	500,000	287,910	26	0.58	0.61	8,000,000	0.57	1.05	0.09
72493P	永豐RW	0.24	+0.02	0.23	0.24	0.23	0.23	65,000	15,100	2	0.22	0.24	5,000,000	0.24	0.99	0.01
72494P	VX群益	---	---	---	---	---	1.36	0	0	0	1.40	1.41	5,000,000	1.40	2.42	0.38
72495P	VY群益	0.83	-0.01	0.83	0.83	0.83	0.83	40,000	33,200	4	0.85	0.86	5,000,000	0.83	1.15	0.51
72496P	S9日盛	0.68	-0.03	0.69	0.71	0.68	0.70	576,000	401,850	13	0.69	0.71	5,000,000	0.68	1.16	0.20
72497P	UQ凱基	0.75	-0.02	0.74	0.75	0.73	0.74	230,000	170,100	9	0.75	0.76	10,000,000	0.75	1.39	0.11
72498P	T1日盛	---	---	---	---	---	1.43	0	0	0	1.21	1.30	20,000,000	1.24	1.93	0.55
72499P	元大TM	0.66	-0.05	0.64	0.67	0.64	0.66	657,000	434,540	7	0.66	0.67	5,000,000	0.66	1.23	0.09
72500P	元大TN	---	---	---	---	---	0.20	0	0	0	0.18	0.19	10,000,000	0.19	0.97	0.01
72501P	元大TP	0.30	-0.02	0.31	0.32	0.30	0.31	481,000	150,720	6	0.17	0.00	5,000,000	0.30	0.78	0.01
72502P	VZ元富	---	---	---	---	---	0.10	0	0	0	0.09	0.14	5,000,000	0.10	1.24	0.01
72503P	WA群益	---	---	---	---	---	1.35	0	0	0	1.33	1.36	5,000,000	1.35	1.84	0.86
72504P	元大VN	0.11	0.00	0.11	0.13	0.11	0.11	1,380,000	154,600	22	0.11	0.12	5,000,000	0.11	1.25	0.01
72505P	元大WM	0.74	-0.13	0.77	0.77	0.70	0.76	328,000	248,430	15	0.73	0.74	5,000,000	0.74	1.54	0.01
72506P	WA元富	---	---	---	---	---	0.24	0	0	0	0.17	0.22	5,000,000	0.22	1.64	0.01
72507P	永豐SB	1.81	+0.24	1.88	1.88	1.81	1.84	25,000	46,020	2	1.81	1.84	5,000,000	1.81	2.47	1.16
72508P	永豐SC	0.13	+0.01	0.13	0.13	0.11	0.13	982,000	126,760	12	0.11	0.13	5,000,000	0.13	0.84	0.01
72509P	WB群益	0.56	-0.08	0.56	0.56	0.56	0.56	30,000	16,800	1	0.59	0.60	5,000,000	0.56	1.04	0.08
72510P	WE群益	---	---	---	---	---	1.14	0	0	0	1.12	1.13	5,000,000	1.12	2.14	0.10
72511P	UV凱基	0.54	-0.03	0.55	0.58	0.53	0.57	84,000	47,760	5	0.54	0.55	5,000,000	0.54	1.18	0.01
72512P	WH群益	0.64	-0.03	0.65	0.65	0.64	0.65	184,000	119,550	3	0.63	0.64	5,000,000	0.64	1.60	0.01
72513P	WW群益	---	---	---	---	---	0.80	0	0	0	0.77	0.78	5,000,000	0.78	1.63	0.01
72514P	永豐TH	0.82	-0.01	0.82	0.82	0.82	0.82	100,000	82,000	1	0.82	0.83	5,000,000	0.82	1.26	0.38
72515P	VA凱基	0.71	+0.04	0.66	0.71	0.66	0.70	299,000	208,030	9	0.70	0.71	5,000,000	0.71	1.55	0.01
72516P	VK元大	0.72	+0.04	0.72	0.72	0.71	0.72	37,000	26,490	4	0.72	0.73	5,000,000	0.72	1.56	0.01
72517P	WV元富	0.61	+0.01	0.61	0.61	0.61	0.61	100,000	61,000	1	0.62	0.63	5,000,000	0.61	1.03	0.19
72518P	WW元富	---	---	---	---	---	1.01	0	0	0	1.03	1.05	5,000,000	1.04	1.52	0.56
72519P	WX元富	1.25	+0.09	1.20	1.26	1.20	1.23	60,000	73,900	6	1.26	1.27	5,000,000	1.25	1.89	0.61
72520P	SU國泰	---	---	---	---	---	1.26	0	0	0	1.24	1.28	5,000,000	1.26	1.90	0.62
72521P	P3群益	0.62	-0.01	0.65	0.65	0.62	0.65	42,000	27,190	6	0.62	0.63	5,000,000	0.62	0.89	0.35
72522P	WY元富	0.55	-0.02	0.55	0.55	0.53	0.54	246,000	133,230	5	0.54	0.55	6,000,000	0.55	1.28	0.01