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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
716358	統一YS	---	---	---	---	---	0.06	0	0	0	0.01	0.02	5,000,000	0.02	0.56	0.01
716359	統一YT	---	---	---	---	---	0.10	0	0	0	0.01	0.02	5,000,000	0.02	0.33	0.01
716360	統一YU	0.01	0.00	0.01	0.01	0.01	0.01	40,000	400	1	0.01	0.02	16,000,000	0.01	0.68	0.01
716361	PD凱基	---	---	---	---	---	0.03	0	0	0	0.03	0.04	5,000,000	0.03	0.30	0.01
716362	PE凱基	---	---	---	---	---	0.02	0	0	0	0.00	0.01	5,000,000	0.01	0.73	0.01
716363	PF凱基	---	---	---	---	---	5.60	0	0	0	4.52	4.56	5,000,000	4.52	6.70	2.32
716364	PG凱基	0.69	-0.09	0.69	0.69	0.69	0.69	33,000	22,770	3	0.66	0.76	5,000,000	0.69	1.35	0.03
716365	PH凱基	---	---	---	---	---	0.64	0	0	0	0.29	0.39	5,000,000	0.39	1.59	0.01
716366	PJ凱基	---	---	---	---	---	0.02	0	0	0	0.01	0.02	5,000,000	0.02	0.32	0.01
716367	PK凱基	---	---	---	---	---	0.10	0	0	0	0.00	0.02	5,000,000	0.02	0.51	0.01
716368	PL凱基	---	---	---	---	---	4.17	0	0	0	2.72	2.82	5,000,000	2.72	4.00	1.44
716369	SX第一	---	---	---	---	---	1.51	0	0	0	0.00	0.10	5,000,000	0.10	0.86	0.01
716370	SY第一	---	---	---	---	---	0.03	0	0	0	0.01	0.10	5,000,000	0.07	1.22	0.01
716371	國票ZY	---	---	---	---	---	0.27	0	0	0	0.01	0.02	10,000,000	0.02	1.32	0.01
716372	國票ZZ	---	---	---	---	---	0.05	0	0	0	0.00	0.01	5,000,000	0.01	0.58	0.01
716373	中信UT	---	---	---	---	---	1.67	0	0	0	0.13	0.23	10,000,000	0.21	1.06	0.01
716374	群益VK	---	---	---	---	---	0.72	0	0	0	0.00	0.00	5,000,000	0.02	0.62	0.01
716375	群益VL	---	---	---	---	---	0.03	0	0	0	0.01	0.02	5,000,000	0.02	1.17	0.01
716376	富邦VG	---	---	---	---	---	0.01	0	0	0	0.01	0.10	10,000,000	0.01	0.81	0.01
716377	元大PZ	---	---	---	---	---	0.07	0	0	0	0.00	0.02	5,000,000	0.02	1.17	0.01
716378	QI永豐	---	---	---	---	---	0.11	0	0	0	0.00	0.01	5,000,000	0.01	0.58	0.01
716379	QJ永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,000,000	0.01	0.69	0.01
716380	QK永豐	---	---	---	---	---	0.12	0	0	0	0.00	0.01	5,000,000	0.01	0.69	0.01
716381	QL永豐	---	---	---	---	---	0.33	0	0	0	0.06	0.07	5,000,000	0.07	0.91	0.01
716382	QM永豐	---	---	---	---	---	2.46	0	0	0	1.02	1.12	9,900,000	1.12	2.37	0.01
716383	日盛SU	---	---	---	---	---	2.48	0	0	0	1.95	0.00	5,000,000	2.48	3.28	1.68
716384	日盛SV	---	---	---	---	---	0.02	0	0	0	0.01	0.02	5,000,000	0.02	0.59	0.01
716385	日盛SW	---	---	---	---	---	0.01	0	0	0	0.01	0.02	15,000,000	0.01	0.42	0.01
716386	元富U6	---	---	---	---	---	0.24	0	0	0	0.00	0.00	5,000,000	0.05	1.01	0.01
716387	元富U7	1.08	-0.59	1.08	1.08	1.08	1.08	10,000	10,800	1	0.93	0.99	10,000,000	1.08	2.40	0.01
716388	元富U8	---	---	---	---	---	0.04	0	0	0	0.00	0.00	5,000,000	0.04	0.37	0.01
716389	統一YV	---	---	---	---	---	0.17	0	0	0	0.05	0.06	5,000,000	0.06	0.46	0.01
716390	統一YW	---	---	---	---	---	0.01	0	0	0	0.01	0.02	10,000,000	0.01	0.69	0.01
716391	統一YX	---	---	---	---	---	1.68	0	0	0	1.66	1.76	10,000,000	1.71	2.76	0.66
716392	統一YY	---	---	---	---	---	0.01	0	0	0	0.01	0.05	5,000,000	0.01	0.26	0.01
716393	統一YZ	---	---	---	---	---	1.03	0	0	0	0.42	0.51	10,000,000	0.51	1.29	0.01
716394	統一ZA	0.82	+0.20	0.62	0.95	0.62	0.85	122,000	104,090	18	0.82	0.84	6,350,000	0.82	1.65	0.01
716395	SB兆豐	0.04	+0.01	0.04	0.04	0.04	0.04	10,000	400	1	0.03	0.04	5,000,000	0.04	1.01	0.01
716396	SC兆豐	0.02	-0.04	0.02	0.02	0.02	0.02	10,000	200	1	0.02	0.03	5,000,000	0.02	0.59	0.01
716397	SD兆豐	1.75	-0.36	1.78	1.78	1.75	1.77	20,000	35,330	3	1.57	1.60	5,000,000	1.75	2.74	0.76
716398	PM凱基	---	---	---	---	---	0.06	0	0	0	0.03	0.04	5,000,000	0.04	1.19	0.01
716399	PN凱基	---	---	---	---	---	3.32	0	0	0	3.05	3.15	5,000,000	3.15	4.22	2.08
716400	PP凱基	---	---	---	---	---	0.01	0	0	0	0.00	0.02	5,000,000	0.01	0.52	0.01
716401	PQ凱基	---	---	---	---	---	0.01	0	0	0	0.00	0.02	5,000,000	0.01	0.47	0.01
716402	PB國泰	0.08	-0.08	0.08	0.08	0.08	0.08	50,000	4,000	1	0.00	0.00	5,000,000	0.08	0.84	0.01
716403	PC國泰	---	---	---	---	---	3.05	0	0	0	0.00	2.44	5,000,000	2.44	3.29	1.59
716404	QN永豐	---	---	---	---	---	0.13	0	0	0	0.00	0.01	5,000,000	0.01	0.70	0.01
716405	國票PA	---	---	---	---	---	0.11	0	0	0	0.00	0.01	5,000,000	0.01	0.38	0.01
716406	PD國泰	---	---	---	---	---	0.03	0	0	0	0.00	0.10	7,800,000	0.02	0.74	0.01
716407	PE國泰	---	---	---	---	---	0.41	0	0	0	0.00	0.00	5,000,000	0.19	0.76	0.01
716408	群益VM	---	---	---	---	---	0.10	0	0	0	0.02	0.03	5,000,000	0.03	0.72	0.01
716409	元大QE	---	---	---	---	---	2.51	0	0	0	1.72	1.77	10,000,000	1.77	2.76	0.78
716410	元大QK	0.40	+0.11	0.40	0.40	0.40	0.40	10,000	4,000	1	0.39	0.43	5,000,000	0.40	1.02	0.01
716411	元大QS	---	---	---	---	---	0.08	0	0	0	0.00	0.00	10,000,000	0.02	1.32	0.01
716412	日盛SX	0.28	+0.07	0.20	0.28	0.20	0.25	25,000	6,300	3	0.20	0.23	5,000,000	0.28	1.22	0.01
716413	PR凱基	0.06	-0.06	0.06	0.06	0.06	0.06	10,000	600	1	0.07	0.08	5,000,000	0.06	1.02	0.01
716414	PS凱基	---	---	---	---	---	0.23	0	0	0	0.04	0.05	5,000,000	0.05	0.78	0.01
716415	PT凱基	0.91	+0.24	0.49	0.91	0.49	0.63	132,000	83,310	9	1.12	1.17	5,000,000	0.91	1.91	0.01
716416	PU凱基	---	---	---	---	---	0.56	0	0	0	0.15	0.25	5,000,000	0.25	0.92	0.01
716417	PV凱基	---	---	---	---	---	6.40	0	0	0	3.63	3.73	5,000,000	3.63	5.20	2.05
716418	PW凱基	---	---	---	---	---	0.26	0	0	0	0.00	0.02	5,000,000	0.02	0.47	0.01
716419	PX凱基	---	---	---	---	---	2.51	0	0	0	1.03	1.13	5,000,000	1.13	2.46	0.01
716420	PY凱基	---	---	---	---	---	0.04	0	0	0	0.01	0.02	5,000,000	0.02	0.94	0.01
716421	元富V1	---	---	---	---	---	0.03	0	0	0	0.00	0.02	5,000,000	0.01	0.29	0.01
716422	元富V2	---	---	---	---	---	0.23	0	0	0	0.00	0.00	5,000,000	0.04	0.51	0.01
716423	康和XF	---	---	---	---	---	0.19	0	0	0	0.01	0.10	5,000,000	0.10	0.67	0.01
716424	康和XG	---	---	---	---	---	0.09	0	0	0	0.01	0.10	5,000,000	0.10	0.56	0.01
716425	中信UU	---	---	---	---	---	0.11	0	0	0	0.00	0.02	5,000,000	0.02	0.40	0.01
716426	日盛SZ	---	---	---	---	---	0.02	0	0	0	0.00	0.00	5,000,000	0.02	0.58	0.01
716427	日盛TA	---	---	---	---	---	0.01	0	0	0	0.00	0.00	5,000,000	0.01	0.75	0.01
716428	QP永豐	---	---	---	---	---	0.08	0	0	0	0.00	0.01	5,000,000	0.01	0.41	0.01
716429	QQ永豐	---	---	---	---	---	0.04	0	0	0	0.00	0.01	11,000,000	0.01	0.49	0.01
716430	QR永豐	---	---	---	---	---	0.40	0	0	0	0.00	0.02	9,900,000	0.02	1.09	0.01
716431	SE兆豐	---	---	---	---	---	0.07	0	0	0	0.00	0.02	5,000,000	0.02	0.48	0.01
716432	SF兆豐	---	---	---	---	---	0.12	0	0	0	0.00	0.02	5,000,000	0.02	0.42	0.01
716433	SG兆豐	0.83	+0.12	0.61	0.83	0.48	0.61	237,000	145,320	19	0.86	0.87	5,000,000	0.83	2.21	0.01
716434	SH兆豐	---	---	---	---	---	0.05	0	0	0	0.00	0.02	5,000,000	0.01	0.64	0.01
716435	SJ兆豐	---	---	---	---	---	0.03	0	0	0	0.00	0.01	5,000,000	0.01	1.21	0.01
716436	SK兆豐	---	---	---	---	---	0.30	0	0	0	0.00	0.02	5,000,000	0.02	1.54	0.01
716437	SL兆豐	---	---	---	---	---	0.05	0	0	0	0.00	0.02	5,000,000	0.02	1.64	0.01
716438	SM兆豐	---	---	---	---	---	0.03	0	0	0	0.00	0.02	5,000,000	0.02	0.59	0.01
716439	元富V3	---	---	---	---	---	0.10	0	0	0	0.01	0.03	5,000,000	0.03	0.29	0.01
71643P	日盛QZ	---	---	---	---	---	0.03	0	0	0	0.00	0.00	5,000,000	0.02	0.48	0.01
716440	元富V4	1.34	+0.10	1.34	1.34	1.34	1.34	20,000	26,800	1	1.17	1.27	5,000,000	1.34	2.44	0.24
716441	元富V5	---	---	---	---	---	0.01	0	0	0	0.00	0.00	5,000,000	0.01	0.57	0.01
716442	元富V6	---	---	---	---	---	0.06	0	0	0	0.04	0.05	5,000,000	0.05	0.62	0.01
716443	元大QT	---	---	---	---	---	5.09	0	0	0	0.00	0.00	20,000,000	3.43	5.10	1.73
716444	元大QU	---	---	---	---	---	0.03	0	0	0	0.00	0.02	5,000,000	0.02	1.32	0.01
716445	元大QW	---	---	---	---	---	0.02	0	0	0	0.02	0.03	5,000,000	0.02	0.80	0.01
716446	元大QZ	0.12	-0.05	0.12	0.12	0.12	0.12	1,005,000	120,600	6	0.12	0.13	5,000,000	0.12	0.69	0.01
716447	元大RF	---	---	---	---	---	0.01	0	0	0	0.00	0.10	5,000,000	0.01	0.58	0.01
716448	元大RL	---	---	---	---	---	0.13	0	0	0	0.00	0.02	5,000,000	0.01	0.49	0.01
716449	永昌XV	---	---	---	---	---	1.20	0	0	0	1.08	1.15	5,000,000	1.08	1.54	0.61
716450	永昌XW	---	---	---	---	---	1.31	0	0	0	2.73	2.79	5,000,000	2.73	3.93	1.53
716451	統一ZB	---	---	---	---	---	0.04	0	0	0	0.01	0.02	15,000,000	0.02	0.46	0.01
716452	統一ZC	---	---	---	---	---	0.05	0	0	0	0.01	0.05	5,000,000	0.02	0.32	0.01
716453	QA凱基	---	---	---	---	---	1.04	0	0	0	0.03	0.09	5,000,000	0.09	0.92	0.01
716454	群益VN	---	---	---	---	---	0.32	0	0	0	0.04	0.05	5,000,000	0.05	0.74	0.01
716455	元大RM	---	---	---	---	---	8.00	0	0	0	9.05	0.00	5,000,000	9.05	10.30	7.75
716456	元大SR	---	---	---	---	---	0.04	0	0	0	0.01	0.02	10,000,000	0.02	0.72	0.01