Option intraday data to database advice?

bionary

Newbie
Messages
1
Likes
0
Hello,

I've been building some applications/tools for analyzing stocks/options using PHP(calculations)/ActionScript 3 (for charting) and I use a MySQL database to store data. right now I am simply storing daily stock data for my targeted equities of choice. I am highly interested in analyzing options but they have so many lines of data per day (intraday).

Stock data i get from yahoo for free. I am thinking about purchasing (by the minute trade data) options data from the company: tick data and then importing all the data into my MySQL database.

I can handle the coding, that's not a problem. - I'm just looking for some general advice I guess.

Does anyone have any experience doing this?
Anyone work with company: TickData before? good/bad?
What's a good table structure for storing options data?...Make a table per symbol and store all strikes/contract dates in one table?

Thanks
 
Top