Time Series database for tick and trade data.

May 21st, 2019, 07:57 AM

Optiondreamer

In this thread have been listed enough alternatives to make a decision. I think that depends on the tool you use to analyze the data.
If you use a third-party tool, the type of DB to be used is not relevant because it does not make sense to use a different one.
If you make your own tool, then you must choose the DB/Library that better fit your goals, and here a lot of variables come in.
Being simplistic, an example would be to use TeaFiles for single data series. To make decisions from multiple data sources a relational db could be used, but this could be achieved through code, too, using single series.
There is no one solution, analize your goals and test and measure the tools better fit.

Thanks for the ideas @Optiondreamer

Regarding this point - If you use a third-party tool, the type of DB to be used is not relevant because it does not make sense to use a different one.

I want to clarify that I am planning to store the TICK data into the TimeSeries Database and then use tools like Tableau or Microsoft PowerBI etc. for analyzing and visualizing it.

So far I have narrowed down to these 2 database, based on the suggestions received - TimeScale db and Influxdb. But I am open to other db as well, if they provide some special tools or features which makes it easy to use them for doing Stock Market related analysis and queries work.

If anyone here is using these timeseries db like - TimeScale db and Influxdb for storing and analyzing their stock market data, then please share your experience.

Thanks a lot

Time Series database for tick and trade data.

Discussion in Platforms and Indicators

Time Series database for tick and trade data.