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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
718456	RQ元大	0.36	-0.02	0.35	0.37	0.28	0.33	640,000	214,040	20	0.36	0.37	5,000,000	0.36	1.07	0.01
718457	國票SA	0.60	-0.02	0.45	0.61	0.43	0.55	395,000	216,740	27	0.59	0.60	11,000,000	0.60	1.92	0.01
718458	ZD凱基	---	---	---	---	---	0.46	0	0	0	0.40	0.42	5,000,000	0.42	1.41	0.01
718459	元富VW	1.47	+0.23	1.04	1.47	1.04	1.34	359,000	481,330	7	1.35	1.39	5,000,000	1.47	2.47	0.47
71845P	國票QL	---	---	---	---	---	1.39	0	0	0	1.84	1.85	5,000,000	1.84	2.35	1.33
718460	國泰TU	1.24	+0.01	0.78	1.24	0.78	1.08	893,000	966,850	24	1.19	1.24	10,000,000	1.24	2.50	0.01
718461	國泰TV	0.21	-0.16	0.22	0.22	0.20	0.21	230,000	47,500	8	0.18	0.21	5,000,000	0.21	0.87	0.01
718462	國泰TW	0.53	+0.03	0.47	0.57	0.46	0.53	1,955,000	1,043,600	26	0.53	0.61	5,000,000	0.53	0.84	0.22
718463	國泰TX	0.68	-0.04	0.49	0.71	0.48	0.64	255,000	162,860	8	0.60	0.89	5,100,000	0.68	1.70	0.01
718464	國泰TY	---	---	---	---	---	0.22	0	0	0	0.14	0.16	5,000,000	0.16	1.05	0.01
718465	UJ群益	---	---	---	---	---	0.20	0	0	0	0.08	0.09	5,000,000	0.09	0.49	0.01
718466	UL群益	1.25	-0.02	0.92	1.25	0.92	1.06	454,000	483,130	7	1.21	1.28	10,000,000	1.25	2.42	0.08
718467	UK群益	---	---	---	---	---	0.52	0	0	0	0.37	0.38	5,000,000	0.38	1.40	0.01
718468	康和S3	---	---	---	---	---	1.19	0	0	0	0.77	0.85	5,000,000	0.83	1.64	0.02
718469	永豐QJ	0.34	-0.05	0.25	0.38	0.25	0.32	71,000	22,380	8	0.35	0.36	5,000,000	0.34	0.94	0.01
71846P	日盛VZ	0.21	+0.03	0.26	0.26	0.20	0.23	740,000	172,200	5	0.19	0.20	5,000,000	0.21	0.72	0.01
718470	永豐QK	0.33	+0.08	0.33	0.33	0.33	0.33	2,000	660	1	0.25	0.32	20,000,000	0.33	0.67	0.01
718471	永豐QL	---	---	---	---	---	0.70	0	0	0	0.45	0.46	5,000,000	0.45	1.00	0.01
718472	永豐QM	---	---	---	---	---	0.03	0	0	0	0.03	0.04	5,000,000	0.03	0.65	0.01
718473	永豐QN	0.33	-0.24	0.32	0.33	0.32	0.32	103,000	32,980	4	0.32	0.33	5,000,000	0.33	1.01	0.01
718474	永豐QP	---	---	---	---	---	0.27	0	0	0	0.13	0.14	11,000,000	0.14	0.97	0.01
718475	US第一	0.43	-0.21	0.43	0.43	0.43	0.43	99,000	42,570	1	0.41	0.42	5,000,000	0.43	1.29	0.01
718476	XP兆豐	---	---	---	---	---	0.21	0	0	0	0.12	0.13	5,000,000	0.13	0.72	0.01
718477	XQ兆豐	0.37	-0.03	0.32	0.37	0.32	0.35	50,000	17,300	4	0.33	0.34	5,000,000	0.37	0.88	0.01
718478	元富VX	---	---	---	---	---	0.28	0	0	0	0.05	0.06	5,000,000	0.06	0.44	0.01
718479	元富VY	2.12	-0.12	1.60	2.12	1.60	1.71	23,000	39,400	3	2.68	2.76	5,000,000	2.12	3.12	1.12
71847P	PQ群益	2.05	-0.20	2.46	2.52	2.05	2.33	93,000	216,800	7	2.00	2.06	10,000,000	2.05	3.04	1.06
718480	RR元大	1.12	+0.17	0.69	1.12	0.69	0.83	526,000	435,900	16	1.01	1.05	15,000,000	1.12	1.90	0.34
718481	RW元大	0.43	-0.10	0.26	0.45	0.26	0.42	975,000	413,570	13	0.43	0.44	5,000,000	0.43	0.91	0.01
718482	SA元大	0.24	-0.23	0.25	0.25	0.24	0.24	150,000	36,300	14	0.23	0.00	16,000,000	0.24	0.73	0.01
718483	SB元大	---	---	---	---	---	0.30	0	0	0	0.16	0.17	5,000,000	0.17	0.61	0.01
718484	國票SC	---	---	---	---	---	0.25	0	0	0	0.23	0.24	5,000,000	0.24	0.85	0.01
718485	日盛U9	---	---	---	---	---	0.13	0	0	0	0.10	0.11	5,000,000	0.11	0.71	0.01
718486	日盛V1	---	---	---	---	---	1.27	0	0	0	0.90	0.93	5,000,000	0.93	1.77	0.09
718487	統一PU	1.11	+0.09	0.93	1.11	0.91	1.01	703,000	708,510	12	1.07	1.11	5,000,000	1.11	1.86	0.36
718488	統一PV	0.57	-0.13	0.40	0.61	0.28	0.48	984,000	469,130	26	0.55	0.57	5,000,000	0.57	1.04	0.10
718489	統一PW	---	---	---	---	---	0.14	0	0	0	0.08	0.09	5,000,000	0.08	0.38	0.01
71848P	PR群益	0.32	+0.07	0.39	0.40	0.29	0.33	1,063,000	350,300	35	0.31	0.32	5,000,000	0.32	0.99	0.01
718490	統一PX	0.33	-0.07	0.31	0.33	0.31	0.32	109,000	34,470	4	0.33	0.43	14,000,000	0.33	0.89	0.01
718491	國泰UA	---	---	---	---	---	0.22	0	0	0	0.16	0.24	10,000,000	0.17	0.97	0.01
718492	UM群益	---	---	---	---	---	0.34	0	0	0	0.25	0.26	10,000,000	0.25	1.05	0.01
718493	UN群益	---	---	---	---	---	0.08	0	0	0	0.04	0.05	5,000,000	0.05	0.91	0.01
718494	UP群益	1.64	+0.09	1.30	1.64	1.30	1.46	50,000	73,110	5	1.68	1.71	5,000,000	1.64	3.02	0.26
718495	UQ群益	---	---	---	---	---	0.10	0	0	0	0.07	0.08	10,000,000	0.08	0.58	0.01
718496	永豐QQ	0.03	-0.02	0.03	0.03	0.03	0.03	106,000	3,180	7	0.02	0.03	11,000,000	0.03	0.61	0.01
718497	永豐QR	0.19	-0.05	0.15	0.19	0.15	0.17	120,000	20,000	2	0.19	0.20	10,000,000	0.19	1.41	0.01
718498	永豐QS	---	---	---	---	---	2.13	0	0	0	1.90	1.92	5,000,000	1.92	3.47	0.37
718499	永豐QT	1.20	+0.10	0.84	1.20	0.71	1.07	339,000	364,270	40	1.12	1.16	8,500,000	1.20	2.62	0.01
71849P	VH兆豐	0.22	+0.07	0.22	0.22	0.22	0.22	2,000	440	1	0.20	0.21	5,000,000	0.22	0.61	0.01
718500	永豐QU	0.59	-0.19	0.40	0.68	0.40	0.60	372,000	224,150	22	0.60	0.62	5,000,000	0.59	1.50	0.01
718501	永豐QV	---	---	---	---	---	0.22	0	0	0	0.14	0.15	5,000,000	0.14	0.39	0.01
718502	XR兆豐	---	---	---	---	---	0.41	0	0	0	0.47	0.51	5,000,000	0.47	3.12	0.01
718503	XS兆豐	---	---	---	---	---	0.70	0	0	0	0.16	0.20	5,000,000	0.20	0.95	0.01
718504	XT兆豐	---	---	---	---	---	0.67	0	0	0	0.21	0.28	5,000,000	0.28	1.10	0.01
718505	元富WA	0.13	-0.01	0.13	0.13	0.13	0.13	80,000	10,400	1	0.14	0.15	5,000,000	0.13	0.49	0.01
718506	日盛V2	---	---	---	---	---	0.14	0	0	0	0.13	0.14	5,000,000	0.14	0.51	0.01
718507	統一PY	0.53	+0.05	0.43	0.53	0.43	0.47	140,000	65,960	9	0.52	0.53	5,000,000	0.53	1.02	0.04
718508	統一PZ	0.17	-0.03	0.13	0.17	0.13	0.15	1,030,000	154,750	14	0.17	0.18	5,000,000	0.17	0.65	0.01
718509	SG元大	1.18	-0.35	0.51	1.50	0.51	1.05	302,000	315,970	30	1.16	1.17	12,000,000	1.18	2.33	0.03
71850P	QV元大	0.10	0.00	0.13	0.13	0.09	0.10	670,000	66,700	5	0.07	0.11	5,000,000	0.10	1.17	0.01
718510	SK元大	---	---	---	---	---	0.15	0	0	0	0.00	0.00	5,000,000	0.15	0.62	0.01
718511	SL元大	2.24	+0.01	1.42	2.24	1.42	2.14	254,000	542,610	11	2.24	0.00	5,000,000	2.24	3.94	0.54
718512	SP元大	1.08	+0.09	0.81	1.10	0.81	0.96	677,000	647,470	14	1.08	1.10	5,000,000	1.08	2.33	0.01
718513	SQ元大	0.12	0.00	0.07	0.12	0.07	0.08	61,000	4,920	5	0.11	0.12	10,000,000	0.12	1.32	0.01
718514	永豐QW	0.21	0.00	0.18	0.21	0.18	0.20	20,000	3,900	2	0.20	0.21	5,000,000	0.21	0.89	0.01
718515	國泰UB	0.60	-0.24	0.52	0.60	0.52	0.57	133,000	75,660	6	0.59	0.60	5,000,000	0.60	1.10	0.10
718516	國泰UC	---	---	---	---	---	0.10	0	0	0	0.04	0.08	5,000,000	0.08	0.48	0.01
718517	國泰UD	0.50	+0.04	0.43	0.53	0.42	0.49	708,000	344,460	11	0.48	0.50	5,000,000	0.50	0.75	0.25
718518	US群益	0.60	0.00	0.48	0.60	0.32	0.46	371,000	169,140	44	0.57	0.60	5,000,000	0.60	2.36	0.01
718519	UT群益	0.37	-0.07	0.37	0.37	0.37	0.37	10,000	3,700	1	0.34	0.35	6,150,000	0.37	1.11	0.01
71851P	國泰RL	0.85	+0.17	0.95	0.95	0.85	0.91	219,000	199,150	6	0.83	0.92	5,000,000	0.85	1.83	0.01
718520	UU群益	0.75	-0.05	0.53	0.75	0.53	0.55	51,000	27,950	4	0.76	0.77	6,000,000	0.75	2.94	0.01
718521	UV群益	0.83	-0.03	0.62	0.86	0.62	0.77	917,000	703,310	32	0.82	0.83	10,000,000	0.83	2.15	0.01
718522	康和S5	0.22	-0.02	0.19	0.22	0.19	0.21	250,000	53,500	3	0.21	0.22	5,000,000	0.22	0.35	0.09
718523	康和S6	---	---	---	---	---	0.31	0	0	0	0.20	0.21	5,000,000	0.21	0.75	0.01
718524	XU兆豐	0.26	-0.03	0.22	0.26	0.22	0.24	20,000	4,800	2	0.35	0.36	5,000,000	0.26	0.77	0.01
718525	元富WB	2.96	+0.94	2.18	2.97	2.18	2.49	310,000	772,570	29	2.97	0.00	5,000,000	2.96	4.00	1.91
718526	日盛V3	0.32	-0.04	0.25	0.32	0.25	0.30	155,000	46,400	4	0.35	0.37	5,000,000	0.32	0.89	0.01
718527	日盛V4	0.72	+0.02	0.67	0.72	0.67	0.70	93,000	65,510	5	0.72	0.00	5,000,000	0.72	1.24	0.17
718528	日盛V5	---	---	---	---	---	0.15	0	0	0	0.13	0.14	5,000,000	0.14	0.84	0.01
718529	日盛V6	0.76	-0.01	0.70	0.77	0.70	0.75	218,000	163,440	8	0.73	0.74	5,175,000	0.76	1.22	0.30
71852P	康和YZ	0.52	-0.06	0.65	0.65	0.52	0.57	5,000	2,850	5	0.46	0.49	5,000,000	0.52	1.03	0.01
718530	統一QA	---	---	---	---	---	0.33	0	0	0	0.05	0.09	18,000,000	0.09	0.58	0.01
718531	ZE凱基	0.28	0.00	0.24	0.28	0.24	0.27	170,000	46,000	3	0.28	0.29	5,000,000	0.28	0.96	0.01
718532	ZF凱基	0.04	+0.01	0.04	0.04	0.04	0.04	81,000	3,240	1	0.03	0.04	5,000,000	0.04	0.76	0.01
718533	ZG凱基	4.14	+1.44	3.40	4.14	3.40	3.88	31,000	120,140	6	4.14	0.00	5,000,000	4.14	5.70	2.57
718534	ST元大	3.29	-0.41	2.87	3.29	2.87	3.06	49,000	150,010	5	3.89	3.99	5,000,000	3.29	4.49	2.07
718535	SV元大	1.19	+0.12	0.92	1.19	0.48	0.97	426,000	413,060	17	1.16	1.18	5,000,000	1.19	2.19	0.19
718536	SY元大	0.68	-0.06	0.59	0.71	0.36	0.66	447,000	296,460	20	0.54	0.00	5,000,000	0.68	1.26	0.10
718537	永豐QX	---	---	---	---	---	0.25	0	0	0	0.17	0.18	5,000,000	0.17	0.69	0.01
718538	永豐QY	0.33	0.00	0.32	0.33	0.32	0.33	120,000	39,400	2	0.36	0.37	5,000,000	0.33	0.68	0.01
718539	永豐QZ	---	---	---	---	---	2.67	0	0	0	1.93	2.00	5,000,000	1.98	2.94	1.02
71853P	XH永豐	0.51	+0.17	0.51	0.51	0.51	0.51	100,000	51,000	2	0.36	0.39	6,452,000	0.51	1.31	0.01
718540	永豐RA	---	---	---	---	---	1.09	0	0	0	0.46	0.47	12,000,000	0.47	1.24	0.01
718541	永豐RB	0.16	-0.03	0.16	0.16	0.16	0.16	10,000	1,600	1	0.19	0.20	11,000,000	0.16	1.30	0.01
718542	康和S7	---	---	---	---	---	2.75	0	0	0	0.00	0.00	5,000,000	3.31	4.02	2.60
718543	國泰UF	---	---	---	---	---	0.04	0	0	0	0.02	0.06	5,000,000	0.03	0.20	0.01
718544	國泰UG	---	---	---	---	---	0.21	0	0	0	0.19	0.22	5,000,000	0.19	0.54	0.01
718545	VA群益	0.83	-0.03	0.68	0.86	0.60	0.73	442,000	320,500	19	0.80	0.81	5,026,000	0.83	1.86	0.01
718546	VB群益	0.07	0.00	0.05	0.07	0.05	0.06	60,000	3,900	4	0.07	0.08	5,000,000	0.07	1.07	0.01