SQLite Forum

A newbie's question about database structure design
HI, Adrian, your guess is correct, those are bid/ask quotes ticks data. What you said is very reasonable. In most cases, I don’t need to process the data repeatedly every day. I have already made daily summary data and saved them(use python DateFrame), but sometimes when I have a new strategy, I still need repeatedly traverse all the data of a stock for calculation to obtain the historical curve of the new strategy.

It seems that in this case, I only need to save the summary information in the database, and I will use python to process those CSVs when I need to traverse occasionally. This will save a lot of work.

I am a complete novice to the database and I am just starting to learn, That's why I asked such stupid questions. :)

Thank you very much for your very helpful and constructive comments.