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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
716786	TD兆豐	0.11	-0.02	0.11	0.12	0.10	0.11	65,000	7,350	7	0.10	0.13	5,000,000	0.11	0.75	0.01
716787	元證QP	---	---	---	---	---	0.15	0	0	0	0.00	0.02	5,000,000	0.02	0.67	0.01
716788	元證QQ	---	---	---	---	---	0.15	0	0	0	0.00	0.02	5,000,000	0.02	0.71	0.01
716789	元證QR	---	---	---	---	---	0.20	0	0	0	0.01	0.11	20,000,000	0.11	0.53	0.01
716790	元證QS	---	---	---	---	---	0.04	0	0	0	0.02	0.03	5,000,000	0.03	1.19	0.01
716791	元證QT	---	---	---	---	---	0.10	0	0	0	0.09	0.10	5,000,000	0.09	0.63	0.01
716792	國泰QE	---	---	---	---	---	0.38	0	0	0	0.10	0.15	5,000,000	0.15	0.84	0.01
716793	國泰QI	---	---	---	---	---	0.13	0	0	0	0.04	0.00	5,000,000	0.08	0.61	0.01
716794	國泰QJ	---	---	---	---	---	0.35	0	0	0	0.33	0.35	5,000,000	0.35	1.70	0.01
716795	元富Z3	---	---	---	---	---	0.04	0	0	0	0.00	0.00	5,000,000	0.04	0.45	0.01
716796	元富Z4	---	---	---	---	---	0.10	0	0	0	0.03	0.00	5,000,000	0.08	0.63	0.01
716797	元富Z5	---	---	---	---	---	0.29	0	0	0	0.01	0.04	5,000,000	0.04	0.64	0.01
716798	元富Z6	1.03	+0.32	0.87	1.08	0.87	1.00	96,000	96,320	10	0.99	1.02	10,000,000	1.03	1.86	0.20
716799	元富Z7	0.86	-0.02	0.60	0.86	0.60	0.73	2,000	1,460	2	0.82	0.85	5,000,000	0.86	1.99	0.01
716800	日盛UN	---	---	---	---	---	0.02	0	0	0	0.01	0.03	5,000,000	0.02	0.26	0.01
716801	日盛US	---	---	---	---	---	0.04	0	0	0	0.01	0.02	5,000,000	0.02	0.74	0.01
716802	SE永豐	---	---	---	---	---	0.08	0	0	0	0.01	0.03	13,000,000	0.03	0.44	0.01
716803	SJ永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.28	0.01
716804	SU永豐	---	---	---	---	---	1.57	0	0	0	0.97	1.06	5,000,000	1.03	1.50	0.56
716805	SV永豐	2.58	+0.06	2.44	2.58	2.44	2.55	35,000	89,400	3	2.68	2.75	11,000,000	2.58	4.51	0.65
716806	SW永豐	---	---	---	---	---	0.08	0	0	0	0.06	0.10	5,000,000	0.09	0.49	0.01
716807	SX永豐	---	---	---	---	---	1.01	0	0	0	0.51	0.55	5,000,000	0.55	1.68	0.01
716808	SY永豐	1.15	-0.05	1.26	1.27	1.15	1.20	132,000	158,870	11	1.14	1.15	5,000,000	1.15	2.04	0.26
716809	SZ永豐	---	---	---	---	---	0.02	0	0	0	0.01	0.02	5,000,000	0.02	0.79	0.01
716810	TA永豐	---	---	---	---	---	0.20	0	0	0	0.06	0.07	5,000,000	0.06	0.86	0.01
716811	TB永豐	---	---	---	---	---	0.13	0	0	0	0.07	0.08	12,000,000	0.08	1.16	0.01
716812	TC永豐	---	---	---	---	---	11.30	0	0	0	10.80	11.30	11,000,000	10.80	13.00	8.55
716813	統一P8	0.19	-0.04	0.18	0.19	0.18	0.18	83,000	14,970	2	0.18	0.19	5,000,000	0.19	0.53	0.01
716814	統一P9	---	---	---	---	---	0.12	0	0	0	0.02	0.05	5,000,000	0.05	0.34	0.01
716815	統一Q1	0.09	0.00	0.09	0.09	0.09	0.09	100,000	9,000	3	0.09	0.10	5,000,000	0.09	0.42	0.01
716816	統一Q2	0.70	-0.04	0.59	0.70	0.48	0.60	658,000	396,810	47	0.64	0.70	15,000,000	0.70	1.23	0.16
716817	統一Q3	0.94	+0.11	0.73	0.94	0.73	0.86	197,000	169,940	11	0.89	0.97	5,000,000	0.94	1.49	0.39
716818	統一Q4	---	---	---	---	---	0.01	0	0	0	0.01	0.05	13,000,000	0.01	0.61	0.01
716819	RS凱基	---	---	---	---	---	0.09	0	0	0	0.05	0.06	5,000,000	0.05	0.53	0.01
716820	RT凱基	---	---	---	---	---	0.04	0	0	0	0.00	0.02	5,000,000	0.02	0.46	0.01
716821	RW凱基	---	---	---	---	---	0.50	0	0	0	0.33	0.36	5,000,000	0.36	1.21	0.01
716822	康和XW	2.35	-0.63	2.35	2.35	2.35	2.35	10,000	23,500	1	2.89	2.98	5,000,000	2.35	3.88	0.82
716823	康和XX	---	---	---	---	---	0.01	0	0	0	0.00	0.10	5,000,000	0.01	0.61	0.01
716824	TD永豐	---	---	---	---	---	0.02	0	0	0	0.00	0.01	5,000,000	0.01	0.67	0.01
716825	TE永豐	---	---	---	---	---	0.09	0	0	0	0.00	0.01	5,000,000	0.01	0.60	0.01
716826	TF永豐	0.40	+0.04	0.09	0.40	0.09	0.32	40,000	12,900	2	0.39	0.42	11,000,000	0.40	1.82	0.01
716827	TG永豐	---	---	---	---	---	0.04	0	0	0	0.00	0.01	11,000,000	0.01	0.90	0.01
716828	元證QU	---	---	---	---	---	0.39	0	0	0	0.00	0.06	5,000,000	0.02	0.48	0.01
716829	元證QV	---	---	---	---	---	0.48	0	0	0	0.00	0.02	5,000,000	0.02	0.94	0.01
716830	元證QW	---	---	---	---	---	0.05	0	0	0	0.00	0.10	5,000,000	0.02	0.52	0.01
716831	元證QX	---	---	---	---	---	0.02	0	0	0	0.00	0.00	5,000,000	0.02	0.79	0.01
716832	元證QY	---	---	---	---	---	0.07	0	0	0	0.00	0.02	5,000,000	0.02	0.35	0.01
716833	元證QZ	---	---	---	---	---	21.70	0	0	0	0.00	0.00	5,000,000	21.70	26.10	17.30
716834	國票PK	---	---	---	---	---	1.71	0	0	0	0.00	0.14	5,000,000	0.14	0.80	0.01
716835	國票PL	---	---	---	---	---	3.49	0	0	0	1.54	1.55	5,000,000	1.54	3.08	0.01
716836	國票PM	---	---	---	---	---	0.02	0	0	0	0.00	0.01	5,000,000	0.01	0.81	0.01
716837	中信UY	---	---	---	---	---	0.26	0	0	0	0.04	0.05	5,000,000	0.05	0.34	0.01
716838	國泰QK	---	---	---	---	---	0.02	0	0	0	0.00	0.00	5,000,000	0.02	0.57	0.01
716839	國泰QL	0.69	+0.06	0.14	0.69	0.14	0.42	60,000	24,900	3	0.87	0.95	5,000,000	0.69	1.84	0.01
716840	群益WK	---	---	---	---	---	0.02	0	0	0	0.00	0.00	5,000,000	0.02	0.89	0.01
716841	群益WL	---	---	---	---	---	0.57	0	0	0	0.32	0.33	5,000,000	0.32	0.99	0.01
716842	群益WM	---	---	---	---	---	0.38	0	0	0	0.00	0.00	5,000,000	0.02	1.01	0.01
716843	RX凱基	---	---	---	---	---	0.07	0	0	0	0.00	0.02	5,000,000	0.02	1.23	0.01
716844	RY凱基	---	---	---	---	---	2.45	0	0	0	2.50	0.00	5,000,000	2.50	3.54	1.45
716845	RZ凱基	---	---	---	---	---	0.14	0	0	0	0.02	0.03	5,000,000	0.03	0.39	0.01
716846	SA凱基	---	---	---	---	---	0.01	0	0	0	0.00	0.02	5,000,000	0.01	0.57	0.01
716847	SB凱基	---	---	---	---	---	0.06	0	0	0	0.00	0.10	5,000,000	0.06	0.47	0.01
716848	富邦WB	---	---	---	---	---	0.01	0	0	0	0.00	0.01	10,000,000	0.01	0.40	0.01
716849	富邦WC	---	---	---	---	---	0.12	0	0	0	0.06	0.10	10,000,000	0.08	0.83	0.01
716850	富邦WD	---	---	---	---	---	0.03	0	0	0	0.00	0.05	5,000,000	0.03	0.73	0.01
716851	富邦WE	---	---	---	---	---	0.02	0	0	0	0.00	0.02	10,000,000	0.02	0.81	0.01
716852	元富Z8	---	---	---	---	---	0.05	0	0	0	0.00	0.02	8,000,000	0.01	0.47	0.01
716853	元富Z9	---	---	---	---	---	3.11	0	0	0	1.54	1.57	5,000,000	1.54	3.08	0.01
716854	中信UZ	---	---	---	---	---	0.52	0	0	0	0.33	0.34	10,000,000	0.34	1.69	0.01
716855	中信VA	---	---	---	---	---	0.55	0	0	0	0.16	0.17	10,000,000	0.17	1.02	0.01
716856	元證RA	---	---	---	---	---	0.39	0	0	0	0.00	0.06	15,000,000	0.06	1.38	0.01
716857	元證RB	---	---	---	---	---	3.84	0	0	0	0.20	0.21	10,000,000	0.21	2.33	0.01
716858	元證RC	---	---	---	---	---	0.33	0	0	0	0.15	0.16	5,000,000	0.16	0.79	0.01
716859	元證RD	---	---	---	---	---	0.15	0	0	0	0.00	0.10	15,000,000	0.05	0.69	0.01
716860	元證RE	---	---	---	---	---	0.11	0	0	0	0.00	0.01	20,000,000	0.01	0.72	0.01
716861	富邦WF	---	---	---	---	---	0.18	0	0	0	0.00	0.05	5,000,000	0.05	0.72	0.01
716862	富邦WG	---	---	---	---	---	0.04	0	0	0	0.01	0.10	5,000,000	0.03	0.60	0.01
716863	富邦WH	---	---	---	---	---	3.50	0	0	0	1.94	2.00	10,000,000	1.94	3.48	0.40
716864	群益WP	---	---	---	---	---	11.00	0	0	0	13.40	13.90	5,000,000	13.40	16.00	10.80
716865	群益WQ	---	---	---	---	---	0.06	0	0	0	0.00	0.00	5,000,000	0.02	1.44	0.01
716866	群益WR	---	---	---	---	---	0.03	0	0	0	0.00	0.00	5,000,000	0.01	0.29	0.01
716867	群益WS	---	---	---	---	---	2.16	0	0	0	3.13	0.00	5,000,000	3.13	4.58	1.66
716868	康和XY	---	---	---	---	---	1.15	0	0	0	0.01	0.11	10,000,000	0.11	1.21	0.01
716869	TH永豐	0.18	0.00	0.18	0.18	0.18	0.18	40,000	7,200	1	0.54	0.56	11,000,000	0.18	1.08	0.01
716870	TI永豐	0.79	+0.08	0.61	0.79	0.61	0.73	505,000	367,540	17	0.75	0.78	5,000,000	0.79	1.20	0.37
716871	TJ永豐	---	---	---	---	---	0.08	0	0	0	0.01	0.02	5,000,000	0.02	0.21	0.01
716872	TK永豐	---	---	---	---	---	0.22	0	0	0	0.00	0.01	11,000,000	0.01	1.29	0.01
716873	TL永豐	---	---	---	---	---	0.02	0	0	0	0.00	0.01	5,000,000	0.01	0.84	0.01
716874	國泰QM	---	---	---	---	---	0.06	0	0	0	0.02	0.10	5,000,000	0.06	0.76	0.01
716875	國泰QN	4.36	+0.54	4.22	4.36	4.22	4.29	4,000	17,160	2	4.34	4.44	5,000,000	4.36	6.75	1.95
716876	國泰QP	---	---	---	---	---	0.57	0	0	0	0.50	0.00	11,700,000	0.55	0.82	0.28
716877	元富PB	---	---	---	---	---	0.02	0	0	0	0.00	0.00	5,000,000	0.02	0.86	0.01
716878	元富PC	---	---	---	---	---	0.03	0	0	0	0.01	0.04	5,000,000	0.03	0.66	0.01
716879	統一Q5	---	---	---	---	---	0.05	0	0	0	0.01	0.05	5,000,000	0.04	0.54	0.01
716880	統一Q6	---	---	---	---	---	0.27	0	0	0	0.17	0.27	15,000,000	0.22	0.78	0.01
716883	SC凱基	1.85	-1.70	1.85	1.85	1.85	1.85	10,000	18,500	1	2.94	3.04	5,000,000	1.85	3.55	0.15
716884	統一Q7	---	---	---	---	---	0.79	0	0	0	0.29	0.38	15,000,000	0.38	1.30	0.01
716885	中信VB	---	---	---	---	---	3.05	0	0	0	2.23	2.25	5,000,000	2.23	3.61	0.85
716886	群益WU	---	---	---	---	---	1.46	0	0	0	1.27	1.36	7,000,000	1.28	2.53	0.03
716887	群益WV	---	---	---	---	---	0.01	0	0	0	0.00	0.00	5,000,000	0.01	1.37	0.01