SQL: SELECT * FROM this ORDER BY _id_ ASC || 上櫃股票行情

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
716954	國票PR	---	---	---	---	---	0.26	0	0	0	0.01	0.02	5,000,000	0.02	0.76	0.01
716955	元證RK	---	---	---	---	---	0.01	0	0	0	0.00	0.02	5,000,000	0.01	0.41	0.01
716956	元證RL	---	---	---	---	---	0.21	0	0	0	0.01	0.02	5,000,000	0.02	1.02	0.01
716957	元證RM	---	---	---	---	---	0.03	0	0	0	0.00	0.00	20,000,000	0.01	0.73	0.01
716958	元證RN	---	---	---	---	---	0.11	0	0	0	0.00	0.02	5,000,000	0.02	0.98	0.01
716959	元證RP	---	---	---	---	---	3.40	0	0	0	2.61	2.62	5,000,000	2.62	3.77	1.47
716960	元證RQ	---	---	---	---	---	0.09	0	0	0	0.00	0.02	6,000,000	0.02	1.41	0.01
716961	元證RR	---	---	---	---	---	6.97	0	0	0	0.00	7.35	5,000,000	7.35	8.60	6.10
716962	UE永豐	0.04	+0.02	0.01	0.04	0.01	0.04	104,000	4,010	2	0.02	0.03	12,000,000	0.04	1.36	0.01
716963	UF永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	13,000,000	0.01	0.22	0.01
716964	UG永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.45	0.01
716965	UH永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.42	0.01
716966	UI永豐	---	---	---	---	---	0.05	0	0	0	0.00	0.02	13,000,000	0.01	0.75	0.01
716967	UJ永豐	---	---	---	---	---	0.04	0	0	0	0.00	0.02	12,000,000	0.01	0.43	0.01
716968	群益P7	---	---	---	---	---	0.14	0	0	0	0.01	0.02	5,000,000	0.02	1.38	0.01
716969	群益P8	---	---	---	---	---	0.08	0	0	0	0.01	0.02	5,000,000	0.02	0.99	0.01
716970	國票PS	---	---	---	---	---	1.59	0	0	0	2.57	2.58	5,000,000	2.58	3.60	1.56
716971	國票PT	---	---	---	---	---	0.27	0	0	0	0.00	0.01	5,000,000	0.01	0.45	0.01
716972	國票PU	0.10	+0.06	0.08	0.10	0.08	0.08	11,000	900	3	0.00	0.01	5,000,000	0.10	0.95	0.01
716973	元證RT	1.66	-0.08	1.40	1.69	1.40	1.60	496,000	791,220	4	1.69	1.71	5,000,000	1.66	2.81	0.51
716974	元證RU	---	---	---	---	---	0.03	0	0	0	0.00	0.02	12,000,000	0.02	0.64	0.01
716975	元證RV	---	---	---	---	---	0.25	0	0	0	0.02	0.12	5,000,000	0.12	0.97	0.01
716976	元證RW	---	---	---	---	---	0.24	0	0	0	0.00	0.02	10,000,000	0.02	1.22	0.01
716977	SK凱基	---	---	---	---	---	0.03	0	0	0	0.01	0.02	5,000,000	0.02	0.70	0.01
716978	富邦WL	---	---	---	---	---	0.36	0	0	0	0.28	0.33	10,000,000	0.33	1.27	0.01
716979	富邦WM	---	---	---	---	---	0.20	0	0	0	0.00	0.02	5,000,000	0.02	1.28	0.01
716980	統一R4	---	---	---	---	---	0.01	0	0	0	0.01	0.05	5,000,000	0.01	0.45	0.01
716981	TK兆豐	---	---	---	---	---	0.08	0	0	0	0.00	0.02	5,000,000	0.02	0.69	0.01
716982	日盛UU	0.12	-0.04	0.12	0.12	0.12	0.12	5,000	600	1	0.09	0.12	5,000,000	0.12	0.67	0.01
716983	日盛UV	---	---	---	---	---	1.12	0	0	0	0.12	0.21	5,000,000	0.12	1.27	0.01
716984	日盛UW	---	---	---	---	---	0.53	0	0	0	0.02	0.07	5,000,000	0.07	0.92	0.01
716985	日盛UX	1.71	-0.61	1.69	1.71	1.69	1.70	20,000	34,000	2	2.14	2.18	5,000,000	1.71	2.90	0.52
716986	日盛UY	---	---	---	---	---	0.02	0	0	0	0.00	0.00	5,000,000	0.02	1.39	0.01
716987	日盛UZ	---	---	---	---	---	0.09	0	0	0	0.00	0.00	5,000,000	0.02	0.72	0.01
716988	元富PL	---	---	---	---	---	0.09	0	0	0	0.07	0.08	5,000,000	0.08	0.75	0.01
716989	元富PM	---	---	---	---	---	0.15	0	0	0	0.03	0.04	5,000,000	0.04	0.33	0.01
716990	元證RX	---	---	---	---	---	0.29	0	0	0	0.00	0.00	5,000,000	0.02	0.45	0.01
716991	元證RY	---	---	---	---	---	0.18	0	0	0	0.08	0.17	12,000,000	0.17	1.92	0.01
716992	元證RZ	0.52	+0.08	0.27	0.56	0.27	0.43	470,000	201,100	17	0.51	0.00	5,000,000	0.52	2.22	0.01
716993	元證SA	---	---	---	---	---	0.03	0	0	0	0.00	0.02	10,000,000	0.02	0.60	0.01
716994	元證SB	---	---	---	---	---	0.17	0	0	0	0.00	0.02	10,000,000	0.02	0.49	0.01
716995	元證SC	---	---	---	---	---	0.08	0	0	0	0.00	0.02	5,000,000	0.02	0.80	0.01
716996	UK永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	11,000,000	0.01	0.95	0.01
716997	UL永豐	---	---	---	---	---	0.15	0	0	0	0.07	0.08	5,000,000	0.08	0.45	0.01
716998	UM永豐	---	---	---	---	---	0.64	0	0	0	0.04	0.06	5,000,000	0.06	0.78	0.01
716999	UN永豐	---	---	---	---	---	0.02	0	0	0	0.00	0.01	12,000,000	0.01	0.27	0.01
71699P	凱基ZA	---	---	---	---	---	0.09	0	0	0	0.00	0.02	5,000,000	0.02	1.34	0.01
717000	UP永豐	---	---	---	---	---	0.14	0	0	0	0.00	0.01	5,000,000	0.01	0.36	0.01
717001	UQ永豐	0.43	-0.02	0.23	0.47	0.22	0.25	430,000	106,710	8	0.42	0.45	5,000,000	0.43	1.64	0.01
717002	UR永豐	---	---	---	---	---	0.02	0	0	0	0.00	0.01	13,000,000	0.01	0.55	0.01
717003	US永豐	---	---	---	---	---	0.03	0	0	0	0.00	0.01	5,000,000	0.01	0.47	0.01
717004	UT永豐	0.74	-0.04	0.74	0.74	0.74	0.74	10,000	7,400	1	0.74	0.80	5,000,000	0.74	1.44	0.04
717005	統一R5	0.36	-0.02	0.28	0.39	0.28	0.34	1,417,000	487,490	27	0.34	0.35	13,000,000	0.36	1.02	0.01
717006	SP凱基	---	---	---	---	---	0.03	0	0	0	0.00	0.02	5,000,000	0.02	0.84	0.01
717007	日盛VA	---	---	---	---	---	0.05	0	0	0	0.01	0.03	12,000,000	0.03	1.17	0.01
717008	元富PN	0.15	-0.01	0.14	0.15	0.14	0.15	30,000	4,400	3	0.14	0.15	5,000,000	0.15	0.89	0.01
717009	元富PP	0.21	-0.03	0.15	0.25	0.15	0.21	260,000	53,650	22	0.21	0.22	5,000,000	0.21	1.14	0.01
71700P	中信UH	---	---	---	---	---	0.01	0	0	0	0.00	0.01	6,000,000	0.01	3.87	0.01
717010	群益Q1	---	---	---	---	---	0.02	0	0	0	0.00	0.00	6,000,000	0.02	0.84	0.01
717011	中信VD	0.37	-0.20	0.37	0.37	0.37	0.37	20,000	7,400	1	0.41	0.44	5,000,000	0.37	1.13	0.01
717012	國票PW	---	---	---	---	---	0.68	0	0	0	0.00	0.00	5,000,000	0.25	0.65	0.01
717013	統一R6	---	---	---	---	---	0.07	0	0	0	0.04	0.05	14,000,000	0.05	0.40	0.01
717014	統一R7	1.00	+0.05	0.93	1.15	0.85	1.01	376,000	380,870	53	0.98	1.00	5,000,000	1.00	1.66	0.34
717015	統一R8	---	---	---	---	---	0.10	0	0	0	0.06	0.07	5,000,000	0.07	0.35	0.01
717016	統一R9	0.20	0.00	0.16	0.20	0.14	0.18	195,000	35,800	18	0.19	0.20	5,000,000	0.20	0.66	0.01
717017	SQ凱基	---	---	---	---	---	0.71	0	0	0	0.05	0.15	5,000,000	0.15	1.00	0.01
717018	元證SD	0.11	-0.09	0.01	0.11	0.01	0.06	2,000	120	2	0.00	0.01	5,100,000	0.11	0.99	0.01
717019	元證SE	---	---	---	---	---	0.24	0	0	0	0.00	0.04	15,000,000	0.02	1.16	0.01
71701P	中信UJ	---	---	---	---	---	0.31	0	0	0	0.15	0.17	10,000,000	0.17	2.97	0.01
717020	元證SF	---	---	---	---	---	0.13	0	0	0	0.00	0.02	5,000,000	0.02	0.65	0.01
717021	元證SG	---	---	---	---	---	0.04	0	0	0	0.00	0.02	5,000,000	0.02	0.78	0.01
717022	富邦WN	0.77	+0.03	0.77	0.77	0.77	0.77	1,000	770	1	0.76	0.80	5,000,000	0.77	1.26	0.28
717023	富邦WP	---	---	---	---	---	0.21	0	0	0	0.00	0.02	10,000,000	0.02	0.65	0.01
717024	富邦WQ	---	---	---	---	---	0.69	0	0	0	0.96	1.01	10,000,000	0.96	2.31	0.01
717025	富邦WR	1.22	+0.16	0.87	1.22	0.87	1.02	8,000	8,140	6	1.22	1.32	5,000,000	1.22	2.25	0.19
717026	UU永豐	---	---	---	---	---	0.03	0	0	0	0.00	0.02	12,000,000	0.01	0.64	0.01
717027	TL兆豐	0.13	-0.01	0.13	0.13	0.13	0.13	20,000	2,600	2	0.13	0.14	5,000,000	0.13	0.95	0.01
717028	TM兆豐	---	---	---	---	---	0.67	0	0	0	0.00	0.02	5,000,000	0.02	0.95	0.01
717029	TN兆豐	---	---	---	---	---	0.09	0	0	0	0.02	0.03	5,000,000	0.03	0.63	0.01
717030	元富PR	0.48	0.00	0.30	0.53	0.30	0.42	323,000	134,860	24	0.46	0.48	5,000,000	0.48	1.12	0.01
717031	群益Q4	---	---	---	---	---	0.08	0	0	0	0.00	0.00	10,000,000	0.02	1.43	0.01
717032	群益Q5	0.56	+0.23	0.41	0.56	0.41	0.48	20,000	9,700	2	0.56	0.57	8,000,000	0.56	1.56	0.01
717033	群益Q6	---	---	---	---	---	0.01	0	0	0	0.00	0.00	5,000,000	0.01	0.58	0.01
717034	群益Q7	---	---	---	---	---	0.09	0	0	0	0.00	0.00	7,000,000	0.02	0.82	0.01
717035	群益Q8	0.02	0.00	0.02	0.02	0.02	0.02	243,000	4,860	3	0.01	0.02	7,000,000	0.02	1.16	0.01
717036	群益Q9	0.04	-0.10	0.04	0.04	0.04	0.04	10,000	400	1	0.05	0.06	5,000,000	0.04	1.00	0.01
717037	國泰QX	0.14	-0.08	0.17	0.17	0.14	0.16	12,000	1,980	2	0.14	0.22	5,000,000	0.14	1.41	0.01
717038	國票PX	0.85	+0.09	0.53	0.87	0.53	0.75	761,000	572,610	8	0.82	0.83	5,000,000	0.85	2.00	0.01
717039	元證SH	---	---	---	---	---	3.18	0	0	0	2.79	2.89	10,000,000	2.89	4.06	1.72
717040	元證SJ	---	---	---	---	---	0.51	0	0	0	0.00	0.06	5,000,000	0.02	0.80	0.01
717041	永昌XY	---	---	---	---	---	1.32	0	0	0	0.49	0.53	20,000,000	0.49	1.26	0.01
717042	統一S1	1.44	-0.01	1.08	1.44	1.06	1.16	298,000	345,560	7	1.46	1.49	15,000,000	1.44	2.41	0.47
717043	SR凱基	---	---	---	---	---	0.02	0	0	0	0.00	0.05	5,000,000	0.03	0.75	0.01
717044	SS凱基	---	---	---	---	---	2.71	0	0	0	2.38	2.46	10,000,000	2.38	3.35	1.41
717045	ST凱基	---	---	---	---	---	3.62	0	0	0	2.88	2.98	10,000,000	2.88	3.85	1.91
717046	UV永豐	---	---	---	---	---	2.25	0	0	0	1.37	1.46	11,000,000	1.39	2.75	0.03
717047	UW永豐	---	---	---	---	---	1.73	0	0	0	1.53	1.63	12,000,000	1.53	2.60	0.46
717048	元富PS	0.32	-0.15	0.27	0.35	0.25	0.29	432,000	126,810	11	0.32	0.33	5,000,000	0.32	0.80	0.01
717049	元富PT	4.09	-0.13	3.58	4.09	3.58	3.85	18,000	69,290	3	4.27	4.37	5,000,000	4.09	4.84	3.33
717050	國票PY	---	---	---	---	---	3.28	0	0	0	1.90	1.91	10,000,000	1.90	2.87	0.93