I am starting to build a portfolio optimization algorithm in Python and want to structure a database to manipulate financial data. Although I have Python experience, I have never used SQL or such database language.

Considering I need to store 10-year-long registries of stocks information, what database framework that can be integrated with Python would you recommend for me to use?

I will need a read-only database that will be updated daily with around 400 stocks in the database.

  • $\begingroup$ Hi and welcome! There are already a number of questions on this here on Quant SE. Did they help? Also: what are your Data Access patterns (read/write patterns) and what is your data frequency (daily? Per minute? Tick data?) $\endgroup$ Aug 4 at 19:59
  • $\begingroup$ ...also how many stocks do you need to track? $\endgroup$
    – noob2
    Aug 4 at 20:06
  • $\begingroup$ I was hoping that someone could suggest me a framework that is suitable for a beginner, that's why I created a new post. The other posts on this subject seemed a bit advanced for me. $\endgroup$ Aug 4 at 20:32
  • 1
    $\begingroup$ Regarding data access, I will need to read-only. I will update the database daily and we will have around 400 stocks in the database. $\endgroup$ Aug 4 at 20:33
  • $\begingroup$ Kdb was designed for time series data but it can be expensive for a license. How granular are the time intervals for each of these stocks? $\endgroup$ Aug 5 at 12:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.