I want to store stock data from the FTSE 100 every 10 seconds but am confused how I should set up my tables.
I need to save the price, increase and % increase as well as some way of identifying which stock is which.
Should I have one massive table with 300+ columns. (3 for each stock)?
Separate tables per stock or something else?
I will be querying the data using PHP and displaying it on a website.