cstrader wrote: > OK, this seems really helpful, but I'm afraid you've lost me a bit. > > 1. Third normal??? :)
See http://en.wikipedia.org/wiki/Third_normal_form for an explanation. > > 2. Your idea would be to have one table that's relatively static, with the > names (and perhaps other data) of the stocks, a 2nd table that holds prices? > I'm not sure I see the advantage of this approach. > The advantage is that it gives you uniform access to all your data in the same way. It can easily be filtered to get the data for an individual stock, or the data over a specified range of time, etc. > 3. What's "Instance DateTime?" > The timestamp of the price quote. > 4. Are you saying that I could use "GROUP BY" to get daily, monthly, > yearly, etc? > No, you would use a range condition like this select ... from Price where stockID = :id and instance between '2008-08-01 00:00:00' and datetime('now') order by instance; HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
