The bhavcopy data I upload from NSE can be uploaded at the end of the table as a new column. But I am going to have a problem with adding columns. It already over 350. I need to now prune columns from the beginning and then add new columns to the end. The calculations will be something similar to moving averages then.

I dont know how else to keep the data if not in columns. Just got a brainwave. What if I keep data for only one stock in a table. I would be having nearly 800 tables. I would still be needing columns for datewise data and rows for intra-day data. I hate keeping data in columns. Its so tough to use them in stored procedures. I have named them currently as A1, A2 ... In my java program I can call "A"+i and it generates the column name. But I dont think this is good coding. I need a proper software engineer to do my coding.

I think instead of downloading intra-day data for all stocks, I should download only for select stocks every 5 minutes. For the others i may keep an hourly frequency.