I would like to load bulk data into a database of your choice. I have MySql installed but I don't know how to use it. The data will be in .csv and looks like this;
<ticker>,<date>,<open>,<high>,<low>,<close>,<vol>
AAPL,201010110900,295.01,295.05,294.82,294.82,5235
AAPL,201010110905,294.81,294.9,294.8,294.85,7441
AAPL,201010110910,294.85,294.98,294.84,294.85,4268
There will be hundreds of tickers and hundreds of dates but I only need a few of the rest of the fields.
Once we have created the database I will want to run queries on the data comparing tickers, dates, open, close and volume. This will enable me to backtest a strategy.
I have Windows 7 installed and as I mentioned MySql. If it is easier to use Sql Server I will install that too.