Building A Complete Database of Historical and Realtime Data

Phase 1: I need a PHP programmer to read in ALL of the historical stock prices from such a table as shown on: [login to view URL] UP till the present day, ie from since the start date of the stock such as Nov 26, 1997 until present day. Have all the data captured inside MySQL database, one table for every stock, with 7 columns in the table, ie Ticker symbol, followed by Date, Open, High, Low, Close, Volume, Adj Close*. -I will supply a continuous list of several thousands of ticker stock symbols. -You have to enable AUTOPILOT execution of running down this list of ticker symbols, to feed the corresponding ticker symbol's data into the MySQL database's tables. MySQL database be structured this way: -(a) 1 table for every tick symbol, ie every stock -(b) 1 consolidated table for all the tables, ie all the stocks put together. Follow rest of page details on [login to view URL]: ######################################## Set Date Range Start Date: day Year Eg. Jan 1, 2010 End Date: day Year Allow Frequency to vary between: Daily Weekly Monthly Dividends Only ###################################################### Phase 2: I will subscribe to real time stock quotes from [login to view URL], and you will update in real-time mode, all these new data alongside with the historical data from Phase 1, to preferrably upload into the same corresponding table, (a) above, for the particular ticker symbol in the MySQL database, so as to add on new data to the old data for the same stock. Of course, the consolidated table of all tables, ie (b) above will also be updated at the same time. Phase 2 will run continuously so as to read in the latest data available into the MySQL database.