- Joined
- 11/13/16
- Messages
- 1
- Points
- 11
I'm looking to store EOD data in a MySQL database. The table would be simple with columns for Ticker, date OHLC.
The problems are that the company associated with certain tickers changes over time (C used to be Chrysler, now it is Citibank). What is the most efficient way to store the data so that I can query a company's data going back as long as I want?
The problems are that the company associated with certain tickers changes over time (C used to be Chrysler, now it is Citibank). What is the most efficient way to store the data so that I can query a company's data going back as long as I want?
