Re: Data model for financial time series

2013-06-29 Thread Oleksandr Petrov
You can refer to the Data Modelling guide here: http://clojurecassandra.info/articles/data_modelling.html It includes several things you've mentioned (namely, range queries and dynamic tables). Also, it seems that it'd be useful for you to use indexes, and performing filtering (for things related

Data model for financial time series

2013-06-07 Thread Davide Anastasia
Hi, I am trying to build the storage of stock prices in Cassandra. My queries are ideally of three types: - give me everything between time A and time B; - give me everything about symbol X; - give me everything of type Y; ...or an intersection of the three. Something I will be happy doing is: -

Re: Data model for financial time series

2013-06-07 Thread Jake Luciani
We have built a similar system, you can ready about our data model in CQL3 here: http://www.slideshare.net/carlyeks/nyc-big-tech-day-2013 We are going to be presenting a similar talk next week at the cassandra summit. On Fri, Jun 7, 2013 at 12:34 PM, Davide Anastasia