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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
718366	國票RT	0.37	-0.03	0.37	0.37	0.37	0.37	308,000	113,960	2	0.42	0.43	5,000,000	0.37	0.91	0.01
718367	W2富邦	---	---	---	---	---	0.49	0	0	0	0.47	0.53	10,000,000	0.49	1.59	0.01
718368	W3富邦	0.36	-0.03	0.36	0.36	0.36	0.36	50,000	18,000	1	0.41	0.43	10,000,000	0.36	1.94	0.01
718369	SU元大	---	---	---	---	---	0.11	0	0	0	0.06	0.16	10,000,000	0.11	0.51	0.01
71836P	UP兆豐	---	---	---	---	---	0.03	0	0	0	0.00	0.03	5,000,000	0.02	0.94	0.01
718370	國泰TN	0.58	+0.01	0.54	0.59	0.53	0.56	140,000	78,900	12	0.58	0.60	5,000,000	0.58	1.02	0.12
718371	康和R8	---	---	---	---	---	0.15	0	0	0	0.03	0.10	10,000,000	0.10	0.84	0.01
718372	康和R9	---	---	---	---	---	1.56	0	0	0	1.28	1.32	5,000,000	1.28	2.17	0.39
718373	永豐PQ	---	---	---	---	---	0.36	0	0	0	0.39	0.41	5,075,000	0.39	0.70	0.08
718374	永豐PR	0.37	-0.01	0.36	0.37	0.22	0.31	1,065,000	330,360	32	0.37	0.38	12,000,000	0.37	0.99	0.01
718375	永豐PS	1.04	-0.22	1.04	1.04	1.04	1.04	40,000	41,600	1	1.05	1.07	11,000,000	1.04	1.87	0.21
718376	永豐PT	---	---	---	---	---	0.17	0	0	0	0.11	0.13	12,000,000	0.13	0.57	0.01
718377	永豐PU	0.41	+0.03	0.36	0.41	0.35	0.39	1,189,000	460,720	23	0.39	0.40	5,000,000	0.41	0.97	0.01
718378	WS元大	0.38	-0.08	0.35	0.38	0.35	0.37	78,000	28,750	7	0.37	0.38	10,000,000	0.38	1.01	0.01
718379	元大UY	0.46	+0.01	0.38	0.53	0.30	0.39	2,901,000	1,135,100	67	0.48	0.52	15,000,000	0.46	1.31	0.01
71837P	康和YQ	---	---	---	---	---	1.16	0	0	0	1.59	1.69	5,000,000	1.59	2.10	1.08
718380	國票RU	---	---	---	---	---	0.53	0	0	0	0.29	0.30	12,500,000	0.30	0.98	0.01
718381	W4富邦	0.38	-0.08	0.36	0.40	0.36	0.38	147,000	55,800	3	0.37	0.38	5,000,000	0.38	1.23	0.01
718382	日盛T9	0.79	-0.24	0.79	0.79	0.79	0.79	10,000	7,900	1	0.71	0.80	5,000,000	0.79	1.52	0.06
718383	日盛U1	---	---	---	---	---	0.08	0	0	0	0.04	0.05	5,000,000	0.05	0.50	0.01
718384	統一PQ	0.05	+0.02	0.04	0.05	0.04	0.05	380,000	18,500	11	0.05	0.07	17,000,000	0.05	0.43	0.01
718385	國泰TQ	1.48	+0.03	1.37	1.51	1.24	1.44	17,000	24,410	5	1.47	1.55	8,000,000	1.48	2.88	0.08
718386	永豐PV	0.44	+0.01	0.40	0.44	0.40	0.42	45,000	18,800	3	0.43	0.44	12,000,000	0.44	0.80	0.08
718387	永豐PW	0.74	+0.02	0.61	0.75	0.52	0.68	1,405,000	959,770	83	0.74	0.75	11,000,000	0.74	1.68	0.01
718388	永豐PX	0.76	+0.01	0.62	0.76	0.55	0.66	343,000	224,900	18	0.73	0.76	12,000,000	0.76	1.38	0.13
718389	UA群益	0.70	+0.02	0.64	0.70	0.62	0.68	109,000	74,490	7	0.69	0.70	5,000,000	0.70	1.45	0.01
71838P	康和YJ	0.44	+0.23	0.30	0.45	0.30	0.36	1,889,000	686,130	56	0.43	0.44	20,000,000	0.44	0.99	0.01
718390	UB群益	0.20	-0.06	0.20	0.20	0.20	0.20	364,000	72,800	6	0.24	0.25	5,000,000	0.20	1.28	0.01
718391	UC群益	0.96	+0.07	0.96	0.96	0.96	0.96	5,000	4,800	1	0.93	0.98	10,000,000	0.96	1.98	0.01
718392	元富VG	1.35	-0.67	1.14	1.35	1.11	1.24	51,000	63,370	6	1.38	1.42	10,000,000	1.35	2.27	0.43
718393	元富VH	---	---	---	---	---	0.20	0	0	0	0.10	0.13	10,000,000	0.13	0.83	0.01
718394	元富VJ	---	---	---	---	---	1.30	0	0	0	0.85	0.87	5,000,000	0.85	1.32	0.38
718395	元富VK	0.14	-0.07	0.14	0.14	0.14	0.14	100,000	14,000	1	0.05	0.18	5,000,000	0.14	0.79	0.01
718396	元富VL	0.25	-0.04	0.18	0.25	0.18	0.22	1,190,000	262,580	26	0.24	0.25	5,000,000	0.25	1.05	0.01
718397	元富VM	---	---	---	---	---	0.78	0	0	0	0.28	0.30	5,000,000	0.30	0.90	0.01
718398	元富VN	---	---	---	---	---	0.34	0	0	0	0.16	0.17	5,000,000	0.16	0.91	0.01
718399	元富VP	---	---	---	---	---	0.24	0	0	0	0.03	0.04	10,000,000	0.04	0.81	0.01
71839P	PP元大	0.19	-0.08	0.32	0.44	0.17	0.26	176,000	46,350	20	0.18	0.19	5,000,000	0.19	0.96	0.01
718400	元富VQ	---	---	---	---	---	0.10	0	0	0	0.09	0.10	5,000,000	0.10	0.49	0.01
718401	永豐PY	---	---	---	---	---	0.23	0	0	0	0.08	0.10	12,000,000	0.10	0.84	0.01
718402	永豐PZ	0.93	+0.06	0.70	1.03	0.70	0.91	109,000	99,200	12	0.93	0.96	12,000,000	0.93	1.98	0.01
718403	永豐QA	0.01	-0.01	0.01	0.02	0.01	0.01	560,000	6,600	19	0.01	0.02	11,000,000	0.01	0.37	0.01
718404	永豐QB	0.61	-0.07	0.61	0.61	0.61	0.61	10,000	6,100	1	0.59	0.60	5,000,000	0.61	0.92	0.30
718405	永豐QC	0.71	+0.05	0.53	0.71	0.53	0.65	112,000	73,120	8	0.62	0.64	5,000,000	0.71	1.02	0.40
718406	元大VC	---	---	---	---	---	0.10	0	0	0	0.04	0.14	5,000,000	0.10	0.78	0.01
718407	元大VK	---	---	---	---	---	0.44	0	0	0	0.10	0.11	10,000,000	0.11	0.56	0.01
718408	元大VM	0.36	0.00	0.36	0.36	0.36	0.36	10,000	3,600	1	0.36	0.37	5,000,000	0.36	1.05	0.01
718409	國票RW	---	---	---	---	---	0.45	0	0	0	0.18	0.23	11,000,000	0.23	0.89	0.01
71840P	PU元大	---	---	---	---	---	1.34	0	0	0	1.83	1.93	5,000,000	1.83	2.46	1.20
718410	國票RX	---	---	---	---	---	0.28	0	0	0	0.14	0.15	14,000,000	0.15	0.60	0.01
718411	YX凱基	0.26	+0.06	0.26	0.26	0.26	0.26	73,000	18,980	1	0.25	0.26	5,000,000	0.26	1.06	0.01
718412	W5富邦	---	---	---	---	---	0.47	0	0	0	0.24	0.25	5,000,000	0.25	1.63	0.01
718413	國泰TP	1.69	-0.10	1.38	1.77	1.33	1.53	330,000	504,700	32	1.66	1.75	10,000,000	1.69	3.15	0.23
718414	國泰TR	1.60	-0.27	1.60	1.60	1.60	1.60	26,000	41,600	2	1.71	1.72	8,000,000	1.60	2.88	0.32
718415	國泰TS	---	---	---	---	---	8.65	0	0	0	7.40	7.50	5,000,000	7.50	13.10	1.81
718416	統一PR	0.49	-0.01	0.54	0.54	0.48	0.51	30,000	15,350	3	0.48	0.49	5,000,000	0.49	0.95	0.03
718417	統一PS	0.53	+0.01	0.49	0.53	0.49	0.50	73,000	36,590	6	0.53	0.55	5,000,000	0.53	0.88	0.17
718418	統一PT	0.06	0.00	0.05	0.08	0.05	0.06	698,000	40,020	20	0.05	0.06	15,000,000	0.06	0.37	0.01
718419	日盛U2	---	---	---	---	---	0.17	0	0	0	0.13	0.14	5,000,000	0.14	0.60	0.01
71841P	QD元大	0.10	+0.04	0.08	0.10	0.08	0.09	20,000	1,800	2	0.04	0.05	5,000,000	0.10	1.02	0.01
718420	日盛U3	---	---	---	---	---	0.42	0	0	0	0.19	0.20	5,000,000	0.20	1.15	0.01
718421	日盛U4	0.13	0.00	0.13	0.13	0.13	0.13	20,000	2,600	1	0.12	0.13	5,000,000	0.13	0.53	0.01
718909	元富XX	---	---	---	---	---	1.02	0	0	0	0.04	0.00	5,000,000	0.43	1.36	0.01
718422	XK兆豐	1.61	+0.02	1.28	1.61	1.26	1.35	14,000	18,890	4	1.65	1.68	5,000,000	1.61	2.53	0.69
718423	日盛U5	1.18	-0.17	1.18	1.18	1.18	1.18	50,000	59,000	2	1.33	1.36	5,500,000	1.18	2.27	0.09
718424	日盛U6	0.61	-0.02	0.62	0.64	0.61	0.63	524,000	331,210	5	0.60	0.61	5,280,000	0.61	0.91	0.31
718425	元富VR	0.10	-0.11	0.10	0.10	0.10	0.10	20,000	2,000	1	0.12	0.13	10,000,000	0.10	0.55	0.01
718426	元富VS	---	---	---	---	---	0.21	0	0	0	0.23	0.24	10,000,000	0.23	1.03	0.01
718427	元富VT	1.24	+0.06	1.00	1.41	1.00	1.25	186,000	232,150	11	1.27	1.28	5,000,000	1.24	2.09	0.37
718428	國票RY	0.37	-0.11	0.21	0.38	0.21	0.34	977,000	334,200	10	0.36	0.37	5,000,000	0.37	0.84	0.01
718429	國票RZ	---	---	---	---	---	0.39	0	0	0	0.15	0.16	5,000,000	0.16	0.67	0.01
71842P	元富RC	0.43	-0.09	0.52	0.67	0.43	0.63	30,000	18,910	5	0.13	0.00	10,000,000	0.43	1.81	0.01
718430	YY凱基	---	---	---	---	---	0.14	0	0	0	0.04	0.06	5,000,000	0.06	0.51	0.01
718431	YZ凱基	0.50	-0.07	0.43	0.51	0.43	0.49	942,000	459,920	16	0.47	0.50	5,000,000	0.50	1.13	0.01
718432	ZA凱基	0.49	-0.08	0.44	0.49	0.44	0.48	450,000	214,000	3	0.47	0.49	5,000,000	0.49	1.12	0.01
718433	ZB凱基	1.51	+0.10	1.47	1.65	1.47	1.52	403,000	611,630	8	1.51	1.55	10,000,000	1.51	2.76	0.26
718434	ZC凱基	---	---	---	---	---	1.25	0	0	0	0.00	0.00	5,000,000	1.25	1.77	0.70
718435	元大VU	---	---	---	---	---	1.45	0	0	0	0.00	1.47	5,000,000	1.38	2.07	0.69
718436	國泰TT	---	---	---	---	---	0.24	0	0	0	0.17	0.19	5,000,000	0.19	1.08	0.01
718437	UE群益	0.38	-0.14	0.38	0.38	0.38	0.38	160,000	60,800	2	0.40	0.46	7,000,000	0.38	1.79	0.01
718438	UF群益	0.42	-0.03	0.42	0.42	0.42	0.42	29,000	12,180	1	0.41	0.42	5,000,000	0.42	0.79	0.05
718439	UG群益	---	---	---	---	---	0.73	0	0	0	0.20	0.21	5,000,000	0.21	1.03	0.01
71843P	康和YT	0.04	+0.02	0.04	0.04	0.04	0.04	20,000	800	1	0.02	0.05	20,000,000	0.04	0.88	0.01
718440	UH群益	---	---	---	---	---	0.53	0	0	0	0.03	0.17	10,000,000	0.17	2.15	0.01
718441	永豐QD	0.26	+0.02	0.20	0.26	0.19	0.22	301,000	64,740	5	0.25	0.26	5,000,000	0.26	0.98	0.01
718442	永豐QE	---	---	---	---	---	0.04	0	0	0	0.04	0.05	5,000,000	0.04	0.57	0.01
718443	永豐QF	---	---	---	---	---	0.16	0	0	0	0.06	0.07	5,000,000	0.07	0.68	0.01
718444	永豐QG	---	---	---	---	---	0.46	0	0	0	0.11	0.25	11,000,000	0.25	0.91	0.01
718445	永豐QH	0.60	-0.02	0.46	0.64	0.38	0.52	361,000	189,270	23	0.58	0.61	13,000,000	0.60	1.17	0.03
718446	永豐QI	0.67	+0.11	0.57	0.67	0.39	0.61	954,000	578,500	40	0.64	0.66	12,000,000	0.67	1.51	0.01
718447	康和S2	0.90	+0.05	0.89	0.94	0.89	0.91	186,000	168,520	3	0.92	0.00	20,000,000	0.90	1.72	0.08
718448	XL兆豐	1.00	+0.25	0.50	1.00	0.50	0.65	343,000	221,490	39	1.00	1.10	5,000,000	1.00	2.14	0.01
718449	XM兆豐	2.48	-0.09	2.00	2.48	2.00	2.44	11,000	26,800	2	2.61	2.64	5,000,000	2.48	3.84	1.12
71844P	國票QK	0.42	+0.19	0.47	0.47	0.42	0.44	151,000	66,770	6	0.41	0.42	5,000,000	0.42	0.91	0.01
718450	日盛U7	1.04	-0.06	0.86	1.05	0.81	0.95	662,000	627,580	33	1.04	1.08	5,000,000	1.04	1.93	0.13
718451	日盛U8	0.36	-0.04	0.28	0.36	0.28	0.33	900,000	295,500	6	0.46	0.47	5,000,000	0.36	1.05	0.01
718452	UQ第一	0.57	+0.02	0.57	0.57	0.57	0.57	28,000	15,960	1	0.61	0.62	5,000,000	0.57	1.09	0.02
718453	UR第一	---	---	---	---	---	0.37	0	0	0	0.25	0.26	20,000,000	0.26	1.01	0.01
718454	PS元大	---	---	---	---	---	0.34	0	0	0	0.08	0.14	10,000,000	0.14	0.80	0.01
718455	QC元大	0.20	-0.03	0.18	0.20	0.18	0.19	500,000	94,000	4	0.20	0.21	10,000,000	0.20	0.98	0.01