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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
723152	WD凱基	---	---	---	---	---	0.38	0	0	0	0.40	0.41	5,000,000	0.40	0.81	0.01
723153	WE凱基	---	---	---	---	---	2.12	0	0	0	2.04	2.12	5,000,000	2.12	2.99	1.25
723154	WF凱基	0.62	-0.01	0.61	0.63	0.58	0.59	470,000	278,750	14	0.62	0.63	5,000,000	0.62	1.25	0.01
723155	WG凱基	0.60	-0.08	0.64	0.65	0.60	0.63	346,000	217,810	12	0.60	0.61	5,000,000	0.60	1.04	0.16
723156	WH凱基	0.28	-0.02	0.28	0.28	0.28	0.28	17,000	4,760	1	0.27	0.28	5,000,000	0.28	0.71	0.01
723157	U6日盛	0.38	+0.05	0.36	0.38	0.35	0.36	483,000	175,140	10	0.36	0.38	20,000,000	0.38	0.84	0.01
723158	統一W1	0.88	-0.03	0.87	0.88	0.82	0.87	55,000	47,800	4	0.86	0.89	15,000,000	0.88	1.37	0.39
723159	永豐UK	0.48	+0.05	0.48	0.48	0.48	0.48	3,000	1,440	1	0.48	0.49	11,000,000	0.48	0.96	0.01
723160	永豐UL	0.82	-0.02	0.79	0.82	0.79	0.80	15,000	12,000	2	0.81	0.82	5,000,000	0.82	1.62	0.02
723161	永豐UM	---	---	---	---	---	0.45	0	0	0	0.47	0.48	11,000,000	0.47	0.90	0.04
723162	永豐UN	0.17	-0.10	0.18	0.18	0.16	0.17	110,000	18,540	4	0.16	0.17	5,000,000	0.17	0.92	0.01
723163	YE元富	---	---	---	---	---	0.30	0	0	0	0.30	0.31	5,000,000	0.31	1.11	0.01
723164	YF元富	0.31	0.00	0.30	0.31	0.30	0.30	100,000	30,200	4	0.32	0.33	5,000,000	0.31	1.23	0.01
723165	YG元富	0.49	-0.03	0.50	0.51	0.47	0.49	743,000	363,800	11	0.47	0.00	5,000,000	0.49	1.18	0.01
723166	YH元富	1.16	+0.04	1.15	1.16	1.13	1.14	444,000	507,620	10	1.15	1.16	5,000,000	1.16	1.84	0.48
723167	富邦UE	0.93	-0.05	0.96	0.96	0.90	0.93	150,000	139,330	8	0.91	0.93	5,000,000	0.93	1.55	0.31
723168	富邦UF	0.25	-0.07	0.25	0.25	0.25	0.25	1,000	250	1	0.21	0.22	5,000,000	0.25	0.95	0.01
723169	元大VP	0.11	-0.01	0.11	0.11	0.11	0.11	51,000	5,610	2	0.11	0.12	5,000,000	0.11	0.48	0.01
723170	元大VR	---	---	---	---	---	0.60	0	0	0	0.66	0.67	5,000,000	0.66	1.27	0.05
723171	元大VS	0.73	+0.06	0.74	0.74	0.73	0.74	270,000	199,690	8	0.72	0.73	5,000,000	0.73	1.26	0.20
723172	元大VT	0.96	-0.06	0.96	0.96	0.96	0.96	10,000	9,600	1	0.98	1.00	5,000,000	0.96	1.62	0.30
723173	元大VV	0.78	+0.06	0.74	0.78	0.72	0.76	303,000	229,020	12	0.76	0.77	5,000,000	0.78	1.34	0.22
723174	元大VW	---	---	---	---	---	0.16	0	0	0	0.10	0.11	5,000,000	0.11	0.35	0.01
723175	U7日盛	---	---	---	---	---	0.26	0	0	0	0.26	0.27	12,000,000	0.27	0.82	0.01
723176	S7群益	0.89	0.00	0.89	0.89	0.89	0.89	28,000	24,920	1	0.93	0.94	5,000,000	0.89	1.55	0.23
723177	S8群益	---	---	---	---	---	0.45	0	0	0	0.28	0.29	5,000,000	0.29	0.90	0.01
723178	元大VX	---	---	---	---	---	0.08	0	0	0	0.12	0.13	5,000,000	0.13	0.61	0.01
723179	元大VY	0.64	-0.04	0.64	0.64	0.64	0.64	15,000	9,600	1	0.27	0.93	5,000,000	0.64	1.28	0.01
723180	亞東UX	---	---	---	---	---	0.16	0	0	0	0.19	0.20	5,000,000	0.20	0.61	0.01
723181	永豐UP	---	---	---	---	---	0.45	0	0	0	0.35	0.36	10,000,000	0.36	1.13	0.01
723182	永豐UQ	---	---	---	---	---	0.16	0	0	0	0.12	0.13	13,000,000	0.13	0.54	0.01
723183	永豐UR	0.82	-0.04	0.80	0.82	0.78	0.80	104,000	82,960	13	0.81	0.82	12,000,000	0.82	1.34	0.30
723184	YJ元富	0.37	0.00	0.38	0.38	0.36	0.38	115,000	43,450	3	0.37	0.38	5,000,000	0.37	0.84	0.01
723185	YK元富	---	---	---	---	---	0.50	0	0	0	0.45	0.46	5,000,000	0.46	1.09	0.01
723186	永昌ZM	0.67	+0.05	0.71	0.71	0.66	0.68	216,000	147,900	13	0.67	0.77	10,000,000	0.67	1.63	0.01
723187	永昌ZN	0.71	-0.08	0.68	0.71	0.68	0.69	199,000	138,290	2	0.69	0.70	5,000,000	0.71	1.67	0.01
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
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
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
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
723248	永豐VE	---	---	---	---	---	0.32	0	0	0	0.19	0.20	9,500,000	0.20	0.89	0.01
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