New answers tagged tick-data
There are many different databases out there, all specialized for different use cases. The main parts you should consider are: Using a time series database, since they can handle timestamped data (e.g. ticks) more efficient than any SQL solution can by using bucketing and other methods. Using a database with a good query language, for example to aggregate ...
Apache Cassandra would be a good fit. It's a partitioned row store, where rows are organized into table using a partition key. It is common use case to store time series data, you could simply use ticker and a period as partition key. Cassandra is optimized for writes and it's easily scaled, but you need at least 3 servers for it to run.
Top 50 recent answers are included