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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
717366	統一V3	0.27	+0.05	0.25	0.28	0.25	0.25	1,600,000	402,700	14	0.25	0.26	5,000,000	0.27	0.61	0.01
717367	TY凱基	0.04	-0.02	0.04	0.04	0.04	0.04	20,000	800	2	0.04	0.05	5,000,000	0.04	0.89	0.01
717368	UB凱基	---	---	---	---	---	0.25	0	0	0	0.02	0.03	5,000,000	0.03	0.84	0.01
717369	TZ凱基	---	---	---	---	---	2.77	0	0	0	1.70	1.79	5,000,000	1.71	3.09	0.33
71736P	國票ZT	---	---	---	---	---	0.30	0	0	0	0.00	0.01	5,000,000	0.01	0.72	0.01
717370	國票QJ	---	---	---	---	---	2.65	0	0	0	3.28	3.29	5,000,000	3.28	4.66	1.90
717371	QL元大	0.12	-0.12	0.12	0.12	0.12	0.12	50,000	6,000	1	0.00	0.00	5,000,000	0.12	1.44	0.01
717372	QM元大	---	---	---	---	---	0.10	0	0	0	0.07	0.12	5,000,000	0.10	0.91	0.01
717373	QQ元大	---	---	---	---	---	1.04	0	0	0	0.51	0.54	5,000,000	0.53	1.17	0.01
717374	QR元大	0.40	-0.20	0.32	0.40	0.32	0.37	251,000	92,320	2	0.00	0.00	5,000,000	0.40	1.34	0.01
717375	P6富邦	0.35	+0.03	0.17	0.35	0.15	0.20	86,000	16,840	10	0.16	0.35	5,000,000	0.35	1.23	0.01
717376	統一V4	1.90	+0.52	1.69	1.90	1.69	1.77	24,000	42,420	3	1.95	0.00	5,000,000	1.90	2.57	1.22
717377	統一V5	1.02	-0.23	1.05	1.09	1.00	1.02	22,000	22,530	4	1.06	1.08	13,000,000	1.02	1.68	0.36
717378	統一V6	---	---	---	---	---	0.19	0	0	0	0.15	0.16	12,000,000	0.16	0.50	0.01
717379	統一V7	---	---	---	---	---	0.18	0	0	0	0.03	0.05	5,000,000	0.05	0.42	0.01
71737P	元富T7	---	---	---	---	---	0.04	0	0	0	0.00	0.04	5,000,000	0.01	1.32	0.01
717380	元富RD	1.07	+0.13	1.07	1.07	1.07	1.07	20,000	21,400	1	0.11	0.00	5,000,000	1.07	2.45	0.01
717381	元富RE	1.48	-0.22	1.41	1.48	1.41	1.45	30,000	43,500	3	1.52	1.56	13,000,000	1.48	2.31	0.65
717382	康和YV	---	---	---	---	---	0.25	0	0	0	0.00	0.01	5,000,000	0.01	0.38	0.01
717383	康和YW	---	---	---	---	---	0.34	0	0	0	0.08	0.18	5,000,000	0.18	0.71	0.01
717384	WX永豐	---	---	---	---	---	0.03	0	0	0	0.02	0.03	12,000,000	0.03	0.35	0.01
717385	國泰RI	---	---	---	---	---	2.11	0	0	0	1.10	1.18	5,000,000	1.18	1.72	0.64
717386	PH群益	---	---	---	---	---	0.01	0	0	0	0.00	0.00	10,000,000	0.01	0.88	0.01
717387	PJ群益	---	---	---	---	---	0.50	0	0	0	0.33	0.63	5,000,000	0.47	1.14	0.01
717388	PK群益	---	---	---	---	---	2.30	0	0	0	0.58	0.60	7,000,000	0.60	1.26	0.01
717389	PL群益	---	---	---	---	---	0.54	0	0	0	0.01	0.07	7,000,000	0.07	0.64	0.01
71738P	RY兆豐	---	---	---	---	---	1.33	0	0	0	1.36	1.37	5,000,000	1.36	1.82	0.90
717390	PM群益	0.02	-0.10	0.02	0.02	0.02	0.02	2,000	40	1	0.04	0.07	5,000,000	0.02	1.43	0.01
717391	UV兆豐	---	---	---	---	---	1.16	0	0	0	0.46	0.50	5,000,000	0.50	1.44	0.01
717392	UW兆豐	0.16	-0.01	0.13	0.16	0.13	0.14	30,000	4,200	3	0.13	0.16	5,000,000	0.16	1.04	0.01
717393	UX兆豐	---	---	---	---	---	0.62	0	0	0	0.13	0.15	5,000,000	0.15	1.11	0.01
717394	UY兆豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.18	0.01
717395	UZ兆豐	---	---	---	---	---	0.14	0	0	0	0.02	0.03	5,000,000	0.03	0.57	0.01
717396	VA兆豐	---	---	---	---	---	0.30	0	0	0	0.10	0.11	5,000,000	0.11	1.11	0.01
717397	國泰RJ	4.58	-0.37	4.71	4.71	4.58	4.67	3,000	14,000	2	5.00	5.20	5,000,000	4.58	6.85	2.29
717398	日盛VY	---	---	---	---	---	0.18	0	0	0	0.02	0.03	5,000,000	0.03	0.49	0.01
717399	日盛WA	0.45	-0.48	0.45	0.45	0.45	0.45	3,000	1,350	1	0.52	0.62	5,000,000	0.45	1.55	0.01
71739P	元大V6	---	---	---	---	---	1.95	0	0	0	1.69	1.79	5,000,000	1.69	2.19	1.19
717400	QS元大	---	---	---	---	---	0.02	0	0	0	0.00	0.02	5,000,000	0.02	0.82	0.01
717401	QU元大	---	---	---	---	---	0.01	0	0	0	0.00	0.02	5,000,000	0.01	0.75	0.01
717402	PN群益	---	---	---	---	---	1.55	0	0	0	1.08	1.11	10,000,000	1.08	2.11	0.05
717403	PP群益	---	---	---	---	---	0.08	0	0	0	0.00	0.00	10,000,000	0.02	1.67	0.01
717404	元富RF	0.25	-0.15	0.21	0.30	0.17	0.25	230,000	56,400	23	0.07	0.39	5,000,000	0.25	1.13	0.01
717405	VB兆豐	---	---	---	---	---	0.02	0	0	0	0.00	0.02	5,000,000	0.02	0.87	0.01
717406	VC兆豐	---	---	---	---	---	0.06	0	0	0	0.04	0.06	5,000,000	0.06	1.16	0.01
717407	VD兆豐	0.07	-0.12	0.05	0.07	0.05	0.07	45,000	3,050	5	0.07	0.10	5,000,000	0.07	1.27	0.01
717408	VE兆豐	0.55	-0.16	0.27	0.55	0.26	0.41	60,000	24,500	4	0.77	0.86	5,000,000	0.55	2.48	0.01
717409	VF兆豐	---	---	---	---	---	0.04	0	0	0	0.00	0.02	5,000,000	0.02	0.58	0.01
71740P	元大W6	0.34	+0.07	0.35	0.35	0.34	0.34	11,000	3,750	2	0.00	0.50	5,000,000	0.34	0.92	0.01
717410	VG兆豐	---	---	---	---	---	4.05	0	0	0	0.00	0.00	5,000,000	4.81	6.00	3.62
717411	康和YX	---	---	---	---	---	0.12	0	0	0	0.05	0.10	5,000,000	0.10	0.37	0.01
717412	康和YY	---	---	---	---	---	0.14	0	0	0	0.01	0.10	20,000,000	0.03	0.84	0.01
717413	WY永豐	---	---	---	---	---	0.06	0	0	0	0.01	0.02	12,000,000	0.02	0.74	0.01
717414	WZ永豐	---	---	---	---	---	0.16	0	0	0	0.01	0.02	5,000,000	0.02	0.44	0.01
717415	UC凱基	---	---	---	---	---	2.35	0	0	0	0.67	0.72	5,000,000	0.72	1.60	0.01
717416	UD凱基	---	---	---	---	---	0.09	0	0	0	0.02	0.03	10,000,000	0.03	0.87	0.01
717417	UE凱基	0.38	-0.32	0.30	0.40	0.29	0.37	419,000	155,200	5	0.38	0.41	5,000,000	0.38	1.34	0.01
717418	UF凱基	---	---	---	---	---	0.11	0	0	0	0.00	0.02	5,000,000	0.02	0.76	0.01
717419	UG凱基	---	---	---	---	---	0.07	0	0	0	0.00	0.02	5,000,000	0.02	0.61	0.01
71741P	凱基ZU	---	---	---	---	---	1.22	0	0	0	1.56	1.66	5,000,000	1.56	2.12	1.00
717420	UH凱基	---	---	---	---	---	0.07	0	0	0	0.03	0.04	5,000,000	0.04	0.40	0.01
717421	QW元大	---	---	---	---	---	2.47	0	0	0	1.34	1.39	5,000,000	1.39	2.46	0.32
717422	QY元大	---	---	---	---	---	2.26	0	0	0	0.00	1.03	5,000,000	1.03	1.69	0.37
717423	P7富邦	0.20	-0.01	0.20	0.20	0.20	0.20	10,000	2,000	1	0.19	0.21	5,000,000	0.20	0.63	0.01
717424	國泰RK	0.61	-0.12	0.54	0.66	0.50	0.59	16,000	9,390	4	0.62	0.67	5,100,000	0.61	1.63	0.01
717425	PS群益	---	---	---	---	---	1.40	0	0	0	0.96	1.01	5,060,000	1.01	1.51	0.51
717426	PT群益	0.46	-0.08	0.41	0.46	0.41	0.44	149,000	65,940	7	0.48	0.49	5,000,000	0.46	2.87	0.01
717427	PU群益	0.19	+0.02	0.15	0.21	0.15	0.18	229,000	41,130	13	0.19	0.20	5,000,000	0.19	0.94	0.01
717428	統一V8	0.19	+0.04	0.19	0.19	0.19	0.19	168,000	31,920	1	0.18	0.19	5,000,000	0.19	0.64	0.01
717429	康和YM	0.10	-0.08	0.10	0.11	0.10	0.10	600,000	61,000	6	0.05	0.13	20,000,000	0.10	0.54	0.01
71742P	凱基ZV	---	---	---	---	---	1.03	0	0	0	0.99	1.09	5,000,000	0.99	1.41	0.57
717430	康和ZA	---	---	---	---	---	1.68	0	0	0	1.25	1.30	5,000,000	1.25	2.21	0.29
717431	康和ZB	---	---	---	---	---	0.24	0	0	0	0.05	0.15	5,000,000	0.15	0.84	0.01
717432	日盛WB	---	---	---	---	---	2.07	0	0	0	1.25	1.29	5,000,000	1.25	2.28	0.22
717433	日盛WC	0.06	-0.07	0.06	0.06	0.06	0.06	100,000	6,000	1	0.10	0.11	5,000,000	0.06	0.75	0.01
717434	日盛WD	0.07	-0.02	0.07	0.07	0.07	0.07	297,000	20,790	6	0.08	0.09	5,000,000	0.07	0.75	0.01
717435	QZ元大	0.10	-0.13	0.10	0.10	0.10	0.10	77,000	7,700	1	0.08	0.09	5,000,000	0.10	1.02	0.01
717436	VJ兆豐	0.10	+0.01	0.10	0.10	0.10	0.10	10,000	1,000	1	0.09	0.10	5,000,000	0.10	0.67	0.01
717437	VK兆豐	0.34	-0.07	0.32	0.34	0.32	0.33	30,000	9,800	2	0.33	0.34	5,000,000	0.34	1.20	0.01
717438	XA永豐	---	---	---	---	---	0.17	0	0	0	0.11	0.12	5,000,000	0.11	0.60	0.01
717439	XB永豐	---	---	---	---	---	0.21	0	0	0	0.21	0.22	5,000,000	0.21	0.91	0.01
71743P	元富U5	0.57	+0.20	0.57	0.57	0.57	0.57	1,000	570	1	0.59	0.60	5,000,000	0.57	1.42	0.01
717440	XC永豐	0.26	-0.24	0.27	0.27	0.25	0.26	149,000	38,290	6	0.25	0.26	5,000,000	0.26	0.89	0.01
717441	XD永豐	1.12	+0.17	0.86	1.16	0.86	1.08	251,000	271,620	11	1.08	1.12	11,000,000	1.12	1.89	0.33
717442	XE永豐	---	---	---	---	---	0.25	0	0	0	0.00	0.01	11,000,000	0.01	0.62	0.01
717443	XF永豐	---	---	---	---	---	1.70	0	0	0	1.16	1.23	13,000,000	1.16	2.13	0.19
717444	XG永豐	---	---	---	---	---	0.31	0	0	0	0.20	0.21	12,000,000	0.21	1.14	0.01
717445	TN第一	---	---	---	---	---	2.30	0	0	0	2.00	2.10	5,000,000	2.02	2.96	1.08
717446	國泰RM	0.18	-0.07	0.22	0.22	0.11	0.15	186,000	28,220	8	0.20	0.21	5,000,000	0.18	1.33	0.01
717447	PV群益	---	---	---	---	---	0.12	0	0	0	0.03	0.04	5,000,000	0.04	1.12	0.01
717448	PW群益	0.10	-0.01	0.07	0.10	0.07	0.08	25,000	1,900	2	0.08	0.09	10,000,000	0.10	1.35	0.01
717449	PX群益	0.59	-0.11	0.45	0.61	0.45	0.54	725,000	389,250	19	0.62	0.65	7,000,000	0.59	1.48	0.01
71744P	元大PQ	---	---	---	---	---	0.56	0	0	0	0.74	0.76	5,000,000	0.74	1.16	0.32
717450	統一V9	4.71	+0.03	3.97	4.71	3.89	4.05	59,000	238,970	6	4.67	4.76	5,000,000	4.71	5.50	3.90
717451	UJ凱基	---	---	---	---	---	0.22	0	0	0	0.06	0.11	5,000,000	0.11	0.59	0.01
717452	UK凱基	0.14	+0.02	0.14	0.14	0.14	0.14	100,000	14,000	1	0.14	0.15	5,000,000	0.14	0.74	0.01
717453	國票QM	---	---	---	---	---	2.23	0	0	0	1.87	1.88	5,000,000	1.87	3.25	0.49
717454	日盛WE	2.17	-0.54	1.95	2.20	1.95	2.07	199,000	412,770	3	2.00	2.05	5,000,000	2.17	3.42	0.92
717455	日盛WF	0.47	+0.02	0.46	0.47	0.46	0.46	51,000	23,470	2	0.46	0.47	5,000,000	0.47	1.11	0.01
717456	日盛WG	---	---	---	---	---	8.45	0	0	0	0.00	0.00	5,000,000	16.00	18.00	14.00