Daft Trader

 Goal In the first part located here  stock index data was uploaded into a SQL Server database. All the incoming data that was captured from the API call was stored as strings. In this update that data will be transformed into its proper data types.

  Goal I’m in what will be a very long process of building my own personal database of stock prices and related data. One of the first points of data I aim to collect is daily price data of some of the major indices, i.e., Dow Jones, Nasdaq etc. This post will go over the first steps on how i'm capturing that data. The API service that is being used, the SQL Server table structure and the loading of data from the API call into the database using python.