stock database design help

[cary ang]

hi all,

i'm looking to make a "simple" stock database for a growing list of stocks (say adding maybe 20 or so each day).

the thing is, i'm not sure how to design this database considering the potential size of it in the future.

should i make a table with 'stock symbol,' 'date,' and 'stock price' columns and then add new rows for each new day and stock symbol? (so i'd have multiple stock symbols and a ton of repeating dates in the date fields)

or, should i make a table with 'stock symbol' and make every column a date? so each row would have 'stock' 'date' 'date+1' 'date+2'... and the prices would be under each date. the only thing is i think making new columns would be a huge pain compared to just adding rows. i think.

or is there a better way to do this? i'm sort of a mysql newbie, so i appreciate any help i can get.

thanks!

-cary