search

YanyangChen / stock_analysis

0 stars 0 forks source link

Connect to SQLite #1

Open YanyangChen opened 6 years ago

YanyangChen commented 6 years ago

design database with SQLite,

CRUD to SQLite with bridging functions.(http://www.sqlitetutorial.net/sqlite-java/insert/

All stock symbols: http://investexcel.net/all-yahoo-finance-stock-tickers/

YanyangChen commented 6 years ago

DB design: stkidx(key) date(key) open close volumn

YanyangChen commented 6 years ago

Sava SQLite tables to hard disk

http://www.sqlitetutorial.net/sqlite-dump/