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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
715693	PQ兆豐	---	---	---	---	---	0.28	0	0	0	0.13	0.14	5,000,000	0.14	0.35	0.01
715694	國票YV	---	---	---	---	---	0.71	0	0	0	0.42	0.43	5,000,000	0.43	1.11	0.01
715696	凱基WW	---	---	---	---	---	0.02	0	0	0	0.00	0.02	5,000,000	0.01	0.19	0.01
715698	富邦TF	---	---	---	---	---	0.49	0	0	0	0.31	0.38	5,000,000	0.38	0.94	0.01
715708	Q8元大	---	---	---	---	---	0.01	0	0	0	0.00	0.01	15,000,000	0.01	1.96	0.01
715727	統一XR	0.01	-0.04	0.01	0.01	0.01	0.01	160,000	1,600	2	0.01	0.05	5,000,000	0.01	0.37	0.01
715732	凱基XB	---	---	---	---	---	0.01	0	0	0	0.00	0.03	5,000,000	0.01	1.00	0.01
715747	日盛QX	0.86	-0.04	0.86	0.86	0.86	0.86	150,000	129,000	2	0.86	0.88	5,000,000	0.86	1.43	0.29
715757	國票YW	---	---	---	---	---	0.86	0	0	0	0.76	0.77	5,000,000	0.77	1.23	0.31
715760	統一XS	---	---	---	---	---	0.82	0	0	0	0.66	0.70	5,000,000	0.69	1.25	0.13
715763	富邦TJ	0.22	+0.01	0.19	0.22	0.19	0.22	380,000	82,900	4	0.22	0.26	10,000,000	0.22	0.74	0.01
715764	富邦TK	---	---	---	---	---	0.14	0	0	0	0.04	0.10	5,000,000	0.10	0.61	0.01
715768	富邦TP	---	---	---	---	---	0.47	0	0	0	0.18	0.21	10,000,000	0.21	1.12	0.01
715776	V6元大	3.51	-0.07	3.51	3.51	3.51	3.51	10,000	35,100	1	3.46	3.56	5,000,000	3.51	5.10	1.91
715790	凱基XE	---	---	---	---	---	4.90	0	0	0	5.15	5.45	5,000,000	5.15	6.50	3.74
715802	TP元大	---	---	---	---	---	0.02	0	0	0	0.00	0.02	5,000,000	0.02	0.73	0.01
715804	W9元大	0.51	0.00	0.45	0.52	0.43	0.50	795,000	393,780	17	0.47	0.48	5,000,000	0.51	0.76	0.26
715811	QA兆豐	---	---	---	---	---	2.07	0	0	0	2.94	0.00	5,000,000	2.94	3.59	2.29
715812	QB兆豐	---	---	---	---	---	0.18	0	0	0	0.00	0.00	5,000,000	0.01	0.65	0.01
715813	國泰X3	---	---	---	---	---	0.34	0	0	0	0.00	0.00	5,000,000	0.31	0.59	0.02
715814	國泰X4	1.53	+0.16	1.56	1.56	1.46	1.47	19,000	27,910	3	1.41	1.48	5,000,000	1.53	2.56	0.50
715815	統一XU	---	---	---	---	---	3.72	0	0	0	3.15	3.25	15,000,000	3.15	4.07	2.23
715816	統一XV	0.67	+0.09	0.50	0.67	0.50	0.65	1,855,000	1,198,350	23	0.64	0.67	5,000,000	0.67	1.22	0.12
71581P	凱基VJ	---	---	---	---	---	0.09	0	0	0	0.00	0.02	5,000,000	0.02	0.51	0.01
715830	凱基XK	0.02	0.00	0.01	0.02	0.01	0.01	110,000	1,200	11	0.01	0.02	5,000,000	0.02	0.87	0.01
715833	國泰X5	---	---	---	---	---	0.01	0	0	0	0.00	0.10	5,100,000	0.01	0.32	0.01
715834	中信UD	---	---	---	---	---	0.16	0	0	0	0.00	0.02	10,000,000	0.02	0.60	0.01
715835	TT元大	0.34	+0.01	0.30	0.34	0.27	0.31	552,000	171,600	6	0.29	0.30	5,000,000	0.34	0.68	0.01
715836	TU元大	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.62	0.01
715841	QD兆豐	---	---	---	---	---	0.94	0	0	0	0.78	0.80	5,000,000	0.80	1.26	0.34
715843	凱基XN	---	---	---	---	---	0.31	0	0	0	0.04	0.05	5,450,000	0.05	0.33	0.01
715844	凱基XP	---	---	---	---	---	0.33	0	0	0	0.00	0.02	5,000,000	0.02	0.42	0.01
715845	凱基XQ	---	---	---	---	---	2.10	0	0	0	0.13	0.20	5,800,000	0.13	0.61	0.01
715846	凱基XR	---	---	---	---	---	0.59	0	0	0	0.67	0.71	5,000,000	0.67	1.28	0.06
715849	凱基XU	---	---	---	---	---	0.05	0	0	0	0.00	0.03	5,000,000	0.03	0.36	0.01
715850	凱基XW	2.00	-0.03	1.98	2.00	1.98	1.99	50,000	99,280	3	1.98	2.01	5,000,000	2.00	2.73	1.27
715851	群益RV	---	---	---	---	---	0.21	0	0	0	0.00	0.00	5,037,000	0.02	0.42	0.01
715856	日盛RD	---	---	---	---	---	0.06	0	0	0	0.01	0.05	5,000,000	0.05	0.35	0.01
715859	W5永豐	---	---	---	---	---	0.33	0	0	0	0.00	0.01	5,000,000	0.01	0.57	0.01
715868	UA元大	0.07	-0.02	0.07	0.07	0.07	0.07	36,000	2,520	1	0.08	0.09	5,000,000	0.07	0.33	0.01
715872	國泰Y3	---	---	---	---	---	0.02	0	0	0	0.00	0.02	5,000,000	0.01	0.22	0.01
715877	統一XX	---	---	---	---	---	0.15	0	0	0	0.13	0.14	5,000,000	0.14	0.50	0.01
715881	群益SA	---	---	---	---	---	0.04	0	0	0	0.01	0.02	5,000,000	0.02	0.50	0.01
715886	元富Q8	---	---	---	---	---	0.10	0	0	0	0.00	0.00	5,000,000	0.04	0.41	0.01
715888	凱基XZ	---	---	---	---	---	1.93	0	0	0	2.16	2.26	5,000,000	2.20	2.63	1.77
715889	凱基YA	---	---	---	---	---	0.22	0	0	0	0.24	0.28	5,000,000	0.28	1.30	0.01
715895	凱基YG	---	---	---	---	---	0.05	0	0	0	0.00	0.02	5,000,000	0.01	1.16	0.01
715899	中信UE	---	---	---	---	---	0.04	0	0	0	0.00	0.02	5,000,000	0.02	1.12	0.01
715904	UM元大	---	---	---	---	---	0.95	0	0	0	0.62	0.72	5,000,000	0.72	2.04	0.01
715909	QJ兆豐	0.42	+0.04	0.39	0.43	0.39	0.41	151,000	62,030	9	0.41	0.42	5,000,000	0.42	0.97	0.01
715920	日盛RG	0.41	+0.04	0.39	0.41	0.39	0.39	31,000	12,110	4	0.40	0.41	5,000,000	0.41	0.98	0.01
715927	統一XZ	---	---	---	---	---	0.22	0	0	0	0.12	0.16	5,000,000	0.16	0.59	0.01
715928	凱基YK	---	---	---	---	---	0.10	0	0	0	0.01	0.03	5,000,000	0.03	1.13	0.01
715929	凱基YL	0.22	-0.14	0.22	0.22	0.22	0.22	20,000	4,400	1	0.17	0.19	5,000,000	0.22	1.37	0.01
715930	凱基YM	---	---	---	---	---	2.66	0	0	0	3.60	3.70	5,000,000	3.70	5.15	2.25
715931	凱基YN	---	---	---	---	---	3.98	0	0	0	2.53	2.58	5,000,000	2.58	4.02	1.14
715932	凱基YP	---	---	---	---	---	0.30	0	0	0	0.00	0.02	5,000,000	0.02	0.64	0.01
715933	凱基YQ	---	---	---	---	---	1.26	0	0	0	0.87	0.97	5,000,000	0.97	2.09	0.01
715943	國票ZF	---	---	---	---	---	2.87	0	0	0	2.89	2.90	10,000,000	2.89	3.82	1.95
715955	日盛RJ	0.43	0.00	0.41	0.43	0.41	0.41	53,000	21,790	3	0.47	0.49	5,800,000	0.43	0.74	0.12
715956	日盛RK	---	---	---	---	---	10.10	0	0	0	0.00	0.00	5,250,000	11.20	12.40	10.00
715981	凱基YV	---	---	---	---	---	1.52	0	0	0	1.47	1.57	5,000,000	1.57	2.34	0.80
715984	群益TA	---	---	---	---	---	3.07	0	0	0	3.55	3.65	10,000,000	3.55	5.45	1.65
715987	日盛RT	0.25	-0.03	0.25	0.25	0.25	0.25	5,000	1,250	1	0.25	0.26	5,000,000	0.25	0.59	0.01
715997	統一YA	---	---	---	---	---	0.04	0	0	0	0.03	0.05	5,000,000	0.05	0.43	0.01
715998	統一YB	4.32	+0.91	3.94	4.32	3.94	4.18	8,000	33,420	2	4.32	4.37	5,000,000	4.32	5.35	3.27
716001	富邦TY	---	---	---	---	---	5.46	0	0	0	2.52	2.62	5,000,000	2.62	5.25	0.01
716004	群益TC	---	---	---	---	---	0.08	0	0	0	0.00	0.00	5,000,000	0.02	1.27	0.01
716006	群益TE	---	---	---	---	---	0.01	0	0	0	0.00	0.00	5,000,000	0.01	0.44	0.01
716007	VR元大	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.61	0.01
716016	群益TG	3.17	+0.40	3.17	3.17	3.17	3.17	10,000	31,700	1	3.09	3.10	7,000,000	3.17	4.35	1.99
716017	群益TH	---	---	---	---	---	0.03	0	0	0	0.00	0.00	7,000,000	0.02	0.57	0.01
716030	中信UG	0.96	+0.52	0.11	0.98	0.11	0.41	14,000	5,690	5	0.72	0.82	6,000,000	0.96	4.82	0.01
716031	VS元大	---	---	---	---	---	0.79	0	0	0	0.67	0.72	7,000,000	0.67	1.24	0.10
716033	VU元大	---	---	---	---	---	0.03	0	0	0	0.00	0.02	10,000,000	0.02	0.47	0.01
716034	VV元大	---	---	---	---	---	0.42	0	0	0	0.04	0.05	5,000,000	0.05	0.68	0.01
716035	元富R6	---	---	---	---	---	0.13	0	0	0	0.00	0.00	5,000,000	0.04	0.69	0.01
716038	RA兆豐	1.08	-0.01	1.17	1.22	1.08	1.15	42,000	48,420	14	1.06	1.07	5,000,000	1.08	2.11	0.05
716044	凱基ZB	4.38	+0.01	4.42	4.42	4.38	4.42	10,000	44,160	2	4.82	4.92	5,000,000	4.38	6.75	1.98
716047	VW元大	---	---	---	---	---	0.06	0	0	0	0.00	0.02	15,000,000	0.02	0.70	0.01
716052	WB元大	---	---	---	---	---	4.13	0	0	0	0.00	0.00	5,000,000	3.60	5.30	1.90
716056	元富R9	5.60	+0.20	5.10	5.60	5.10	5.43	21,000	114,100	3	5.35	5.40	5,000,000	5.60	7.50	3.68
716065	凱基ZC	4.64	+0.14	4.64	4.64	4.64	4.64	10,000	46,400	1	4.83	4.87	5,000,000	4.64	6.40	2.88
716067	富邦UJ	0.66	-0.04	0.62	0.66	0.62	0.63	26,000	16,360	4	0.66	0.70	5,000,000	0.66	1.21	0.11
716076	日盛RY	---	---	---	---	---	0.27	0	0	0	0.18	0.21	5,000,000	0.21	0.57	0.01
716084	群益TR	---	---	---	---	---	0.03	0	0	0	0.00	0.00	5,000,000	0.02	0.45	0.01
716085	中信UM	---	---	---	---	---	3.30	0	0	0	2.50	2.60	5,000,000	2.60	5.90	0.01
716086	中信UN	4.58	+0.56	3.28	4.58	2.89	4.03	95,000	382,680	12	4.30	4.34	5,000,000	4.58	9.15	0.01
716094	Y9永豐	---	---	---	---	---	0.18	0	0	0	0.00	0.02	5,000,000	0.01	0.37	0.01
716103	元大P5	---	---	---	---	---	0.02	0	0	0	0.00	0.02	5,000,000	0.02	0.89	0.01
716104	元大P6	---	---	---	---	---	0.05	0	0	0	0.03	0.04	5,000,000	0.04	0.54	0.01
716108	富邦UQ	---	---	---	---	---	0.03	0	0	0	0.01	0.03	5,000,000	0.03	1.00	0.01
716118	RC兆豐	---	---	---	---	---	2.46	0	0	0	0.00	0.00	5,000,000	5.20	6.20	4.18
716119	國泰R3	---	---	---	---	---	2.57	0	0	0	2.74	2.81	5,000,000	2.74	4.13	1.33
716126	凱基ZD	---	---	---	---	---	0.35	0	0	0	0.08	0.11	5,000,000	0.11	0.52	0.01
716130	RD兆豐	0.25	+0.03	0.45	0.45	0.13	0.23	206,000	48,400	11	0.25	0.30	5,000,000	0.25	1.40	0.01
716133	元富T1	---	---	---	---	---	0.38	0	0	0	0.20	0.21	5,000,000	0.21	0.75	0.01
716143	統一YD	---	---	---	---	---	1.32	0	0	0	1.46	1.50	5,000,000	1.46	2.39	0.52
716147	凱基ZG	---	---	---	---	---	1.08	0	0	0	0.00	0.02	5,000,000	0.02	0.58	0.01
716148	中信UP	---	---	---	---	---	0.77	0	0	0	0.39	0.41	5,000,000	0.41	1.61	0.01