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.