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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
721993	XH第一	---	---	---	---	---	0.39	0	0	0	0.01	0.10	12,000,000	0.10	0.96	0.01
721994	P4元大	---	---	---	---	---	0.11	0	0	0	0.00	0.00	5,000,000	0.01	0.43	0.01
721995	P5元大	---	---	---	---	---	0.03	0	0	0	0.00	0.04	5,000,000	0.02	0.40	0.01
721996	P6元大	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.87	0.01
721997	元大WT	---	---	---	---	---	0.05	0	0	0	0.03	0.04	5,000,000	0.04	0.83	0.01
721998	中信YH	---	---	---	---	---	0.02	0	0	0	0.00	0.02	5,000,000	0.02	1.74	0.01
721999	RX群益	---	---	---	---	---	0.41	0	0	0	0.00	0.00	5,000,000	0.10	0.76	0.01
722000	RY群益	---	---	---	---	---	0.08	0	0	0	0.02	0.05	10,000,000	0.05	0.76	0.01
722001	SA群益	---	---	---	---	---	0.01	0	0	0	0.00	0.00	5,000,000	0.01	0.39	0.01
722002	SB群益	---	---	---	---	---	0.30	0	0	0	0.00	0.00	5,000,000	0.10	0.37	0.01
722003	SC群益	---	---	---	---	---	0.44	0	0	0	0.00	0.00	10,000,000	0.10	0.56	0.01
722004	WV日盛	---	---	---	---	---	0.06	0	0	0	0.01	0.02	5,000,000	0.02	0.55	0.01
722005	WW日盛	---	---	---	---	---	0.02	0	0	0	0.02	0.03	5,000,000	0.03	0.18	0.01
722006	永豐S6	0.13	-0.03	0.13	0.13	0.13	0.13	30,000	3,900	1	0.11	0.12	5,000,000	0.13	0.47	0.01
722007	SE群益	---	---	---	---	---	0.02	0	0	0	0.00	0.01	5,000,000	0.01	0.33	0.01
722008	兆豐TC	0.58	+0.05	0.70	0.70	0.58	0.62	38,000	23,400	8	0.57	0.58	5,000,000	0.58	1.55	0.01
722009	P8元大	---	---	---	---	---	0.13	0	0	0	0.01	0.02	5,000,000	0.02	0.69	0.01
722010	Q6元大	0.23	+0.01	0.23	0.23	0.23	0.23	99,000	22,770	1	0.23	0.24	5,000,000	0.23	0.69	0.01
722011	PB凱基	---	---	---	---	---	0.10	0	0	0	0.05	0.06	5,000,000	0.06	0.68	0.01
722012	兆豐TD	---	---	---	---	---	0.31	0	0	0	0.26	0.35	5,000,000	0.35	0.96	0.01
722013	永豐S7	---	---	---	---	---	0.02	0	0	0	0.00	0.01	5,095,000	0.01	0.47	0.01
722014	永豐S8	---	---	---	---	---	1.42	0	0	0	0.92	1.02	12,000,000	1.02	1.81	0.23
722015	永豐S9	---	---	---	---	---	0.07	0	0	0	0.00	0.03	5,000,000	0.03	0.63	0.01
722016	中信YJ	---	---	---	---	---	0.04	0	0	0	0.01	0.02	5,000,000	0.02	0.71	0.01
722017	SF群益	---	---	---	---	---	0.09	0	0	0	0.04	0.10	5,000,000	0.09	1.43	0.01
722018	SG群益	---	---	---	---	---	0.12	0	0	0	0.01	0.10	5,000,000	0.10	0.92	0.01
722019	SH群益	---	---	---	---	---	0.39	0	0	0	0.03	0.10	10,000,000	0.10	1.06	0.01
722020	SJ群益	---	---	---	---	---	0.14	0	0	0	0.00	0.10	5,260,000	0.10	0.57	0.01
722021	Q7元大	1.35	-0.21	1.61	1.61	1.34	1.38	372,000	512,280	11	1.33	1.37	5,000,000	1.35	2.40	0.30
722022	Q9元大	---	---	---	---	---	0.03	0	0	0	0.00	0.02	5,000,000	0.02	0.57	0.01
722023	WX日盛	0.01	-0.01	0.01	0.01	0.01	0.01	13,000	130	2	0.01	0.02	5,000,000	0.01	0.71	0.01
722024	WY日盛	---	---	---	---	---	0.01	0	0	0	0.01	0.02	5,000,000	0.01	0.70	0.01
722025	WZ日盛	---	---	---	---	---	2.64	0	0	0	1.49	1.55	5,000,000	1.49	2.45	0.53
722026	統一ZL	---	---	---	---	---	0.17	0	0	0	0.11	0.12	5,000,000	0.12	0.41	0.01
722027	統一ZM	1.11	-0.11	1.05	1.11	1.05	1.08	10,000	10,800	2	1.13	1.16	5,000,000	1.11	1.71	0.51
722028	統一ZN	0.50	-0.03	0.50	0.50	0.50	0.50	10,000	5,000	1	0.47	0.50	5,000,000	0.50	0.88	0.12
722029	統一ZP	---	---	---	---	---	1.66	0	0	0	1.50	1.59	15,000,000	1.59	2.34	0.84
722030	兆豐TF	---	---	---	---	---	0.04	0	0	0	0.02	0.03	5,000,000	0.03	0.60	0.01
722031	統一ZR	0.37	-0.03	0.39	0.39	0.36	0.37	677,000	250,130	9	0.36	0.37	15,000,000	0.37	0.91	0.01
722032	永昌ZB	---	---	---	---	---	0.01	0	0	0	0.01	0.10	10,000,000	0.01	0.87	0.01
722033	富邦RW	---	---	---	---	---	5.75	0	0	0	8.05	0.00	5,000,000	9.15	10.50	7.75
722034	康和RZ	---	---	---	---	---	0.01	0	0	0	0.00	0.01	20,000,000	0.01	0.48	0.01
722035	康和SA	---	---	---	---	---	0.10	0	0	0	0.05	0.10	5,000,000	0.10	0.62	0.01
722036	永豐T2	---	---	---	---	---	1.28	0	0	0	1.62	1.72	5,000,000	1.62	2.39	0.85
722037	永豐T3	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.48	0.01
722038	永豐T4	0.18	-0.02	0.20	0.20	0.18	0.19	100,000	19,000	2	0.19	0.20	5,033,000	0.18	0.48	0.01
722039	永豐T5	---	---	---	---	---	1.13	0	0	0	0.79	0.86	5,080,000	0.86	1.61	0.11
722040	RD國泰	---	---	---	---	---	5.25	0	0	0	2.69	0.00	5,000,000	3.31	4.36	2.26
722041	SK群益	0.64	+0.09	0.68	0.70	0.64	0.70	356,000	247,560	7	0.61	0.63	8,000,000	0.64	1.48	0.01
722042	SL群益	---	---	---	---	---	0.01	0	0	0	0.00	0.01	8,000,000	0.01	0.33	0.01
722043	SM群益	---	---	---	---	---	1.73	0	0	0	0.72	0.75	10,000,000	0.75	1.84	0.01
722044	SZ元富	---	---	---	---	---	0.17	0	0	0	0.06	0.07	6,000,000	0.07	1.03	0.01
722045	TA元富	---	---	---	---	---	0.34	0	0	0	0.00	0.00	5,000,000	0.04	0.36	0.01
722046	P1日盛	---	---	---	---	---	1.82	0	0	0	1.80	1.89	5,000,000	1.89	2.52	1.26
722047	永豐T6	---	---	---	---	---	0.03	0	0	0	0.00	0.01	9,500,000	0.01	0.47	0.01
722048	永豐T7	---	---	---	---	---	0.33	0	0	0	0.38	0.45	5,000,000	0.45	1.13	0.01
722049	富邦RX	1.67	+0.17	1.80	1.80	1.66	1.74	221,000	385,070	22	1.64	1.66	5,000,000	1.67	2.64	0.70
722050	富邦RY	1.16	-0.22	1.16	1.16	1.16	1.16	5,000	5,800	1	1.13	1.22	5,000,000	1.16	2.00	0.32
722051	XJ第一	---	---	---	---	---	0.48	0	0	0	0.01	0.10	5,000,000	0.10	0.56	0.01
722052	兆豐TG	---	---	---	---	---	0.04	0	0	0	0.02	0.03	5,000,000	0.03	0.72	0.01
722053	S2元大	---	---	---	---	---	0.22	0	0	0	0.23	0.24	5,000,000	0.24	0.64	0.01
722054	S3元大	---	---	---	---	---	0.64	0	0	0	0.40	0.50	5,000,000	0.50	1.30	0.01
722055	SQ群益	---	---	---	---	---	1.33	0	0	0	1.43	1.50	5,000,000	1.50	2.13	0.87
722056	SR群益	0.63	+0.18	0.43	0.63	0.42	0.54	606,000	330,170	11	0.61	0.63	5,000,000	0.63	1.01	0.25
722057	P2日盛	0.96	-0.15	0.96	0.96	0.96	0.96	68,000	65,280	1	0.97	1.06	5,000,000	0.96	1.65	0.27
722058	P3日盛	---	---	---	---	---	0.22	0	0	0	0.01	0.02	5,000,000	0.02	0.50	0.01
722059	兆豐TH	---	---	---	---	---	0.11	0	0	0	0.00	0.02	5,000,000	0.02	0.42	0.01
722060	兆豐TJ	---	---	---	---	---	0.13	0	0	0	0.00	0.01	5,000,000	0.01	0.47	0.01
722061	PC凱基	---	---	---	---	---	0.04	0	0	0	0.00	0.02	5,000,000	0.02	0.82	0.01
722062	PD凱基	3.14	-0.33	3.14	3.14	3.14	3.14	10,000	31,400	1	3.13	3.23	5,000,000	3.14	4.19	2.09
722063	富邦RZ	0.25	-0.01	0.25	0.25	0.25	0.25	1,000	250	1	0.24	0.25	5,000,000	0.25	0.68	0.01
722064	S4元大	---	---	---	---	---	0.46	0	0	0	0.38	0.39	5,000,000	0.38	1.05	0.01
722065	S6元大	---	---	---	---	---	5.50	0	0	0	10.10	0.00	5,000,000	11.60	13.30	9.90
722066	永豐T8	---	---	---	---	---	0.14	0	0	0	0.01	0.04	5,000,000	0.04	0.90	0.01
722067	永豐T9	---	---	---	---	---	0.10	0	0	0	0.09	0.10	12,000,000	0.10	0.66	0.01
722068	永豐U1	---	---	---	---	---	0.09	0	0	0	0.00	0.02	5,000,000	0.02	0.43	0.01
722069	TB元富	0.07	-0.10	0.07	0.07	0.07	0.07	30,000	2,100	1	0.08	0.09	5,000,000	0.07	0.89	0.01
722070	TC元富	0.26	0.00	0.27	0.27	0.26	0.26	155,000	40,350	2	0.20	0.21	5,000,000	0.26	0.87	0.01
722071	兆豐TK	---	---	---	---	---	0.12	0	0	0	0.11	0.12	5,000,000	0.12	0.58	0.01
722072	PG凱基	---	---	---	---	---	0.02	0	0	0	0.00	0.01	5,000,000	0.01	0.48	0.01
722073	康和SB	---	---	---	---	---	1.40	0	0	0	0.66	0.71	10,000,000	0.71	1.40	0.02
722074	永豐U2	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.51	0.01
722075	統一ZS	0.66	0.00	0.64	0.66	0.60	0.62	56,000	34,760	6	0.63	0.65	15,000,000	0.66	1.09	0.23
722076	統一ZT	---	---	---	---	---	0.27	0	0	0	0.21	0.22	5,000,000	0.22	0.62	0.01
722077	RE國泰	---	---	---	---	---	0.23	0	0	0	0.21	0.22	5,000,000	0.21	0.77	0.01
722078	SS群益	---	---	---	---	---	0.12	0	0	0	0.00	0.00	5,000,000	0.10	1.22	0.01
722079	ST群益	---	---	---	---	---	0.03	0	0	0	0.00	0.00	5,000,000	0.03	0.76	0.01
722080	富邦SA	---	---	---	---	---	1.37	0	0	0	2.23	0.00	5,000,000	2.27	2.96	1.58
722081	富邦SB	1.28	0.00	1.28	1.28	1.28	1.28	10,000	12,800	1	1.24	1.28	5,000,000	1.28	2.09	0.47
722082	統一ZW	---	---	---	---	---	0.15	0	0	0	0.04	0.05	5,000,000	0.05	0.24	0.01
722083	統一ZX	0.66	+0.05	0.72	0.74	0.66	0.69	117,000	80,790	8	0.64	0.67	15,000,000	0.66	1.28	0.04
722084	中信YK	1.32	+0.02	1.50	1.50	1.32	1.38	30,000	41,400	3	1.28	1.36	5,000,000	1.32	3.21	0.01
722085	SV群益	0.55	-0.01	0.55	0.55	0.55	0.55	500,000	275,000	6	0.53	0.54	5,000,000	0.55	1.90	0.01
722086	P4日盛	---	---	---	---	---	0.63	0	0	0	0.70	0.73	5,000,000	0.70	1.25	0.15
722087	P5日盛	---	---	---	---	---	1.37	0	0	0	0.97	1.03	5,000,000	1.03	1.80	0.26
722088	永豐U3	---	---	---	---	---	0.14	0	0	0	0.05	0.06	12,000,000	0.06	0.59	0.01
722089	永豐U4	---	---	---	---	---	1.16	0	0	0	1.01	1.05	12,000,000	1.05	1.81	0.29
72208P	WE第一	0.23	+0.01	0.22	0.23	0.22	0.22	439,000	97,370	9	0.23	0.24	5,000,000	0.23	1.70	0.01
722090	永豐U5	---	---	---	---	---	0.40	0	0	0	0.01	0.03	5,000,000	0.03	0.48	0.01
722091	S8元大	0.06	-0.02	0.07	0.07	0.05	0.06	25,000	1,550	3	0.05	0.06	5,000,000	0.06	0.40	0.01