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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
716654	國票PJ	---	---	---	---	---	0.29	0	0	0	0.14	0.15	5,000,000	0.15	0.88	0.01
716655	TF元大	0.83	+0.08	0.37	0.83	0.33	0.57	108,000	61,580	11	0.11	0.88	10,000,000	0.83	2.41	0.01
716656	UB元大	---	---	---	---	---	0.46	0	0	0	0.45	0.48	10,000,000	0.46	1.38	0.01
716657	元大SS	---	---	---	---	---	0.07	0	0	0	0.00	0.01	15,000,000	0.01	0.59	0.01
716658	元大VE	---	---	---	---	---	0.14	0	0	0	0.11	0.12	10,000,000	0.12	0.59	0.01
716659	RP永豐	---	---	---	---	---	0.33	0	0	0	0.13	0.14	12,000,000	0.14	1.06	0.01
716660	RQ永豐	---	---	---	---	---	0.12	0	0	0	0.02	0.03	5,000,000	0.03	0.50	0.01
716661	RR永豐	---	---	---	---	---	0.18	0	0	0	0.00	0.01	5,000,000	0.01	0.47	0.01
716662	RA凱基	0.12	-0.04	0.12	0.12	0.12	0.12	105,000	12,600	2	0.12	0.14	5,000,000	0.12	0.88	0.01
716663	統一ZX	1.64	-0.28	1.64	1.64	1.64	1.64	10,000	16,400	1	1.64	1.70	15,000,000	1.64	2.68	0.60
716664	日盛TZ	---	---	---	---	---	0.06	0	0	0	0.02	0.03	5,800,000	0.03	0.57	0.01
716665	日盛UA	---	---	---	---	---	3.55	0	0	0	2.93	3.02	5,000,000	2.93	5.00	0.83
716666	元富Y6	---	---	---	---	---	0.03	0	0	0	0.00	0.00	5,000,000	0.03	0.51	0.01
716667	統一ZY	0.13	-0.05	0.13	0.13	0.13	0.13	10,000	1,300	1	0.14	0.15	15,000,000	0.13	0.68	0.01
716668	元大TF	---	---	---	---	---	0.07	0	0	0	0.04	0.05	5,000,000	0.05	0.41	0.01
716669	元大TG	---	---	---	---	---	0.18	0	0	0	0.03	0.06	10,000,000	0.06	1.18	0.01
71666P	UC元大	---	---	---	---	---	0.27	0	0	0	0.47	0.49	5,000,000	0.47	0.80	0.14
716670	元大VG	---	---	---	---	---	0.19	0	0	0	0.15	0.16	5,000,000	0.16	1.01	0.01
716671	RB凱基	---	---	---	---	---	0.16	0	0	0	0.13	0.14	5,000,000	0.14	1.01	0.01
716672	RC凱基	---	---	---	---	---	0.07	0	0	0	0.02	0.03	5,000,000	0.03	0.76	0.01
716673	RD凱基	---	---	---	---	---	0.58	0	0	0	0.03	0.05	5,000,000	0.04	1.09	0.01
716674	RE凱基	0.21	-0.23	0.21	0.21	0.21	0.21	60,000	12,600	1	0.30	0.35	5,000,000	0.21	1.20	0.01
716675	日盛UB	---	---	---	---	---	0.42	0	0	0	0.01	0.02	5,500,000	0.02	0.38	0.01
716676	日盛UC	0.08	-0.03	0.08	0.08	0.08	0.08	40,000	3,200	1	0.08	0.10	5,000,000	0.08	0.49	0.01
716677	日盛UD	---	---	---	---	---	0.01	0	0	0	0.01	0.00	5,000,000	0.01	0.13	0.01
716678	日盛UE	---	---	---	---	---	0.08	0	0	0	0.02	0.03	5,000,000	0.03	0.76	0.01
716679	SZ兆豐	---	---	---	---	---	0.17	0	0	0	0.02	0.03	5,000,000	0.03	0.87	0.01
716680	TA兆豐	---	---	---	---	---	0.14	0	0	0	0.00	0.02	5,000,000	0.02	0.60	0.01
716681	TB兆豐	0.37	-0.11	0.30	0.37	0.30	0.31	150,000	46,900	6	0.34	0.35	5,000,000	0.37	1.57	0.01
716682	TE第一	---	---	---	---	---	0.35	0	0	0	0.01	0.10	5,000,000	0.10	0.73	0.01
716683	統一ZZ	---	---	---	---	---	0.07	0	0	0	0.01	0.05	5,000,000	0.05	0.51	0.01
716684	日盛UG	---	---	---	---	---	0.04	0	0	0	0.02	0.05	5,000,000	0.03	0.20	0.01
716685	日盛UH	---	---	---	---	---	0.36	0	0	0	0.01	0.06	5,000,000	0.06	0.49	0.01
716686	日盛UJ	---	---	---	---	---	0.03	0	0	0	0.01	0.02	5,000,000	0.02	0.42	0.01
716687	RG凱基	1.35	+0.09	1.35	1.35	1.35	1.35	22,000	29,700	1	1.23	1.29	5,000,000	1.35	2.51	0.19
716688	RH凱基	---	---	---	---	---	0.54	0	0	0	0.48	0.53	10,000,000	0.53	1.29	0.01
716689	RJ凱基	---	---	---	---	---	2.70	0	0	0	2.05	2.15	5,000,000	2.06	2.98	1.14
716690	RK凱基	---	---	---	---	---	0.08	0	0	0	0.00	0.02	5,000,000	0.02	0.65	0.01
716691	RL凱基	2.15	+0.04	2.12	2.15	2.12	2.14	2,000	4,270	2	2.08	2.14	5,000,000	2.15	3.20	1.10
716692	TF第一	---	---	---	---	---	0.33	0	0	0	0.12	0.15	5,000,000	0.12	1.04	0.01
716693	TG第一	---	---	---	---	---	2.51	0	0	0	4.27	0.00	10,000,000	4.90	6.40	3.40
716694	群益VV	---	---	---	---	---	0.01	0	0	0	0.00	0.00	5,000,000	0.01	0.94	0.01
716695	群益VW	---	---	---	---	---	0.11	0	0	0	0.05	0.06	5,000,000	0.06	1.42	0.01
716696	群益VX	---	---	---	---	---	3.45	0	0	0	3.16	3.26	10,000,000	3.26	5.10	1.39
716697	群益VY	0.29	-0.02	0.29	0.29	0.29	0.29	10,000	2,900	1	0.29	0.30	5,000,000	0.29	0.86	0.01
716698	群益VZ	---	---	---	---	---	0.05	0	0	0	0.00	0.66	5,000,000	0.02	0.68	0.01
716699	群益WA	0.10	-0.02	0.10	0.10	0.10	0.10	300,000	30,000	2	0.10	0.11	5,000,000	0.10	0.40	0.01
716700	康和XT	---	---	---	---	---	0.22	0	0	0	0.01	0.10	10,000,000	0.10	0.52	0.01
716701	康和XU	0.13	+0.06	0.11	0.13	0.11	0.11	158,000	17,980	2	0.12	0.13	5,000,000	0.13	0.74	0.01
716702	康和XV	---	---	---	---	---	0.30	0	0	0	0.00	0.01	5,000,000	0.01	0.25	0.01
716703	富邦VY	0.60	+0.08	0.40	0.63	0.40	0.57	307,000	174,720	31	0.60	0.61	5,000,000	0.60	2.30	0.01
716704	富邦VZ	---	---	---	---	---	1.14	0	0	0	1.39	1.46	5,000,000	1.39	2.47	0.30
716705	富邦WA	1.02	+0.05	0.91	1.02	0.91	0.96	26,000	24,990	3	0.96	0.97	5,000,000	1.02	1.78	0.26
716706	RM凱基	---	---	---	---	---	0.15	0	0	0	0.04	0.05	5,000,000	0.05	0.98	0.01
716707	RN凱基	0.77	+0.15	0.95	0.95	0.76	0.78	290,000	225,900	5	0.73	0.83	5,000,000	0.77	2.33	0.01
716708	RP凱基	---	---	---	---	---	0.47	0	0	0	0.35	0.36	5,000,000	0.36	1.44	0.01
716709	RR凱基	---	---	---	---	---	0.50	0	0	0	0.33	0.43	5,000,000	0.38	1.42	0.01
716710	RU凱基	0.33	+0.02	0.20	0.36	0.18	0.28	857,000	241,760	56	0.32	0.33	5,000,000	0.33	2.03	0.01
716711	RV凱基	---	---	---	---	---	0.05	0	0	0	0.03	0.13	5,000,000	0.13	0.80	0.01
716712	RQ凱基	---	---	---	---	---	4.74	0	0	0	10.90	0.00	5,000,000	10.90	12.90	8.85
716713	統一P1	0.07	-0.08	0.08	0.08	0.07	0.07	147,000	10,780	4	0.07	0.08	15,000,000	0.07	0.34	0.01
716714	統一P2	---	---	---	---	---	1.86	0	0	0	1.47	1.53	5,000,000	1.48	2.15	0.81
716715	統一P3	0.08	0.00	0.05	0.09	0.05	0.06	133,000	7,900	4	0.07	0.08	5,000,000	0.08	0.34	0.01
716716	統一P4	0.78	+0.01	0.60	0.79	0.56	0.67	344,000	230,980	25	0.74	0.76	5,000,000	0.78	1.37	0.19
716717	統一P5	1.87	+0.06	1.34	1.87	1.34	1.39	11,000	15,270	2	1.77	1.87	15,000,000	1.87	2.67	1.07
716718	統一P6	---	---	---	---	---	0.06	0	0	0	0.01	0.05	18,500,000	0.05	0.61	0.01
716719	統一P7	---	---	---	---	---	0.03	0	0	0	0.01	0.02	5,000,000	0.02	0.38	0.01
716720	元大TQ	0.15	+0.03	0.07	0.15	0.07	0.07	41,000	2,950	2	0.07	0.10	5,000,000	0.15	1.37	0.01
716721	元大VL	---	---	---	---	---	0.29	0	0	0	0.04	0.05	5,000,000	0.04	0.52	0.01
716722	元大VP	---	---	---	---	---	0.08	0	0	0	0.02	0.03	5,000,000	0.03	0.65	0.01
716723	元大VR	---	---	---	---	---	0.03	0	0	0	0.00	0.02	20,000,000	0.01	1.61	0.01
716724	元大VS	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.34	0.01
716725	元證QA	---	---	---	---	---	0.80	0	0	0	0.00	0.10	20,000,000	0.10	1.09	0.01
716726	元證QB	---	---	---	---	---	0.18	0	0	0	0.02	0.12	20,000,000	0.12	0.66	0.01
716727	元證QC	---	---	---	---	---	0.09	0	0	0	0.00	0.10	5,000,000	0.02	1.19	0.01
716728	元證QD	---	---	---	---	---	4.30	0	0	0	4.60	0.00	20,000,000	5.20	6.70	3.70
716729	元證QE	---	---	---	---	---	0.32	0	0	0	0.19	0.20	5,000,000	0.20	0.85	0.01
716730	元證QF	---	---	---	---	---	0.08	0	0	0	0.02	0.03	5,000,000	0.03	0.87	0.01
716731	元證QG	---	---	---	---	---	11.60	0	0	0	10.40	0.00	5,000,000	10.40	12.40	8.35
716732	元證QH	---	---	---	---	---	0.30	0	0	0	0.24	0.30	5,000,000	0.25	0.93	0.01
716733	元證QJ	---	---	---	---	---	0.08	0	0	0	0.00	0.00	5,000,000	0.02	0.81	0.01
716734	元證QK	0.10	+0.08	0.02	0.10	0.02	0.02	21,000	500	2	0.00	0.10	5,000,000	0.10	0.62	0.01
716735	元證QL	---	---	---	---	---	4.46	0	0	0	4.36	0.00	5,000,000	4.51	5.95	3.06
716736	元證QM	---	---	---	---	---	0.01	0	0	0	0.01	0.06	5,000,000	0.01	0.68	0.01
716737	RS永豐	---	---	---	---	---	0.03	0	0	0	0.02	0.03	5,000,000	0.03	0.61	0.01
716738	RT永豐	---	---	---	---	---	8.70	0	0	0	8.10	8.35	5,000,000	8.10	9.65	6.55
716739	RU永豐	---	---	---	---	---	0.08	0	0	0	0.12	0.13	5,000,000	0.12	0.71	0.01
716740	RV永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.39	0.01
716741	RW永豐	---	---	---	---	---	0.03	0	0	0	0.00	0.01	12,000,000	0.01	1.05	0.01
716742	RX永豐	---	---	---	---	---	0.19	0	0	0	0.00	0.01	5,000,000	0.01	0.75	0.01
716743	RY永豐	---	---	---	---	---	0.27	0	0	0	0.16	0.17	5,000,000	0.17	0.90	0.01
716744	RZ永豐	---	---	---	---	---	9.65	0	0	0	11.30	0.00	5,000,000	11.30	13.20	9.30
716745	SA永豐	0.18	+0.08	0.16	0.18	0.16	0.17	300,000	49,600	4	0.17	0.18	5,000,000	0.18	0.70	0.01
716746	SB永豐	---	---	---	---	---	2.52	0	0	0	2.54	2.59	5,000,000	2.54	3.29	1.79
716747	SC永豐	---	---	---	---	---	0.57	0	0	0	0.21	0.22	12,000,000	0.22	1.15	0.01
716748	SD永豐	---	---	---	---	---	0.13	0	0	0	0.05	0.06	5,000,000	0.06	0.76	0.01
716749	SF永豐	---	---	---	---	---	0.11	0	0	0	0.00	0.01	12,000,000	0.01	0.49	0.01
716750	SG永豐	---	---	---	---	---	0.02	0	0	0	0.00	0.02	5,000,000	0.02	0.65	0.01
716751	SH永豐	---	---	---	---	---	0.12	0	0	0	0.07	0.10	5,000,000	0.10	0.92	0.01
716752	SI永豐	---	---	---	---	---	0.08	0	0	0	0.03	0.05	5,000,000	0.04	0.52	0.01