NodeJS stock tracker. Read historical stock data from an API to store in local DB. Offer API to integrate data into a dashboard. https://github.com/alecc08/stock-tracker-dashboard

Using Alphavantage API to get data. You can get your own API key from them at https://www.alphavantage.co

POST
/stocks

 - Params
   -stockCode

Ex: POST /stocks stockCode:MSFT

There's a cron job that runs at your time of choosing to update all stocks in the database. You can change this time in config.js

GET
/stocks

 - Params
   -stockCodes : Comma seperated list of stocks
   -start : YYYY-MM-DD format date start
   -end   : YYYY-MM-DD format date end

Ex: GET /stocks stockCodes:MSFT,FB,GOOG start:2017-01-01 end:2017-02-02

GET
/accounts

 - Params
   -accountId 

Ex: POST /stocks stockCode:MSFT

POST
/accounts
 - Params
    -accountName

To run some custom sql directly into the db, simply run the dbConsole.js file with node

node dbConsole

Then you can run any sql statement followed by a semicolon to execute the query. E.g.

SELECT * FROM stock_history;