Create stock chart picture from mysql data

I have financial data in a mysql database an example of this data will be provided. The layout of the fields are simple: Date, time, open, high, low, close I would like to be able to generate a "price chart image" from the select query that I use. My Requirements are: 1. Image must be able to be generated from command line 2. Image size and format I would like to be able to specify. eg 800x600 and export in jpeg or png etc. 3. Ability to change the last bars colour. 4. Ability to add a small horizontal in the chart via command line syntax. (eg. 5 points above and or below the last bar, and specify the colour. 5. Ability to add? vertical lines every between x number of bars. 6. Ability to add text to the chart, (eg. Title and description). 7. Ability to chose between line bars or candlesticks. ? ? ? ## Deliverables In case of questions please feel free to contact me for more details