SQL: SELECT * FROM this || 上櫃股票行情

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
718638	國票SG	0.67	+0.06	0.54	0.67	0.54	0.62	411,000	253,590	7	0.68	0.69	12,000,000	0.67	1.49	0.01
718639	ZQ凱基	0.71	-0.02	0.50	0.75	0.50	0.63	105,000	65,890	6	0.73	0.75	5,000,000	0.71	1.63	0.01
71863P	元富RT	2.03	+0.19	2.04	2.04	2.03	2.03	48,000	97,640	3	2.05	0.00	10,000,000	2.03	2.88	1.18
718640	ZR凱基	---	---	---	---	---	0.43	0	0	0	0.07	0.08	5,000,000	0.08	0.46	0.01
718641	VS群益	1.44	+0.13	1.40	1.44	1.34	1.35	110,000	148,020	4	1.38	1.42	7,000,000	1.44	3.28	0.01
718642	永豐RR	0.24	-0.01	0.17	0.25	0.16	0.22	795,000	171,620	13	0.24	0.25	11,000,000	0.24	1.89	0.01
718643	永豐RS	0.36	-0.04	0.30	0.37	0.28	0.34	131,000	44,000	7	0.38	0.39	5,000,000	0.36	0.92	0.01
718644	永豐RT	0.22	+0.05	0.22	0.22	0.22	0.22	1,000	220	1	0.20	0.21	5,000,000	0.22	0.76	0.01
718645	康和T3	---	---	---	---	---	0.31	0	0	0	0.25	0.35	10,000,000	0.31	0.73	0.01
718646	元富WP	0.36	-0.08	0.33	0.36	0.33	0.35	133,000	46,890	4	0.35	0.36	13,000,000	0.36	1.21	0.01
718647	元富WQ	0.54	-0.06	0.48	0.56	0.48	0.50	166,000	82,180	7	0.52	0.53	5,000,000	0.54	1.00	0.08
718648	PB日盛	0.18	-0.04	0.14	0.18	0.14	0.16	610,000	95,500	17	0.17	0.18	5,000,000	0.18	0.85	0.01
718649	PC日盛	0.69	+0.12	0.58	0.69	0.50	0.62	365,000	226,670	10	0.69	0.70	5,000,000	0.69	1.47	0.01
71864P	康和ZF	---	---	---	---	---	0.03	0	0	0	0.04	0.10	20,000,000	0.06	0.93	0.01
718650	PD日盛	0.65	-0.23	0.65	0.65	0.65	0.65	99,000	64,350	1	0.63	0.64	12,000,000	0.65	1.32	0.01
718651	統一QG	0.32	-0.03	0.27	0.36	0.25	0.31	808,000	248,710	14	0.33	0.34	15,000,000	0.32	0.98	0.01
718652	統一QH	0.39	+0.03	0.31	0.41	0.27	0.33	930,000	303,070	31	0.38	0.41	15,000,000	0.39	0.85	0.01
718653	統一QJ	0.13	+0.02	0.10	0.13	0.10	0.12	762,000	90,470	10	0.12	0.13	5,000,000	0.13	0.53	0.01
718654	ZT凱基	---	---	---	---	---	1.36	0	0	0	1.04	1.10	5,000,000	1.10	2.20	0.01
718655	ZU凱基	0.34	-0.03	0.31	0.34	0.31	0.32	40,000	12,700	3	0.34	0.35	5,000,000	0.34	0.83	0.01
718656	W7富邦	0.37	+0.01	0.36	0.37	0.36	0.36	241,000	87,550	2	0.39	0.40	5,000,000	0.37	2.23	0.01
718657	W8富邦	1.56	+0.02	1.25	1.56	1.22	1.26	83,000	104,470	5	1.55	1.57	5,000,000	1.56	2.94	0.18
718658	康和T4	0.67	+0.05	0.52	0.78	0.50	0.65	6,878,000	4,488,350	133	0.66	0.68	13,000,000	0.67	1.32	0.01
718659	康和T5	0.56	-0.03	0.54	0.56	0.54	0.56	30,000	16,760	2	0.60	0.61	10,000,000	0.56	1.02	0.08
71865P	YE永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.05	5,000,000	0.05	0.95	0.01
718660	永豐RU	1.35	-0.32	0.93	1.35	0.93	1.00	12,000	11,980	4	1.31	1.35	10,550,000	1.35	2.26	0.44
718661	永豐RV	---	---	---	---	---	0.32	0	0	0	0.34	0.35	5,000,000	0.34	0.87	0.01
718662	VW群益	1.60	-0.08	1.40	1.69	0.95	1.07	33,000	35,270	10	1.53	1.60	5,000,000	1.60	3.73	0.01
718663	VX群益	1.02	-0.11	0.92	1.10	0.92	1.00	103,000	103,160	10	1.02	1.07	5,000,000	1.02	2.28	0.01
718664	VY群益	0.20	-0.11	0.16	0.20	0.16	0.20	103,000	20,560	3	0.20	0.21	5,397,000	0.20	0.70	0.01
718665	國泰UL	1.23	0.00	1.00	1.30	0.90	1.09	353,000	384,600	15	1.21	1.29	8,000,000	1.23	3.88	0.01
718666	YG兆豐	0.28	+0.05	0.14	0.28	0.14	0.17	556,000	94,940	17	0.24	0.25	5,000,000	0.28	1.99	0.01
718667	YH兆豐	0.51	-0.31	0.56	0.57	0.50	0.54	130,000	70,300	13	0.51	0.60	5,000,000	0.51	1.30	0.01
718668	YJ兆豐	0.32	-0.05	0.25	0.32	0.25	0.26	168,000	43,280	5	0.32	0.33	5,000,000	0.32	1.00	0.01
718669	YK兆豐	0.03	-0.01	0.03	0.03	0.03	0.03	40,000	1,200	4	0.04	0.05	5,000,000	0.03	0.57	0.01
71866P	國泰RU	---	---	---	---	---	2.40	0	0	0	2.37	2.43	5,000,000	2.40	3.42	1.38
718670	元富WR	0.85	0.00	0.66	0.90	0.66	0.79	23,000	18,090	5	0.36	0.00	5,000,000	0.85	1.77	0.01
718671	國票SK	---	---	---	---	---	0.26	0	0	0	0.06	0.07	5,000,000	0.07	0.96	0.01
718672	ZV凱基	---	---	---	---	---	0.53	0	0	0	0.40	0.45	5,000,000	0.42	1.27	0.01
718673	ZW凱基	1.18	+0.04	0.82	1.20	0.82	1.06	980,000	1,039,670	25	1.16	1.17	5,000,000	1.18	1.97	0.39
718674	PE日盛	0.28	-0.04	0.23	0.28	0.23	0.27	40,000	10,650	3	0.31	0.32	5,000,000	0.28	1.60	0.01
718675	PF日盛	---	---	---	---	---	0.18	0	0	0	0.15	0.16	5,000,000	0.16	0.88	0.01
718676	PG日盛	0.53	+0.08	0.32	0.53	0.32	0.37	143,000	53,450	11	0.48	0.49	15,000,000	0.53	1.22	0.01
718677	PH日盛	---	---	---	---	---	0.19	0	0	0	0.13	0.14	5,000,000	0.14	0.52	0.01
718678	PJ日盛	1.13	+0.04	0.83	1.13	0.82	0.95	726,000	692,620	32	1.09	1.11	5,000,000	1.13	1.57	0.67
718679	PK日盛	0.77	+0.03	0.77	0.77	0.77	0.77	20,000	15,400	1	0.74	0.76	5,000,000	0.77	1.64	0.01
71867P	國泰RV	2.08	+0.48	1.91	2.08	1.91	2.00	20,000	39,900	2	1.68	1.77	5,000,000	2.08	3.10	1.06
718680	UW第一	---	---	---	---	---	8.65	0	0	0	7.85	8.30	5,000,000	8.30	11.70	4.83
718681	元大QQ	---	---	---	---	---	0.43	0	0	0	0.00	0.00	5,000,000	0.32	1.00	0.01
718682	元大QR	0.23	-0.08	0.24	0.24	0.23	0.24	300,000	71,000	3	0.00	0.00	5,000,000	0.23	0.72	0.01
718683	元大QV	0.87	-0.02	0.71	0.87	0.67	0.77	1,062,000	821,460	35	0.86	0.90	10,000,000	0.87	2.19	0.01
718684	VZ群益	---	---	---	---	---	0.67	0	0	0	0.04	0.05	5,000,000	0.05	1.03	0.01
718685	WA群益	7.05	+1.95	3.79	7.05	3.58	4.63	16,000	74,150	5	6.70	7.00	7,000,000	7.05	10.30	3.76
718686	WB群益	0.16	+0.04	0.13	0.17	0.13	0.16	550,000	86,500	7	0.16	0.17	5,000,000	0.16	0.76	0.01
718687	WC群益	---	---	---	---	---	0.26	0	0	0	0.17	0.18	8,000,000	0.18	1.25	0.01
718688	WD群益	0.17	-0.06	0.17	0.17	0.17	0.17	10,000	1,700	1	0.16	0.18	10,000,000	0.17	0.77	0.01
718689	WE群益	5.25	+0.25	4.00	5.25	3.96	4.71	449,000	2,114,930	15	5.15	5.25	5,000,000	5.25	6.85	3.61
71868P	SM元大	1.90	+0.25	1.90	1.90	1.90	1.90	2,000	3,800	1	1.61	1.67	5,000,000	1.90	2.50	1.30
718690	永豐RW	---	---	---	---	---	0.28	0	0	0	0.10	0.12	12,000,000	0.12	0.87	0.01
718691	永豐RX	0.67	+0.12	0.47	0.67	0.42	0.54	997,000	537,180	53	0.66	0.68	5,000,000	0.67	1.36	0.01
718692	永豐RY	0.29	-0.04	0.29	0.29	0.29	0.29	5,000	1,450	1	0.30	0.31	5,000,000	0.29	0.83	0.01
718693	永豐RZ	0.10	-0.01	0.09	0.10	0.09	0.09	50,000	4,700	3	0.09	0.10	11,000,000	0.10	0.59	0.01
718694	康和T6	---	---	---	---	---	0.10	0	0	0	0.03	0.09	5,000,000	0.09	0.40	0.01
718695	康和T7	---	---	---	---	---	0.30	0	0	0	0.08	0.12	5,000,000	0.11	0.59	0.01
718696	PL日盛	0.93	-0.06	0.75	0.93	0.75	0.86	105,000	89,850	5	1.02	1.04	5,000,000	0.93	1.40	0.46
718697	元富WT	---	---	---	---	---	0.33	0	0	0	0.20	0.21	5,000,000	0.21	0.97	0.01
718698	元富WU	---	---	---	---	---	0.74	0	0	0	0.06	0.26	5,000,000	0.26	0.92	0.01
718699	永豐SA	0.67	+0.04	0.66	0.67	0.66	0.67	28,000	18,660	2	0.65	0.67	5,000,000	0.67	1.38	0.01
71869P	元富RY	0.46	+0.24	0.43	0.46	0.43	0.44	100,000	44,500	2	0.45	0.46	5,000,000	0.46	1.45	0.01
718700	永豐SB	0.28	-0.05	0.23	0.29	0.23	0.26	165,000	43,690	7	0.27	0.28	10,000,000	0.28	0.82	0.01
718701	永豐SC	0.45	-0.08	0.35	0.45	0.31	0.38	1,037,000	392,820	17	0.45	0.46	5,000,000	0.45	1.14	0.01
718702	國票SL	0.43	-0.07	0.35	0.48	0.27	0.36	893,000	321,860	71	0.41	0.42	5,000,000	0.43	1.13	0.01
718703	UX第一	---	---	---	---	---	0.21	0	0	0	0.17	0.20	5,000,000	0.17	0.57	0.01
718704	元大QX	0.20	-0.04	0.20	0.20	0.18	0.20	208,000	40,700	6	0.19	0.20	16,000,000	0.20	0.69	0.01
718705	元大QY	0.20	-0.04	0.20	0.20	0.20	0.20	10,000	2,000	1	0.20	0.21	15,000,000	0.20	0.68	0.01
718706	元大RB	0.46	-0.07	0.44	0.51	0.42	0.46	606,000	280,180	10	0.45	0.46	5,000,000	0.46	0.97	0.01
718707	WF群益	1.71	-0.16	1.65	1.71	1.57	1.63	168,000	273,460	4	1.99	2.00	6,840,000	1.71	3.43	0.01
718708	PM日盛	0.26	+0.01	0.22	0.26	0.22	0.24	6,000	1,440	2	0.26	0.27	5,000,000	0.26	0.63	0.01
718709	統一QK	0.34	-0.03	0.33	0.39	0.32	0.34	822,000	278,360	11	0.35	0.36	15,000,000	0.34	1.41	0.01
71870P	QF群益	0.38	-0.02	0.53	0.55	0.38	0.47	950,000	449,070	22	0.38	0.39	10,000,000	0.38	1.35	0.01
718710	元富WW	---	---	---	---	---	0.33	0	0	0	0.33	0.36	5,000,000	0.36	0.86	0.01
718711	元大RC	0.19	-0.05	0.19	0.19	0.19	0.19	1,000	190	1	0.18	0.19	10,000,000	0.19	1.03	0.01
718712	元大RE	1.01	0.00	0.91	1.01	0.67	0.90	83,000	74,710	13	0.97	0.99	5,000,000	1.01	1.83	0.19
718713	永豐SD	0.63	+0.13	0.42	0.66	0.32	0.53	2,588,000	1,363,780	78	0.62	0.63	5,000,000	0.63	1.40	0.01
718714	永豐SE	0.54	-0.07	0.50	0.56	0.50	0.52	449,000	232,120	9	0.51	0.52	10,000,000	0.54	1.43	0.01
718715	永豐SF	0.58	+0.04	0.47	0.58	0.44	0.51	881,000	451,460	19	0.57	0.58	5,000,000	0.58	1.22	0.01
718716	永豐SG	0.21	+0.03	0.20	0.21	0.19	0.19	221,000	42,210	3	0.20	0.21	12,000,000	0.21	1.03	0.01
718717	康和T8	---	---	---	---	---	1.87	0	0	0	1.37	1.43	5,000,000	1.43	2.28	0.58
718718	康和T9	---	---	---	---	---	0.19	0	0	0	0.11	0.12	5,000,000	0.12	0.88	0.01
718719	康和U1	0.26	-0.11	0.22	0.28	0.20	0.27	142,000	37,890	7	0.26	0.28	5,000,000	0.26	0.74	0.01
71871P	QG群益	1.16	-0.01	1.24	1.24	1.16	1.17	119,000	139,470	4	1.15	1.17	5,000,000	1.16	1.73	0.59
718720	WG群益	0.67	+0.16	0.33	0.67	0.33	0.58	1,191,000	684,930	45	0.63	0.73	5,000,000	0.67	1.44	0.01
718721	WH群益	0.85	+0.01	0.78	0.88	0.78	0.82	1,064,000	869,670	15	0.87	0.88	5,000,000	0.85	1.46	0.21
718722	WJ群益	1.11	-0.10	1.01	1.24	0.99	1.12	1,169,000	1,306,620	40	1.10	1.11	5,000,000	1.11	2.27	0.01
718723	國泰UM	0.92	+0.07	0.80	1.02	0.67	0.86	3,623,000	3,116,680	141	0.92	0.00	5,000,000	0.92	1.62	0.20
718724	YL兆豐	0.63	+0.04	0.64	0.64	0.59	0.61	156,000	95,090	9	0.64	0.65	5,000,000	0.63	1.95	0.01
718725	永豐SH	---	---	---	---	---	1.54	0	0	0	1.53	1.58	11,000,000	1.53	2.66	0.40
718726	永豐SI	---	---	---	---	---	0.14	0	0	0	0.11	0.12	11,000,000	0.12	1.19	0.01
718727	永豐SJ	0.23	+0.06	0.17	0.23	0.17	0.20	100,000	20,000	2	0.18	0.20	10,000,000	0.23	0.85	0.01
718728	YM兆豐	---	---	---	---	---	2.30	0	0	0	1.80	1.81	5,000,000	1.80	3.18	0.42