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

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

可用欄位參考

代號	名稱	收盤	漲跌	開盤	最高	最低	均價	成交股數	成交金額(元)	成交筆數	最後買價	最後賣價	發行股數	次日參考價	次日漲停價	次日跌停價
717548	TT第一	---	---	---	---	---	0.15	0	0	0	0.06	0.10	5,000,000	0.10	0.78	0.01
717549	國泰RT	0.10	-0.05	0.10	0.10	0.10	0.10	20,000	2,000	1	0.16	0.26	5,000,000	0.10	0.64	0.01
71754P	康和XH	---	---	---	---	---	0.15	0	0	0	0.04	0.10	5,000,000	0.10	0.56	0.01
717550	SW元大	---	---	---	---	---	0.13	0	0	0	0.04	0.10	5,000,000	0.10	0.94	0.01
717551	SZ元大	0.25	-0.20	0.25	0.25	0.25	0.25	8,000	2,000	1	0.01	0.00	5,000,000	0.25	1.19	0.01
717552	QC群益	0.53	-0.13	0.39	0.54	0.39	0.49	640,000	314,610	55	0.53	0.54	10,000,000	0.53	1.53	0.01
717553	統一W5	0.32	-0.08	0.29	0.34	0.29	0.32	109,000	34,400	13	0.32	0.34	15,000,000	0.32	0.87	0.01
717554	統一W6	0.21	+0.01	0.14	0.21	0.14	0.17	212,000	36,780	15	0.21	0.22	15,000,000	0.21	0.76	0.01
717555	UT凱基	---	---	---	---	---	0.07	0	0	0	0.06	0.07	10,000,000	0.07	0.84	0.01
717556	UU凱基	0.07	-0.09	0.07	0.07	0.07	0.07	10,000	700	1	0.07	0.08	5,000,000	0.07	0.55	0.01
717557	UV凱基	---	---	---	---	---	0.84	0	0	0	0.42	0.52	5,000,000	0.47	1.64	0.01
717558	UW凱基	2.26	-0.22	1.59	2.26	1.59	1.76	4,000	7,030	2	2.05	2.14	5,000,000	2.26	3.23	1.29
717559	VP兆豐	---	---	---	---	---	0.20	0	0	0	0.14	0.15	5,000,000	0.15	0.97	0.01
71755P	PF國泰	0.21	-0.15	0.20	0.21	0.20	0.20	20,000	4,100	2	0.20	0.23	5,000,000	0.21	0.90	0.01
717560	YF永豐	0.94	+0.03	0.69	1.07	0.69	0.85	350,000	296,410	14	0.92	0.94	5,000,000	0.94	1.85	0.02
717561	YG永豐	---	---	---	---	---	0.04	0	0	0	0.01	0.06	5,000,000	0.04	0.93	0.01
717562	YH永豐	---	---	---	---	---	0.13	0	0	0	0.07	0.08	5,000,000	0.08	0.42	0.01
717563	元富RU	2.81	-0.30	2.05	2.81	2.02	2.19	91,000	199,600	7	2.84	2.91	5,000,000	2.81	4.00	1.62
717564	元富RV	1.28	+0.01	0.93	1.33	0.93	1.16	218,000	252,140	21	1.23	1.24	5,000,000	1.28	2.86	0.01
717565	元富RW	0.88	-0.37	0.82	0.88	0.73	0.78	50,000	38,900	3	0.86	0.89	5,000,000	0.88	2.74	0.01
717566	元富RX	0.65	-0.13	0.61	0.65	0.48	0.60	195,000	117,010	22	0.64	0.65	5,000,000	0.65	1.65	0.01
717567	日盛WT	---	---	---	---	---	0.10	0	0	0	0.01	0.02	5,000,000	0.02	1.67	0.01
717568	日盛WU	2.52	+0.06	1.80	2.52	1.80	2.16	11,000	23,780	3	2.53	2.59	5,000,000	2.52	3.46	1.58
717569	日盛WV	0.36	-0.21	0.36	0.36	0.36	0.36	99,000	35,640	1	0.35	0.36	10,000,000	0.36	1.32	0.01
71756P	富邦VJ	---	---	---	---	---	0.10	0	0	0	0.00	0.02	5,000,000	0.02	1.07	0.01
717570	TB元大	1.49	-0.09	1.09	1.50	1.09	1.34	75,000	100,600	5	1.54	1.55	5,000,000	1.49	2.32	0.66
717571	TE元大	---	---	---	---	---	0.32	0	0	0	0.22	0.23	5,000,000	0.23	0.67	0.01
717572	TG元大	0.25	-0.05	0.25	0.25	0.25	0.25	10,000	2,500	1	0.26	0.28	5,000,000	0.25	1.35	0.01
717573	TH元大	---	---	---	---	---	0.09	0	0	0	0.02	0.11	5,000,000	0.09	0.64	0.01
717574	TL元大	0.66	+0.02	0.50	0.66	0.47	0.53	501,000	264,440	10	0.61	0.70	5,000,000	0.66	1.26	0.05
717575	元富RZ	---	---	---	---	---	0.02	0	0	0	0.01	0.04	5,000,000	0.04	0.67	0.01
717576	元富SA	0.11	+0.05	0.12	0.12	0.11	0.12	100,000	11,600	10	0.09	0.10	5,000,000	0.11	1.11	0.01
717577	元富SB	0.08	-0.02	0.07	0.08	0.07	0.08	35,000	2,700	3	0.08	0.09	13,000,000	0.08	0.90	0.01
717578	元富SC	---	---	---	---	---	1.63	0	0	0	1.59	1.65	5,000,000	1.63	3.35	0.01
717579	康和ZJ	---	---	---	---	---	0.20	0	0	0	0.20	0.30	20,000,000	0.20	0.93	0.01
71757P	PZ凱基	---	---	---	---	---	0.14	0	0	0	0.08	0.18	5,000,000	0.14	1.29	0.01
717580	YI永豐	0.21	+0.02	0.14	0.29	0.12	0.23	920,000	208,800	83	0.22	0.23	5,503,000	0.21	1.49	0.01
717581	YJ永豐	0.03	-0.04	0.04	0.04	0.03	0.03	211,000	6,880	3	0.06	0.07	5,000,000	0.03	0.78	0.01
717582	YK永豐	0.60	-0.02	0.43	0.65	0.41	0.55	230,000	127,120	27	0.59	0.60	12,000,000	0.60	2.10	0.01
717583	YL永豐	---	---	---	---	---	0.12	0	0	0	0.09	0.10	12,000,000	0.10	0.51	0.01
717584	YM永豐	---	---	---	---	---	0.01	0	0	0	0.00	0.01	5,276,000	0.01	0.74	0.01
717585	YN永豐	0.26	-0.01	0.26	0.26	0.26	0.26	20,000	5,200	1	0.25	0.27	12,000,000	0.26	0.86	0.01
717586	YP永豐	---	---	---	---	---	0.14	0	0	0	0.05	0.06	12,000,000	0.06	0.41	0.01
717587	TU第一	---	---	---	---	---	0.12	0	0	0	0.03	0.10	10,000,000	0.10	1.10	0.01
717588	TV第一	---	---	---	---	---	1.44	0	0	0	0.38	0.43	20,000,000	0.43	0.92	0.01
717589	QD群益	---	---	---	---	---	0.21	0	0	0	0.19	0.20	5,000,000	0.20	0.92	0.01
71758P	康和XJ	---	---	---	---	---	0.03	0	0	0	0.00	0.01	5,000,000	0.01	1.37	0.01
717590	QE群益	0.34	+0.05	0.34	0.34	0.34	0.34	10,000	3,400	1	0.32	0.35	5,000,000	0.34	1.23	0.01
717591	Q6富邦	---	---	---	---	---	0.32	0	0	0	0.22	0.23	5,000,000	0.22	0.67	0.01
717592	Q7富邦	0.17	+0.02	0.09	0.18	0.09	0.16	331,000	51,980	5	0.15	0.16	5,000,000	0.17	0.60	0.01
717593	Q8富邦	0.25	-0.03	0.25	0.25	0.25	0.25	4,000	1,000	1	0.15	0.23	10,000,000	0.25	0.56	0.01
717594	Q9富邦	---	---	---	---	---	0.32	0	0	0	0.16	0.17	10,000,000	0.17	0.99	0.01
717595	R1富邦	0.20	-0.02	0.20	0.20	0.20	0.20	20,000	4,000	1	0.21	0.22	10,000,000	0.20	0.48	0.01
717596	統一W7	---	---	---	---	---	0.14	0	0	0	0.10	0.12	5,000,000	0.12	0.52	0.01
717597	UX凱基	---	---	---	---	---	2.36	0	0	0	0.00	0.00	5,000,000	1.77	2.64	0.90
717598	UY凱基	0.09	-0.01	0.05	0.09	0.05	0.07	151,000	9,990	3	0.10	0.11	5,000,000	0.09	0.89	0.01
717599	UZ凱基	---	---	---	---	---	0.04	0	0	0	0.02	0.03	5,000,000	0.03	0.43	0.01
71759P	元大SW	---	---	---	---	---	0.01	0	0	0	0.00	0.03	5,000,000	0.01	1.53	0.01
717600	VA凱基	---	---	---	---	---	0.17	0	0	0	0.09	0.10	5,000,000	0.09	0.63	0.01
717601	日盛WW	---	---	---	---	---	0.33	0	0	0	0.18	0.19	5,000,000	0.18	0.58	0.01
717602	UE元大	0.80	+0.02	0.49	0.87	0.49	0.62	941,000	587,810	26	0.77	0.81	10,000,000	0.80	1.58	0.02
717603	UF元大	---	---	---	---	---	0.01	0	0	0	0.01	0.02	5,000,000	0.01	0.49	0.01
717604	UQ元大	---	---	---	---	---	0.02	0	0	0	0.00	0.04	5,000,000	0.02	0.35	0.01
717605	UV元大	0.81	-0.33	0.66	0.81	0.66	0.80	53,000	42,480	2	0.98	1.06	5,000,000	0.81	1.39	0.23
717606	UX元大	0.85	0.00	0.73	0.85	0.72	0.79	393,000	309,550	13	0.82	0.86	5,000,000	0.85	2.17	0.01
717607	UY元大	---	---	---	---	---	0.76	0	0	0	0.27	0.28	5,000,000	0.28	0.98	0.01
717608	WC元大	0.20	-0.03	0.14	0.23	0.14	0.17	667,000	115,300	10	0.20	0.21	5,000,000	0.20	0.88	0.01
717609	WH元大	---	---	---	---	---	0.02	0	0	0	0.00	0.02	5,000,000	0.02	0.65	0.01
71760P	QU永豐	1.19	-0.06	1.23	1.31	1.19	1.25	88,000	110,380	7	1.19	1.20	5,000,000	1.19	1.57	0.81
717610	WJ元大	---	---	---	---	---	0.01	0	0	0	0.01	0.11	5,000,000	0.01	0.82	0.01
717611	元富SD	---	---	---	---	---	2.08	0	0	0	0.96	1.00	5,000,000	1.00	1.73	0.27
717612	元富SE	0.80	-0.51	0.80	0.80	0.80	0.80	70,000	56,000	7	0.22	0.77	5,000,000	0.80	1.79	0.01
717613	VQ兆豐	---	---	---	---	---	1.84	0	0	0	1.65	1.74	5,000,000	1.74	3.06	0.42
717614	VR兆豐	---	---	---	---	---	0.24	0	0	0	0.19	0.20	5,000,000	0.20	1.19	0.01
717615	VS兆豐	---	---	---	---	---	0.10	0	0	0	0.01	0.02	5,000,000	0.02	0.61	0.01
717616	VT兆豐	1.29	+0.19	0.98	1.29	0.98	1.19	46,000	54,670	7	1.29	1.33	5,000,000	1.29	1.98	0.60
717617	VU兆豐	0.05	0.00	0.04	0.05	0.04	0.05	80,000	3,700	4	0.04	0.05	5,000,000	0.05	0.65	0.01
717618	康和ZK	---	---	---	---	---	1.41	0	0	0	0.00	0.00	5,000,000	3.28	4.13	2.43
717619	康和ZL	---	---	---	---	---	0.06	0	0	0	0.05	0.10	10,000,000	0.08	0.50	0.01
71761P	PN國泰	---	---	---	---	---	0.20	0	0	0	0.09	0.10	7,000,000	0.10	0.88	0.01
717620	YQ永豐	---	---	---	---	---	0.08	0	0	0	0.02	0.03	11,000,000	0.03	0.61	0.01
717621	YR永豐	---	---	---	---	---	0.21	0	0	0	0.17	0.18	5,000,000	0.18	0.62	0.01
717622	R2富邦	0.40	-0.02	0.40	0.40	0.40	0.40	10,000	4,000	1	0.39	0.40	10,000,000	0.40	1.08	0.01
717623	TW第一	---	---	---	---	---	0.34	0	0	0	0.12	0.13	10,000,000	0.13	1.57	0.01
717624	TX第一	---	---	---	---	---	0.84	0	0	0	0.63	0.65	5,000,000	0.63	1.59	0.01
717625	國泰RW	---	---	---	---	---	0.29	0	0	0	0.00	0.00	5,000,000	0.27	0.71	0.01
717626	QH群益	1.25	0.00	0.57	1.32	0.53	0.98	507,000	498,270	19	1.22	1.27	10,000,000	1.25	6.10	0.01
717627	QJ群益	0.17	+0.02	0.17	0.17	0.17	0.17	10,000	1,700	1	0.17	0.18	5,000,000	0.17	0.89	0.01
717628	QK群益	---	---	---	---	---	0.03	0	0	0	0.00	0.00	10,000,000	0.02	0.51	0.01
717629	統一W8	---	---	---	---	---	0.32	0	0	0	0.23	0.25	5,000,000	0.24	0.57	0.01
71762P	PP國泰	0.10	+0.09	0.10	0.10	0.10	0.10	1,000	100	1	0.00	0.01	5,000,000	0.10	2.05	0.01
717630	統一W9	0.17	0.00	0.14	0.18	0.14	0.17	387,000	64,390	19	0.18	0.19	5,000,000	0.17	0.65	0.01
717631	統一X1	1.02	-0.12	1.09	1.09	1.02	1.06	10,000	10,550	2	1.01	1.11	15,000,000	1.02	1.62	0.42
717632	VC凱基	1.49	-0.26	1.49	1.49	1.49	1.49	30,000	44,700	3	1.69	1.78	5,000,000	1.49	2.46	0.52
717633	VD凱基	0.08	-0.03	0.11	0.11	0.08	0.09	350,000	31,000	4	0.12	0.14	5,000,000	0.08	1.08	0.01
717634	日盛WX	0.03	-0.22	0.03	0.03	0.03	0.03	50,000	1,500	1	0.09	0.18	5,000,000	0.03	1.35	0.01
717635	日盛WY	0.88	-0.36	0.88	0.88	0.88	0.88	50,000	44,000	1	1.37	1.41	15,000,000	0.88	1.85	0.01
717636	日盛WZ	1.05	-0.47	0.97	1.14	0.97	1.05	561,000	590,460	10	1.04	1.13	5,000,000	1.05	1.78	0.32
717637	P1元大	---	---	---	---	---	0.49	0	0	0	0.46	0.47	10,000,000	0.47	1.32	0.01
717638	WK元大	---	---	---	---	---	0.07	0	0	0	0.00	0.02	5,000,000	0.02	1.18	0.01