Databse design for stocks

by OhMikeGod   Last Updated April 15, 2019 22:05 PM

I am a beginner in database design.

I am wondering what is the best design method to store data for stock market information. I want to create a new database to store historical prices and many other fundamentals data for multiple stock symbols.

Stock symbol may change over time and I am confused on what unique identifier to use or how to manage it. CUSIPs number may also change.

How should I do it?

I use a python to get and store the data in sql server.

thanks



Related Questions


Updated May 22, 2017 20:05 PM

Updated May 19, 2015 01:02 AM

Updated June 20, 2015 02:02 AM

Updated May 06, 2019 06:05 AM

Updated April 27, 2017 00:05 AM