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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
722192	QL凱基	0.11	0.00	0.11	0.11	0.11	0.11	72,000	7,920	1	0.10	0.11	6,500,000	0.11	0.35	0.01
722193	QM凱基	---	---	---	---	---	0.11	0	0	0	0.09	0.10	5,000,000	0.10	0.54	0.01
722194	QN凱基	0.51	-0.05	0.49	0.51	0.49	0.50	13,000	6,470	3	0.48	0.50	5,000,000	0.51	1.36	0.01
722195	QP凱基	---	---	---	---	---	0.29	0	0	0	0.26	0.27	5,000,000	0.27	0.94	0.01
722196	QQ凱基	0.59	-0.02	0.59	0.59	0.59	0.59	20,000	11,800	1	0.56	0.58	5,000,000	0.59	1.36	0.01
722197	QR凱基	---	---	---	---	---	0.11	0	0	0	0.00	0.02	10,000,000	0.02	0.42	0.01
722198	QS凱基	---	---	---	---	---	0.01	0	0	0	0.00	0.02	10,000,000	0.01	0.52	0.01
722199	QU凱基	---	---	---	---	---	2.83	0	0	0	1.99	2.09	5,000,000	1.99	2.63	1.35
722200	XK第一	1.85	+0.19	1.85	1.85	1.84	1.84	118,000	217,310	3	1.72	1.77	15,000,000	1.85	2.82	0.88
722201	V8元大	---	---	---	---	---	0.01	0	0	0	0.00	0.02	5,000,000	0.01	0.52	0.01
722202	V9元大	0.34	-0.10	0.40	0.40	0.34	0.36	540,000	193,100	12	0.33	0.34	5,000,000	0.34	0.88	0.01
722203	W1元大	0.64	+0.06	0.70	0.74	0.64	0.69	429,000	294,940	39	0.63	0.64	5,000,000	0.64	2.26	0.01
722204	W2元大	---	---	---	---	---	0.10	0	0	0	0.01	0.02	5,000,000	0.02	0.38	0.01
722205	P7日盛	---	---	---	---	---	0.10	0	0	0	0.07	0.08	5,000,000	0.08	0.72	0.01
722206	P8日盛	0.38	-0.06	0.32	0.38	0.31	0.31	76,000	23,730	3	0.37	0.38	5,000,000	0.38	1.28	0.01
722207	永豐X2	0.53	-0.06	0.46	0.53	0.44	0.51	110,000	55,700	6	0.52	0.55	5,000,000	0.53	1.20	0.01
722208	永豐X3	---	---	---	---	---	0.03	0	0	0	0.02	0.03	5,000,000	0.03	0.75	0.01
722209	統一Q3	0.77	-0.04	0.75	0.77	0.72	0.75	79,000	59,490	8	0.77	0.78	5,000,000	0.77	1.29	0.25
722210	統一Q4	2.16	-0.19	2.34	2.34	2.16	2.20	19,000	41,850	6	2.16	2.21	10,000,000	2.16	3.00	1.32
722211	RI國泰	---	---	---	---	---	1.25	0	0	0	1.04	1.08	5,000,000	1.08	1.60	0.56
722212	QV凱基	0.19	-0.01	0.22	0.22	0.19	0.20	20,000	4,100	2	0.20	0.21	5,000,000	0.19	0.98	0.01
722213	QW凱基	---	---	---	---	---	0.06	0	0	0	0.02	0.03	5,000,000	0.03	0.36	0.01
722214	W4元大	0.31	+0.01	0.30	0.31	0.30	0.31	605,000	184,550	3	0.29	0.30	5,000,000	0.31	0.79	0.01
722215	康和SP	---	---	---	---	---	0.20	0	0	0	0.00	0.10	5,000,000	0.10	0.36	0.01
722216	統一Q5	0.33	-0.02	0.34	0.34	0.33	0.34	20,000	6,700	2	0.33	0.34	15,000,000	0.33	0.79	0.01
722217	統一Q6	0.31	0.00	0.31	0.31	0.31	0.31	13,000	4,030	2	0.30	0.31	5,000,000	0.31	0.69	0.01
722218	永豐X4	---	---	---	---	---	0.20	0	0	0	0.18	0.19	5,000,000	0.19	0.51	0.01
722219	XL第一	---	---	---	---	---	0.11	0	0	0	0.07	0.10	5,000,000	0.10	1.50	0.01
722220	TM元富	1.15	+0.19	1.15	1.17	1.15	1.16	36,000	41,600	5	1.13	1.15	6,000,000	1.15	1.90	0.40
722221	兆豐TS	---	---	---	---	---	0.12	0	0	0	0.07	0.08	5,000,000	0.08	0.34	0.01
722222	W5元大	0.03	-0.01	0.03	0.03	0.03	0.03	8,000	240	1	0.04	0.05	5,000,000	0.03	0.43	0.01
722223	W7元大	---	---	---	---	---	0.44	0	0	0	0.00	0.02	5,000,000	0.02	0.42	0.01
722224	W8元大	---	---	---	---	---	0.22	0	0	0	0.17	0.18	10,000,000	0.18	0.86	0.01
722225	W9元大	0.17	+0.03	0.17	0.17	0.17	0.17	100,000	17,000	1	0.16	0.17	5,000,000	0.17	0.70	0.01
722226	統一Q7	---	---	---	---	---	5.05	0	0	0	4.75	4.84	16,000,000	4.84	5.70	3.96
722227	統一Q8	0.85	-0.05	0.82	0.87	0.82	0.82	199,000	163,860	9	0.85	0.86	5,000,000	0.85	1.33	0.37
722228	QY凱基	---	---	---	---	---	0.15	0	0	0	0.01	0.02	10,000,000	0.02	0.50	0.01
722229	QZ凱基	0.24	-0.05	0.24	0.24	0.24	0.24	2,000	480	1	0.25	0.29	10,000,000	0.24	0.97	0.01
722230	RA凱基	---	---	---	---	---	2.53	0	0	0	1.89	1.99	5,000,000	1.89	2.85	0.93
722231	RB凱基	---	---	---	---	---	0.01	0	0	0	0.00	0.02	5,000,000	0.01	0.35	0.01
722232	TM群益	1.05	+0.13	0.90	1.05	0.90	0.95	597,000	567,550	32	1.06	1.07	5,000,000	1.05	1.44	0.66
722233	永豐X5	---	---	---	---	---	0.14	0	0	0	0.01	0.03	5,000,000	0.03	0.55	0.01
722234	RC凱基	0.31	+0.01	0.31	0.31	0.31	0.31	10,000	3,100	1	0.28	0.29	5,000,000	0.31	1.39	0.01
722235	RD凱基	---	---	---	---	---	1.86	0	0	0	1.87	1.90	5,000,000	1.87	3.15	0.59
722236	RE凱基	---	---	---	---	---	0.60	0	0	0	0.27	0.28	10,000,000	0.28	0.94	0.01
722237	XM第一	---	---	---	---	---	0.08	0	0	0	0.05	0.10	10,000,000	0.10	2.30	0.01
722238	玉山W1	---	---	---	---	---	0.19	0	0	0	0.10	0.11	10,000,000	0.11	1.05	0.01
722239	元大P2	---	---	---	---	---	0.04	0	0	0	0.02	0.03	5,000,000	0.03	0.39	0.01
722240	元大P3	---	---	---	---	---	8.30	0	0	0	7.20	0.00	5,000,000	8.30	9.70	6.90
722241	RJ國泰	---	---	---	---	---	0.26	0	0	0	0.25	0.26	5,000,000	0.26	1.58	0.01
722242	RF凱基	---	---	---	---	---	0.63	0	0	0	0.17	0.18	10,000,000	0.18	0.88	0.01
722243	RG凱基	---	---	---	---	---	0.21	0	0	0	0.19	0.20	10,000,000	0.20	0.67	0.01
722244	富邦SH	---	---	---	---	---	0.09	0	0	0	0.06	0.09	5,000,000	0.09	0.29	0.01
722245	TR元富	---	---	---	---	---	6.59	0	0	0	8.50	8.65	5,000,000	8.65	10.30	6.95
722246	TS元富	---	---	---	---	---	0.08	0	0	0	0.02	0.06	5,000,000	0.04	0.66	0.01
722247	元大P4	---	---	---	---	---	0.06	0	0	0	0.04	0.05	5,000,000	0.05	0.49	0.01
722248	元大P8	---	---	---	---	---	0.07	0	0	0	0.01	0.02	10,000,000	0.02	0.92	0.01
722249	元大P9	---	---	---	---	---	0.03	0	0	0	0.02	0.05	5,000,000	0.05	0.72	0.01
722250	元大Q1	---	---	---	---	---	0.32	0	0	0	0.01	0.02	5,000,000	0.02	0.40	0.01
722251	統一Q9	---	---	---	---	---	4.33	0	0	0	4.09	4.15	5,000,000	4.15	4.94	3.36
722252	統一R1	---	---	---	---	---	0.04	0	0	0	0.03	0.05	5,000,000	0.04	0.32	0.01
722253	永豐X6	---	---	---	---	---	0.12	0	0	0	0.01	0.03	5,000,000	0.03	0.76	0.01
722254	永豐X7	---	---	---	---	---	0.02	0	0	0	0.00	0.01	10,000,000	0.01	0.49	0.01
722255	永豐X8	---	---	---	---	---	4.86	0	0	0	6.50	6.90	5,000,000	6.90	8.30	5.50
722256	永豐X9	0.36	-0.02	0.37	0.37	0.36	0.36	73,000	26,380	2	0.31	0.32	5,000,000	0.36	0.90	0.01
722257	RK國泰	---	---	---	---	---	0.24	0	0	0	0.22	0.26	5,000,000	0.24	1.04	0.01
722258	XP第一	---	---	---	---	---	0.19	0	0	0	0.21	0.22	5,000,000	0.21	0.87	0.01
722259	XQ第一	---	---	---	---	---	13.80	0	0	0	12.80	0.00	5,000,000	15.40	18.20	12.60
722260	XR第一	---	---	---	---	---	0.84	0	0	0	0.07	0.10	15,000,000	0.10	0.76	0.01
722261	兆豐TT	---	---	---	---	---	0.44	0	0	0	0.01	0.02	5,000,000	0.02	0.72	0.01
722262	TT元富	---	---	---	---	---	0.37	0	0	0	0.27	0.28	5,000,000	0.27	0.71	0.01
722263	康和SQ	---	---	---	---	---	0.02	0	0	0	0.00	0.10	20,000,000	0.02	0.66	0.01
722264	永豐Y1	---	---	---	---	---	0.33	0	0	0	0.10	0.11	5,034,000	0.11	0.59	0.01
722265	永豐Y2	---	---	---	---	---	0.02	0	0	0	0.00	0.01	5,000,000	0.01	0.57	0.01
722266	永豐Y3	0.44	-0.11	0.45	0.45	0.44	0.44	60,000	26,700	2	0.44	0.46	13,000,000	0.44	0.90	0.01
722267	TP群益	0.30	-0.06	0.33	0.33	0.30	0.33	130,000	42,600	2	0.32	0.33	7,000,000	0.30	0.85	0.01
722268	Q2日盛	---	---	---	---	---	0.06	0	0	0	0.03	0.04	5,000,000	0.04	0.74	0.01
722269	統一R4	0.15	+0.01	0.17	0.17	0.15	0.16	251,000	40,670	4	0.15	0.16	5,000,000	0.15	0.63	0.01
722270	RM凱基	---	---	---	---	---	0.07	0	0	0	0.04	0.05	5,000,000	0.05	0.39	0.01
722271	RN凱基	---	---	---	---	---	0.08	0	0	0	0.07	0.08	5,000,000	0.08	0.59	0.01
722272	RP凱基	0.51	-0.05	0.51	0.51	0.51	0.51	10,000	5,100	1	0.52	0.54	5,000,000	0.51	1.03	0.01
722273	RQ凱基	0.55	-0.04	0.56	0.56	0.52	0.55	229,000	125,760	8	0.55	0.56	5,000,000	0.55	1.10	0.01
722274	RR凱基	0.41	+0.01	0.40	0.41	0.40	0.41	19,000	7,740	2	0.42	0.43	5,000,000	0.41	0.96	0.01
722275	RS凱基	---	---	---	---	---	1.21	0	0	0	1.17	1.27	5,000,000	1.17	1.77	0.57
722276	RT凱基	0.94	+0.05	0.93	0.96	0.92	0.93	381,000	355,870	13	0.94	1.01	5,000,000	0.94	1.54	0.34
722277	RU凱基	---	---	---	---	---	7.56	0	0	0	7.10	7.60	5,000,000	7.55	8.95	6.15
722278	RV凱基	---	---	---	---	---	0.12	0	0	0	0.10	0.11	5,000,000	0.11	0.35	0.01
722279	RW凱基	2.51	+0.32	2.14	2.51	2.14	2.27	236,000	536,430	13	2.36	2.39	5,000,000	2.51	3.42	1.60
722280	RX凱基	0.31	+0.07	0.28	0.33	0.27	0.30	801,000	237,260	20	0.30	0.31	5,000,000	0.31	0.67	0.01
722281	富邦SJ	1.31	-0.03	1.31	1.31	1.31	1.31	20,000	26,200	1	1.32	1.33	5,000,000	1.31	1.87	0.75
722282	TU元富	---	---	---	---	---	2.67	0	0	0	2.42	2.48	5,000,000	2.42	3.38	1.46
722283	TV元富	---	---	---	---	---	0.16	0	0	0	0.13	0.15	6,000,000	0.15	1.45	0.01
722284	RY凱基	0.68	+0.01	0.70	0.70	0.68	0.69	40,000	27,600	2	0.66	0.67	10,000,000	0.68	1.31	0.05
722285	富邦SK	0.35	+0.01	0.35	0.35	0.35	0.35	10,000	3,500	1	0.33	0.34	5,000,000	0.35	1.04	0.01
722286	富邦SL	0.50	-0.13	0.60	0.60	0.50	0.54	184,000	99,840	7	0.50	0.51	5,000,000	0.50	1.06	0.01
722287	XS第一	---	---	---	---	---	1.62	0	0	0	2.17	2.26	5,000,000	2.17	3.13	1.21
722288	XU第一	---	---	---	---	---	0.22	0	0	0	0.14	0.18	5,000,000	0.14	1.58	0.01
722289	統一R5	---	---	---	---	---	0.45	0	0	0	0.42	0.43	17,000,000	0.43	0.84	0.02
722290	統一R6	0.25	0.00	0.25	0.25	0.25	0.25	60,000	15,000	2	0.25	0.26	5,000,000	0.25	0.63	0.01
722291	永豐Y4	0.17	-0.04	0.17	0.17	0.17	0.17	100,000	17,000	4	0.17	0.19	13,000,000	0.17	0.67	0.01