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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
722592	元大QE	---	---	---	---	---	0.05	0	0	0	0.04	0.05	5,000,000	0.05	0.61	0.01
722593	元大QJ	0.14	-0.01	0.14	0.14	0.14	0.14	130,000	18,200	1	0.14	0.15	5,000,000	0.14	0.40	0.01
722594	R9日盛	---	---	---	---	---	0.45	0	0	0	0.38	0.39	10,000,000	0.39	1.27	0.01
722595	康和TF	---	---	---	---	---	0.29	0	0	0	0.24	0.25	5,000,000	0.24	0.77	0.01
722596	永豐QT	---	---	---	---	---	0.05	0	0	0	0.00	0.01	5,000,000	0.01	0.85	0.01
722597	永豐QU	---	---	---	---	---	0.31	0	0	0	0.26	0.27	5,000,000	0.27	0.78	0.01
722598	永豐QV	---	---	---	---	---	1.44	0	0	0	1.64	1.74	5,000,000	1.66	2.38	0.94
722599	中信YQ	---	---	---	---	---	0.46	0	0	0	0.34	0.36	5,000,000	0.36	1.02	0.01
722600	SD國泰	0.43	-0.25	0.43	0.43	0.43	0.43	110,000	47,300	3	0.42	0.43	5,000,000	0.43	1.63	0.01
722601	VC群益	1.13	+0.10	1.13	1.13	1.13	1.13	10,000	11,300	1	1.17	1.20	5,000,000	1.13	1.42	0.84
722602	VD群益	---	---	---	---	---	0.34	0	0	0	0.11	0.12	5,000,000	0.12	0.82	0.01
722603	S1日盛	0.35	+0.01	0.35	0.36	0.35	0.36	629,000	225,460	10	0.34	0.35	20,000,000	0.35	0.73	0.01
722604	S2日盛	0.67	+0.02	0.70	0.70	0.65	0.67	953,000	640,760	37	0.66	0.67	5,000,000	0.67	1.15	0.19
722605	統一T7	0.36	-0.03	0.36	0.38	0.36	0.36	64,000	23,240	3	0.36	0.37	12,500,000	0.36	0.80	0.01
722606	永豐QW	0.08	-0.01	0.08	0.08	0.08	0.08	20,000	1,600	1	0.09	0.10	5,000,000	0.08	0.35	0.01
722607	VE元富	0.29	+0.08	0.27	0.29	0.27	0.29	36,000	10,420	3	0.27	0.28	5,000,000	0.29	0.82	0.01
722608	TV凱基	---	---	---	---	---	0.20	0	0	0	0.01	0.02	5,000,000	0.02	0.43	0.01
722609	中信YR	---	---	---	---	---	4.05	0	0	0	0.00	0.00	5,000,000	6.15	7.25	5.05
722610	SE國泰	---	---	---	---	---	2.56	0	0	0	2.59	0.00	5,000,000	2.61	3.57	1.65
722611	SF國泰	---	---	---	---	---	0.08	0	0	0	0.03	0.07	5,000,000	0.07	0.43	0.01
722612	SG國泰	2.42	-0.30	2.45	2.45	2.42	2.43	13,000	31,580	2	2.46	2.50	5,000,000	2.42	3.38	1.46
722613	VE群益	---	---	---	---	---	0.11	0	0	0	0.09	0.10	5,000,000	0.10	0.57	0.01
722614	元大QR	---	---	---	---	---	3.52	0	0	0	3.32	3.41	5,000,000	3.32	4.76	1.88
722615	元大QS	---	---	---	---	---	0.31	0	0	0	0.03	0.04	5,000,000	0.04	0.45	0.01
722616	元大QT	---	---	---	---	---	6.87	0	0	0	5.80	0.00	5,000,000	6.85	8.25	5.45
722617	元大QU	---	---	---	---	---	0.26	0	0	0	0.18	0.19	5,000,000	0.19	0.67	0.01
722618	元大RA	0.51	-0.04	0.58	0.60	0.51	0.56	540,000	301,400	10	0.51	0.53	5,000,000	0.51	1.20	0.01
722619	S3日盛	---	---	---	---	---	0.36	0	0	0	0.37	0.38	5,000,000	0.38	0.81	0.01
722620	統一T8	---	---	---	---	---	3.36	0	0	0	3.50	3.59	16,000,000	3.59	4.35	2.83
722621	兆豐UH	0.24	-0.06	0.24	0.24	0.24	0.24	5,000	1,200	1	0.25	0.26	5,000,000	0.24	0.75	0.01
722622	VJ元富	0.04	-0.04	0.04	0.04	0.04	0.04	400,000	16,000	5	0.03	0.04	5,000,000	0.04	0.60	0.01
722623	TW凱基	---	---	---	---	---	0.32	0	0	0	0.29	0.30	10,000,000	0.30	0.71	0.01
722624	TX凱基	---	---	---	---	---	0.21	0	0	0	0.15	0.16	10,000,000	0.16	0.93	0.01
722625	TY凱基	0.34	-0.10	0.40	0.43	0.33	0.38	1,250,000	469,750	39	0.33	0.34	10,000,000	0.34	0.82	0.01
722626	TZ凱基	---	---	---	---	---	2.07	0	0	0	1.79	1.85	5,000,000	1.85	2.65	1.05
722627	富邦SY	---	---	---	---	---	3.89	0	0	0	3.48	0.00	5,000,000	4.10	4.95	3.25
722628	YJ第一	4.00	+0.74	4.00	4.00	4.00	4.00	5,000	20,000	1	3.68	4.00	5,000,000	4.00	5.10	2.90
722629	玉山W9	0.63	-0.11	0.65	0.65	0.63	0.64	154,000	99,140	2	0.67	0.68	10,000,000	0.63	1.51	0.01
722630	元大RL	0.39	+0.01	0.40	0.40	0.39	0.40	132,000	52,480	5	0.36	0.37	5,000,000	0.39	0.87	0.01
722631	元大RM	0.37	-0.06	0.38	0.38	0.37	0.38	100,000	37,500	2	0.37	0.39	5,000,000	0.37	1.09	0.01
722632	元大RN	0.93	-0.05	0.92	0.94	0.86	0.91	294,000	266,350	14	0.93	0.94	5,000,000	0.93	1.68	0.18
722633	元大RP	3.42	+0.58	3.09	3.42	3.09	3.13	38,000	119,070	2	3.36	3.42	5,000,000	3.42	4.96	1.88
722634	元大RU	---	---	---	---	---	1.88	0	0	0	0.00	0.00	5,000,000	1.86	2.82	0.90
722635	永豐QX	---	---	---	---	---	2.15	0	0	0	1.71	1.76	5,000,000	1.71	2.34	1.08
722636	永豐QY	0.03	-0.01	0.03	0.03	0.03	0.03	100,000	3,000	1	0.02	0.03	5,000,000	0.03	0.40	0.01
722637	永豐QZ	0.28	-0.06	0.27	0.30	0.26	0.28	1,031,000	292,600	37	0.26	0.28	5,121,000	0.28	0.47	0.09
722638	永豐RA	---	---	---	---	---	0.41	0	0	0	0.40	0.41	5,000,000	0.40	0.73	0.07
722639	永豐RB	---	---	---	---	---	1.53	0	0	0	1.35	1.38	5,000,000	1.38	1.84	0.92
722640	永豐RC	0.81	-0.13	0.81	0.81	0.81	0.81	10,000	8,100	1	0.88	0.90	5,000,000	0.81	1.29	0.33
722641	中信YS	0.33	-0.02	0.32	0.33	0.32	0.33	39,000	12,780	3	0.32	0.33	5,000,000	0.33	0.98	0.01
722642	SH國泰	1.16	-0.08	1.13	1.17	1.12	1.14	400,000	458,000	4	1.13	1.17	5,000,000	1.16	1.80	0.52
722643	VH群益	---	---	---	---	---	1.41	0	0	0	1.44	1.48	5,000,000	1.44	2.01	0.87
722644	VJ群益	---	---	---	---	---	0.22	0	0	0	0.18	0.19	5,000,000	0.18	0.54	0.01
722645	VK群益	0.21	0.00	0.21	0.21	0.21	0.21	10,000	2,100	1	0.21	0.22	5,000,000	0.21	0.57	0.01
722646	VL群益	1.26	-0.02	1.26	1.26	1.26	1.26	78,000	98,280	1	1.26	1.29	5,000,000	1.26	2.62	0.01
722647	VK元富	---	---	---	---	---	6.45	0	0	0	5.30	5.35	5,000,000	5.35	6.60	4.07
722648	VL元富	0.82	+0.02	0.80	0.84	0.80	0.82	315,000	259,000	6	0.82	0.83	5,000,000	0.82	1.51	0.13
722649	富邦SZ	---	---	---	---	---	0.43	0	0	0	0.39	0.40	5,000,000	0.39	1.06	0.01
722650	富邦TA	---	---	---	---	---	1.68	0	0	0	1.47	1.48	5,000,000	1.48	2.32	0.64
722651	富邦TB	0.41	-0.12	0.50	0.50	0.41	0.48	62,000	29,510	7	0.41	0.44	5,000,000	0.41	1.02	0.01
722652	富邦TC	0.93	+0.07	0.93	0.93	0.93	0.93	130,000	120,900	3	0.90	0.93	5,000,000	0.93	1.66	0.17
722653	YK第一	---	---	---	---	---	0.45	0	0	0	0.03	0.12	5,000,000	0.12	0.48	0.01
722654	統一T9	---	---	---	---	---	0.14	0	0	0	0.10	0.11	5,000,000	0.11	0.36	0.01
722655	永豐RD	0.71	+0.05	0.72	0.75	0.70	0.71	444,000	315,820	6	0.72	0.73	5,000,000	0.71	1.76	0.01
722656	永豐RE	---	---	---	---	---	2.84	0	0	0	3.73	3.77	5,000,000	3.77	4.56	2.98
722657	永豐RF	0.61	-0.01	0.61	0.61	0.61	0.61	100,000	61,000	1	0.60	0.62	5,000,000	0.61	1.23	0.01
722658	SJ國泰	---	---	---	---	---	2.56	0	0	0	2.85	0.00	5,000,000	2.85	3.62	2.08
722659	S5日盛	0.29	+0.01	0.29	0.29	0.29	0.29	70,000	20,300	1	0.27	0.28	20,000,000	0.29	0.86	0.01
722660	VN元富	---	---	---	---	---	0.09	0	0	0	0.08	0.09	5,000,000	0.09	0.44	0.01
722661	UA凱基	0.99	+0.02	0.98	0.99	0.95	0.97	553,000	538,820	12	0.98	0.99	5,000,000	0.99	1.50	0.48
722662	元大UF	0.57	+0.13	0.45	0.62	0.45	0.56	1,498,000	842,640	45	0.56	0.57	5,000,000	0.57	1.10	0.04
722663	元大UG	---	---	---	---	---	1.46	0	0	0	1.38	1.43	5,000,000	1.43	2.24	0.62
722664	元大UK	0.25	-0.01	0.25	0.25	0.25	0.25	40,000	10,000	2	0.25	0.26	5,000,000	0.25	1.18	0.01
722665	元大UL	---	---	---	---	---	0.19	0	0	0	0.21	0.22	5,000,000	0.21	0.48	0.01
722666	元大UP	0.60	-0.10	0.72	0.73	0.59	0.62	820,000	506,830	38	0.59	0.60	5,000,000	0.60	1.65	0.01
722667	康和TK	---	---	---	---	---	0.03	0	0	0	0.03	0.10	5,000,000	0.05	0.42	0.01
722668	永豐RG	---	---	---	---	---	0.29	0	0	0	0.25	0.26	5,000,000	0.26	0.57	0.01
722669	永豐RH	---	---	---	---	---	0.31	0	0	0	0.26	0.27	5,000,000	0.27	0.99	0.01
722670	中信YT	0.19	-0.10	0.19	0.19	0.19	0.19	518,000	98,420	2	0.18	0.19	5,000,000	0.19	1.13	0.01
722671	VM群益	0.92	-0.13	0.96	0.96	0.92	0.94	27,000	25,440	3	0.92	0.94	5,000,000	0.92	1.55	0.29
722672	UB凱基	---	---	---	---	---	0.72	0	0	0	0.54	0.64	5,000,000	0.64	1.48	0.01
722673	S6日盛	0.66	-0.13	0.73	0.73	0.65	0.66	397,000	261,880	13	0.66	0.69	5,000,000	0.66	1.50	0.01
722674	元大UQ	0.17	-0.02	0.17	0.17	0.17	0.17	161,000	27,370	3	0.17	0.18	5,000,000	0.17	0.84	0.01
722675	元大US	0.80	-0.12	0.83	0.84	0.80	0.82	140,000	115,100	7	0.79	0.81	5,000,000	0.80	1.64	0.01
722676	元大UT	---	---	---	---	---	4.91	0	0	0	4.11	0.00	5,000,000	4.91	6.05	3.77
722677	元大UV	0.34	-0.03	0.37	0.37	0.34	0.35	210,000	72,700	9	0.34	0.36	5,000,000	0.34	0.95	0.01
722678	永豐RI	---	---	---	---	---	0.33	0	0	0	0.27	0.28	5,000,000	0.28	0.73	0.01
722679	永豐RJ	---	---	---	---	---	0.44	0	0	0	0.33	0.34	5,000,000	0.33	0.83	0.01
722680	統一U1	0.20	-0.02	0.22	0.22	0.20	0.21	150,000	31,000	2	0.21	0.22	5,000,000	0.20	0.43	0.01
722681	VP元富	---	---	---	---	---	1.01	0	0	0	1.04	1.06	5,000,000	1.06	1.90	0.22
722682	元大UZ	1.40	+0.12	1.36	1.40	1.36	1.37	30,000	41,200	2	1.35	1.38	5,000,000	1.40	2.00	0.80
722683	永豐RK	---	---	---	---	---	0.14	0	0	0	0.12	0.13	5,000,000	0.13	0.52	0.01
722684	永豐RL	0.09	-0.01	0.09	0.09	0.09	0.09	90,000	8,100	9	0.09	0.10	5,000,000	0.09	0.47	0.01
722685	永豐RM	1.03	+0.06	1.10	1.10	1.01	1.07	364,000	389,210	12	1.02	1.03	5,000,000	1.03	1.92	0.14
722686	UC凱基	---	---	---	---	---	0.45	0	0	0	0.32	0.33	5,000,000	0.33	0.85	0.01
722687	UD凱基	0.29	-0.04	0.32	0.32	0.28	0.29	323,000	95,220	11	0.29	0.30	10,000,000	0.29	0.89	0.01
722688	VP群益	0.33	0.00	0.33	0.33	0.33	0.33	10,000	3,300	1	0.32	0.33	7,000,000	0.33	0.82	0.01
722689	中信YU	1.05	+0.02	1.03	1.05	1.03	1.04	60,000	62,400	4	1.05	1.06	5,000,000	1.05	1.47	0.63
722690	S7日盛	0.36	+0.05	0.36	0.36	0.36	0.36	9,000	3,240	1	0.33	0.34	5,000,000	0.36	0.84	0.01
722691	VR元富	---	---	---	---	---	0.99	0	0	0	0.90	0.91	5,000,000	0.91	1.71	0.11