準備資料庫:
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;