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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
717457	日盛WH	---	---	---	---	---	0.15	0	0	0	0.10	0.11	5,000,000	0.11	0.72	0.01
717458	RA元大	---	---	---	---	---	0.16	0	0	0	0.00	0.00	5,000,000	0.11	0.65	0.01
717459	RB元大	---	---	---	---	---	0.07	0	0	0	0.04	0.05	5,000,000	0.05	0.57	0.01
71745P	元大W7	0.86	+0.38	0.83	0.86	0.83	0.85	3,000	2,550	2	0.83	0.86	5,000,000	0.86	1.77	0.01
717460	RC元大	---	---	---	---	---	11.40	0	0	0	0.00	19.00	5,000,000	19.00	22.00	16.00
717461	RG元大	0.09	-0.02	0.10	0.11	0.09	0.10	199,000	20,230	4	0.08	0.09	5,000,000	0.09	0.95	0.01
717462	RH元大	---	---	---	---	---	0.12	0	0	0	0.03	0.13	5,000,000	0.11	0.71	0.01
717463	RK元大	0.20	+0.06	0.13	0.20	0.11	0.18	115,000	20,800	5	0.20	0.21	5,000,000	0.20	0.76	0.01
717464	P8富邦	0.17	+0.01	0.09	0.17	0.09	0.09	21,000	1,970	2	0.14	0.17	5,000,000	0.17	0.87	0.01
717465	P9富邦	---	---	---	---	---	3.55	0	0	0	1.31	1.41	10,000,000	1.41	2.29	0.53
717466	Q1富邦	---	---	---	---	---	0.07	0	0	0	0.02	0.05	10,000,000	0.05	0.71	0.01
717467	Q2富邦	---	---	---	---	---	0.06	0	0	0	0.06	0.07	10,000,000	0.06	0.86	0.01
717468	Q3富邦	---	---	---	---	---	12.85	0	0	0	12.70	13.50	5,000,000	13.00	15.20	10.80
717469	Q4富邦	---	---	---	---	---	0.13	0	0	0	0.01	0.05	10,000,000	0.05	0.55	0.01
71746P	元大W8	---	---	---	---	---	0.29	0	0	0	0.00	0.02	6,000,000	0.02	1.34	0.01
717470	元富RG	0.17	-0.12	0.17	0.17	0.17	0.17	20,000	3,400	1	0.18	0.20	5,000,000	0.17	0.81	0.01
717471	元富RJ	---	---	---	---	---	1.61	0	0	0	1.40	1.42	5,000,000	1.42	2.45	0.39
717472	XJ永豐	---	---	---	---	---	0.07	0	0	0	0.04	0.05	11,000,000	0.05	0.61	0.01
717473	XK永豐	---	---	---	---	---	1.34	0	0	0	1.24	1.31	12,000,000	1.31	2.12	0.50
717474	XL永豐	---	---	---	---	---	0.10	0	0	0	0.07	0.11	5,000,000	0.10	0.83	0.01
717475	XM永豐	---	---	---	---	---	0.03	0	0	0	0.01	0.02	5,000,000	0.02	0.51	0.01
717476	XN永豐	---	---	---	---	---	12.40	0	0	0	9.90	10.70	5,000,000	9.95	11.80	8.05
717477	XP永豐	0.22	-0.08	0.13	0.22	0.13	0.16	654,000	104,060	10	0.21	0.22	11,000,000	0.22	1.09	0.01
717478	XQ永豐	---	---	---	---	---	0.14	0	0	0	0.08	0.09	11,000,000	0.09	0.57	0.01
717479	TP第一	---	---	---	---	---	11.10	0	0	0	17.20	18.10	5,000,000	17.40	20.90	13.90
71747P	國泰TO	---	---	---	---	---	3.25	0	0	0	3.41	0.00	5,000,000	3.41	4.12	2.70
717480	國泰RN	0.07	0.00	0.07	0.07	0.07	0.07	8,000	560	1	0.02	0.07	5,000,000	0.07	0.67	0.01
717481	國泰RP	---	---	---	---	---	24.20	0	0	0	0.00	0.00	5,000,000	21.80	24.80	18.80
717482	PY群益	0.49	-0.15	0.49	0.49	0.49	0.49	10,000	4,900	1	0.52	0.61	10,000,000	0.49	1.43	0.01
717483	統一W1	---	---	---	---	---	0.35	0	0	0	0.32	0.37	15,000,000	0.35	1.21	0.01
717484	統一W2	---	---	---	---	---	6.70	0	0	0	6.95	7.35	5,000,000	6.95	8.25	5.65
717485	UL凱基	---	---	---	---	---	0.12	0	0	0	0.12	0.13	5,000,000	0.12	0.56	0.01
717486	UM凱基	---	---	---	---	---	0.17	0	0	0	0.12	0.17	5,000,000	0.17	1.02	0.01
717487	UN凱基	---	---	---	---	---	0.27	0	0	0	0.24	0.28	5,000,000	0.28	1.16	0.01
717488	TQ第一	5.55	-1.15	5.55	5.55	5.55	5.55	9,000	49,950	1	6.50	6.95	5,000,000	5.55	6.75	4.33
717489	國票QN	0.14	+0.01	0.08	0.14	0.08	0.12	1,589,000	197,560	51	0.13	0.14	13,000,000	0.14	0.78	0.01
71748P	康和XC	---	---	---	---	---	0.06	0	0	0	0.00	0.01	5,000,000	0.01	0.86	0.01
717490	國票QP	---	---	---	---	---	0.46	0	0	0	0.24	0.25	5,000,000	0.25	0.97	0.01
717491	XR永豐	---	---	---	---	---	3.52	0	0	0	2.65	2.75	5,000,000	2.72	3.85	1.59
717492	XS永豐	---	---	---	---	---	0.09	0	0	0	0.04	0.05	5,000,000	0.05	0.58	0.01
717493	XT永豐	---	---	---	---	---	6.70	0	0	0	7.95	8.40	5,000,000	8.10	9.50	6.70
717494	日盛WJ	0.86	-0.26	0.87	0.87	0.86	0.86	20,000	17,300	2	0.86	0.96	5,000,000	0.86	1.86	0.01
717495	日盛WK	0.27	-0.04	0.27	0.28	0.27	0.27	28,000	7,660	3	0.21	0.24	5,000,000	0.27	1.52	0.01
717496	日盛WL	---	---	---	---	---	3.12	0	0	0	1.74	1.83	12,000,000	1.83	3.15	0.51
717497	日盛WM	0.70	-0.53	0.70	0.70	0.70	0.70	10,000	7,000	1	0.50	0.69	12,000,000	0.70	1.69	0.01
717498	統一W3	0.57	-0.13	0.51	0.60	0.51	0.56	264,000	147,230	7	0.56	0.57	13,000,000	0.57	1.41	0.01
717499	元富RK	---	---	---	---	---	10.20	0	0	0	7.50	8.00	5,000,000	7.75	9.05	6.45
71749P	富邦VH	---	---	---	---	---	0.06	0	0	0	0.01	0.05	10,000,000	0.05	0.96	0.01
717500	國泰RR	0.81	+0.01	0.75	0.81	0.75	0.78	291,000	227,810	4	0.79	0.87	5,000,000	0.81	2.17	0.01
717501	VL兆豐	---	---	---	---	---	0.41	0	0	0	0.19	0.20	5,000,000	0.20	0.89	0.01
717502	VM兆豐	---	---	---	---	---	0.15	0	0	0	0.04	0.07	5,000,000	0.07	0.76	0.01
717503	UP凱基	0.20	0.00	0.16	0.24	0.16	0.20	482,000	95,440	11	0.17	0.18	5,000,000	0.20	0.84	0.01
717504	RM元大	---	---	---	---	---	20.40	0	0	0	0.00	0.00	5,000,000	17.10	20.10	14.10
717505	RS元大	---	---	---	---	---	0.06	0	0	0	0.01	0.02	5,000,000	0.02	0.50	0.01
717506	RX元大	---	---	---	---	---	2.66	0	0	0	2.01	2.11	5,000,000	2.11	3.67	0.55
717507	RY元大	---	---	---	---	---	6.75	0	0	0	0.00	11.70	5,000,000	11.70	13.70	9.70
717508	RZ元大	0.01	-0.01	0.01	0.01	0.01	0.01	100,000	1,000	1	0.01	0.02	5,000,000	0.01	0.68	0.01
717509	日盛WN	0.33	-0.18	0.33	0.33	0.33	0.33	41,000	13,530	1	0.37	0.38	5,000,000	0.33	1.29	0.01
71750P	元大QB	---	---	---	---	---	0.05	0	0	0	0.02	0.03	5,000,000	0.03	0.72	0.01
717510	日盛WP	0.19	+0.02	0.19	0.19	0.19	0.19	1,000	190	1	0.15	0.18	5,000,000	0.19	0.66	0.01
717511	國泰RS	1.11	-0.01	0.37	1.11	0.37	0.49	351,000	170,960	21	1.11	0.00	5,000,000	1.11	2.17	0.05
717512	QA群益	0.28	-0.03	0.21	0.28	0.21	0.24	20,000	4,900	2	0.26	0.29	5,000,000	0.28	1.12	0.01
717513	統一W4	0.21	-0.04	0.16	0.22	0.16	0.19	178,000	33,040	8	0.20	0.21	5,000,000	0.21	0.87	0.01
717514	元富RL	---	---	---	---	---	0.21	0	0	0	0.06	0.07	10,000,000	0.07	0.73	0.01
717515	元富RM	0.03	-0.01	0.04	0.04	0.03	0.03	299,000	8,990	2	0.02	0.05	10,000,000	0.03	0.83	0.01
717516	元富RN	0.33	+0.01	0.17	0.34	0.16	0.26	890,000	230,800	40	0.32	0.35	5,000,000	0.33	0.95	0.01
717517	康和ZD	---	---	---	---	---	0.47	0	0	0	0.06	0.12	5,000,000	0.10	0.50	0.01
717518	康和ZE	---	---	---	---	---	0.27	0	0	0	0.02	0.10	10,000,000	0.10	0.92	0.01
717519	XU永豐	0.09	+0.02	0.05	0.09	0.05	0.06	461,000	28,290	6	0.08	0.09	12,000,000	0.09	1.06	0.01
71751P	元大QC	---	---	---	---	---	0.05	0	0	0	0.00	0.02	5,000,000	0.02	0.94	0.01
717520	XV永豐	0.06	+0.03	0.02	0.06	0.02	0.03	27,000	800	5	0.02	0.06	5,000,000	0.06	0.60	0.01
717521	XW永豐	---	---	---	---	---	4.00	0	0	0	2.31	2.40	5,000,000	2.32	3.22	1.42
717522	TR第一	---	---	---	---	---	0.04	0	0	0	0.04	0.11	14,000,000	0.04	1.25	0.01
717523	TS第一	---	---	---	---	---	0.05	0	0	0	0.01	0.10	9,000,000	0.05	2.07	0.01
717524	Q5富邦	---	---	---	---	---	0.13	0	0	0	0.16	0.17	5,000,000	0.16	0.73	0.01
717525	SH元大	1.77	+0.03	1.26	1.77	1.26	1.48	173,000	255,470	9	1.70	1.75	5,000,000	1.77	2.55	0.99
717526	SJ元大	0.24	+0.06	0.14	0.24	0.10	0.14	1,500,000	206,830	30	0.20	0.24	5,000,000	0.24	1.09	0.01
717527	元富RP	0.22	-0.09	0.23	0.23	0.21	0.22	80,000	17,700	3	0.26	0.28	10,000,000	0.22	0.88	0.01
717528	元富RQ	---	---	---	---	---	1.88	0	0	0	1.87	1.91	10,000,000	1.87	2.84	0.90
717529	元富RR	---	---	---	---	---	0.28	0	0	0	0.09	0.10	13,000,000	0.10	0.95	0.01
71752P	日盛SY	---	---	---	---	---	0.33	0	0	0	0.08	0.09	5,000,000	0.09	0.89	0.01
717530	元富RS	0.08	-0.03	0.06	0.08	0.06	0.07	142,000	9,350	4	0.06	0.07	5,000,000	0.08	0.99	0.01
717531	VN兆豐	0.16	-0.01	0.16	0.16	0.16	0.16	10,000	1,600	1	0.14	0.15	5,000,000	0.16	1.19	0.01
717532	康和ZG	0.11	-0.20	0.12	0.12	0.11	0.12	250,000	29,500	4	0.16	0.17	5,000,000	0.11	0.79	0.01
717533	康和ZH	---	---	---	---	---	0.37	0	0	0	0.21	0.22	10,000,000	0.22	1.00	0.01
717534	XX永豐	---	---	---	---	---	0.55	0	0	0	0.24	0.26	10,000,000	0.25	1.19	0.01
717535	XY永豐	---	---	---	---	---	0.04	0	0	0	0.01	0.03	5,000,000	0.03	0.49	0.01
717536	XZ永豐	---	---	---	---	---	0.07	0	0	0	0.02	0.04	5,000,000	0.04	0.54	0.01
717537	YA永豐	0.39	-0.45	0.36	0.39	0.36	0.39	130,000	50,670	2	0.49	0.53	11,000,000	0.39	1.37	0.01
717538	YB永豐	0.37	+0.01	0.25	0.37	0.24	0.32	1,082,000	341,490	20	0.34	0.36	12,000,000	0.37	1.01	0.01
717539	YC永豐	0.45	-0.12	0.45	0.45	0.45	0.45	10,000	4,500	1	0.46	0.48	13,000,000	0.45	1.19	0.01
71753P	元富U9	0.04	-0.07	0.04	0.04	0.04	0.04	10,000	400	1	0.04	0.05	5,000,000	0.04	0.96	0.01
717540	YD永豐	0.33	+0.05	0.28	0.33	0.19	0.25	650,000	161,500	7	0.31	0.34	6,088,000	0.33	0.73	0.01
717541	UQ凱基	---	---	---	---	---	0.08	0	0	0	0.02	0.04	5,000,000	0.03	0.83	0.01
717542	UR凱基	0.11	-0.02	0.11	0.11	0.11	0.11	100,000	11,000	1	0.11	0.13	5,000,000	0.11	1.10	0.01
717543	US凱基	0.05	+0.02	0.03	0.05	0.03	0.04	80,000	2,900	7	0.03	0.04	5,000,000	0.05	0.86	0.01
717544	日盛WQ	---	---	---	---	---	0.18	0	0	0	0.07	0.08	5,000,000	0.08	0.51	0.01
717545	日盛WR	0.11	+0.03	0.05	0.11	0.05	0.05	105,000	5,430	7	0.02	0.10	5,000,000	0.11	1.12	0.01
717546	日盛WS	---	---	---	---	---	0.04	0	0	0	0.03	0.04	5,000,000	0.03	0.83	0.01
717547	國票QQ	---	---	---	---	---	0.08	0	0	0	0.01	0.02	5,000,000	0.02	0.53	0.01