匯入證交所交易歷史資料修正合併檔

準備資料庫

CREATE TABLE StockData( "StockDate" TEXT, "StockID" TEXT, "StockName" TEXT, "TradeQty" INT, "TransQty" INT, "TradeAmount" REAL, "OpenPrice" REAL, "HighPrice" REAL, "LowPrice" REAL, "ClosePrice" REAL, "Gain" TEXT, "DeltaPrice" REAL, "BuyPrice" REAL, "BuyQty" INT, "SellPrice" REAL, "SellQty" INT, "CR" REAL ); CREATE INDEX StockData_StockID ON StockData(StockID, StockDate); CREATE INDEX StockData_StockDate ON StockData(StockDate, StockID);

匯入資料庫

.header on .import data/TWN.csv StockData SELECT StockDate, StockID, StockName, TradeQty AS '成交量' FROM StockData ORDER BY StockDate, StockID LIMIT 10;