I have a use case where 1 have a million trades book a day each having state (pre-book, book, settled) that changes over time. I have requirement to query the data by state for a UI requirement. Since the state changes I can't add it as primary key. How would one model this for cassandra. Do you model the table using other column as partition and filter out result of data that do not meet the state requested?