i want to log the stock quotes for use in own program.
i log folowing data:
time - date - market - name - symbol - quote
numer of stock quotes: minimum 1000
number of new records a day : minimum: 150.000
Every minute i write about 100 - 200 new records
i never update records (i want to keep the old ones to see evolution)
i read the records of every quote ones a minute
i delete old quotes after a week (to save space)
what do i do:
1) i make 1 table and write every time: time - date - stockmarket - name - symbol - quote
2) i make 2 tables
- 2.a: table with data: market - name - symbol + ID
- 2 b: table with data time - date - quote + ID
3) i make for every sock a new table: 1000 tables + 1 table with information: stockmarket + ID
What is the fastest way?