2020-05-23|閱讀時間 ‧ 約 5 分鐘

做分析測試資料

提供2018/01/01~2019/01/25 上市、上櫃、ETF 資料
https://drive.google.com/open?id=1Jk54UflLtjL2MlS4EYvz9PQV7xgL1p79
爬多個地方把不同資料來源都整合一起,方便大家分析,另外還有劵商分點買賣,由於資料太大就先不提供了,未來會繼續爬最新的資料
{ "市場別": "上市", "產業別": "光電業", "name": "佰鴻", "code": "3031", "date": "2018/09/03", "成交股數": 342, "成交金額": 4469, "開盤價": 13.4, "最高價": 13.4, "最低價": 12.85, "收盤價": 12.9, "成交筆數": 145, "三大法人買賣超": -27, "外資自營商買賣超": 0, "外資自營商買進": 0, "外資自營商賣出": 0, "外陸資買賣超": -30, "外陸資買進": 5, "外陸資賣出": 35, "投信買賣超": 0, "投信買進": 0, "投信賣出": 0, "自營商買賣超": 3, "自營商買賣超避險": 0, "自營商買進": 3, "自營商買進避險": 0, "自營商賣出": 0, "自營商賣出避險": 0, "融券今日餘額": 101, "融券前日餘額": 96, "融券現金償還": 0, "融券買進": 0, "融券賣出": 5, "融券限額": 46668, "融資今日餘額": 6032, "融資前日餘額": 6207, "融資現金償還": 1, "融資買進": 32, "融資賣出": 206, "融資限額": 46668, "資券互抵": 0, "資券註記": "", "借券今日可限額": 94.374, "借券備註": "", "借券前日餘額": 2420.12, "借券當日調整": 0, "借券當日賣出": 0, "借券當日還券": 0, "借券當日餘額": 2420.12, "漲跌價差": -0.45, "暫停現股賣出後現款買進當沖註記": "", "當日沖銷股數": 8, "當日沖銷買進金額'": 105250, "當日沖銷賣出金額": 103250 }

用notepad++開起來如下

_id,code,date,name,市場別,成交筆數,成交股數,成交金額,收盤價,最低價,最高價,漲跌價差,產業別,開盤價,三大法人買賣超,外資自營商買賣超,外資自營商買進,外資自營商賣出,外陸資買賣超,外陸資買進,外陸資賣出,投信買賣超,投信買進,投信賣出,自營商買賣超,自營商買賣超避險,自營商買進,自營商買進避險,自營商賣出,自營商賣出避險,暫停現股賣出後現款買進當沖註記,當日沖銷股數,"當日沖銷買進金額'",當日沖銷賣出金額,融券今日餘額,融券前日餘額,融券現金償還,融券買進,融券賣出,融券限額,融資今日餘額,融資前日餘額,融資現金償還,融資買進,融資賣出,融資限額,資券互抵,資券註記,借券今日可限額,借券備註,借券前日餘額,借券當日調整,借券當日賣出,借券當日還券,借券當日餘額
2019/01/25_0050,0050,2019/01/25,元大台灣50,上市,3322,7320,548115,75,74.55,75.1,0.95,false,74.6,5154,0,0,0,882,884,2,-5,0,5,1434,2843,1557,2895,123,52,false,163,12200550,12212750,180,161,0,26,45,241125,2442,2823,0,32,413,241125,1,false,2695.487,false,1514,0,0,278,1236
2019/01/25_0051,0051,2019/01/25,元大中型100,上市,13,26,758,29.16,29.09,29.2,0.23,false,29.09,24,0,0,0,0,0,0,0,0,0,0,24,0,24,0,0,false,0,0,0,0,0,0,0,0,2500,2,2,0,0,0,2500,0,false,7.27,false,0,0,0,0,0
2019/01/25_0052,0052,2019/01/25,富邦科技,上市,14,106,5301,49.95,49.78,49.96,2.6,false,49.78,9,0,0,0,0,0,0,0,0,0,0,9,0,103,0,94,false,7,349540,349650,0,0,0,0,0,2875,0,0,0,0,0,2875,0,X,30.63,X,9,0,0,0,9
......
分享至
成為作者繼續創作的動力吧!
© 2024 vocus All rights reserved.