This time data represents earthquake tremors leading up to a volcanic eruption.  Each time plot is an instances of seismic activity.

Why only 15? You need to add a PRIMARY KEY to time_taken. This forms a Compound Primary Key where sensor_id is a partition key for data.  The remaining part of the compound primary key Time_taken is used as a clustering mechanism and ensures data is stored in ascending order.



benjamin@benjamin-VirtualBox:~/Desktop/dsc-cassandra-2.0.3/bin$ ./cqlsh
Connected to Test Cluster at localhost:9160.
[cqlsh 4.1.0 | Cassandra 2.0.3 | CQL spec 3.1.1 | Thrift protocol 19.38.0]
Use HELP for help.
cqlsh> CREATE KEYSPACE volcanic_eruptions WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
cqlsh> use volcanic_eruptions;
cqlsh:volcanic_eruptions> describe tables;

<empty>

cqlsh:volcanic_eruptions> CREATE TABLE eruptions_entries (
                      ... sensor_id uuid, 
                      ... time_taken timeuuid, 
                      ... reading text,
                      ... PRIMARY KEY (sensor_id, time_taken));
cqlsh:volcanic_eruptions> 
cqlsh:volcanic_eruptions> 
cqlsh:volcanic_eruptions> describe tables;

eruptions_entries

cqlsh:volcanic_eruptions>

benjamin@benjamin-VirtualBox:~/Desktop/dsc-cassandra-2.0.3$ cd pylib/
benjamin@benjamin-VirtualBox:~/Desktop/dsc-cassandra-2.0.3/pylib$ ls
build  cqlshlib  setup.py
benjamin@benjamin-VirtualBox:~/Desktop/dsc-cassandra-2.0.3/pylib$ vim gen.py
benjamin@benjamin-VirtualBox:~/Desktop/dsc-cassandra-2.0.3/pylib$ 
benjamin@benjamin-VirtualBox:~/Desktop/dsc-cassandra-2.0.3/pylib$ 
benjamin@benjamin-VirtualBox:~/Desktop/dsc-cassandra-2.0.3/pylib$ cat gen.py 
import uuid
import cql # this is the python lib
import time

# connect to the sensor keyspace using cql3
conn = cql.connect('localhost', 9160, 'volcanic_eruptions', cql_version='3.1.0')

# put in 15 sensor ids with 10 readings each into the database (2 loops)
for j in range(15):
    key = uuid.uuid4()
    for i in range(10):
        ts = uuid.uuid1()
        time.sleep(.75) # give a separation to the simulated readings
        query = """INSERT INTO eruptions_entries
                    (sensor_id, time_taken, reading)
                    VALUES (:sensor_id, :time_taken, :reading)"""
        values = {'sensor_id':key,
                  'time_taken': ts,
                  'reading': "random sample from {} is {}".format(j,i)}
        cur = conn.cursor()
        cur.execute(query, values)
benjamin@benjamin-VirtualBox:~/Desktop/dsc-cassandra-2.0.3/pylib$ 
benjamin@benjamin-VirtualBox:~/Desktop/dsc-cassandra-2.0.3/pylib$ 
benjamin@benjamin-VirtualBox:~/Desktop/dsc-cassandra-2.0.3/pylib$

cqlsh:volcanic_eruptions> 
cqlsh:volcanic_eruptions> select * from eruptions_entries;

 sensor_id                            | time_taken                           | reading
--------------------------------------+--------------------------------------+----------------------------
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 0077b960-5d7c-11e3-9b9f-080027f263b8 |  random sample from 4 is 0
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 00eb39bc-5d7c-11e3-9b9f-080027f263b8 |  random sample from 4 is 1
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 015e497a-5d7c-11e3-9b9f-080027f263b8 |  random sample from 4 is 2
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 01d1735a-5d7c-11e3-9b9f-080027f263b8 |  random sample from 4 is 3
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 0244a834-5d7c-11e3-9b9f-080027f263b8 |  random sample from 4 is 4
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 02b7f2a8-5d7c-11e3-9b9f-080027f263b8 |  random sample from 4 is 5
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 032b202a-5d7c-11e3-9b9f-080027f263b8 |  random sample from 4 is 6
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 039e5b1c-5d7c-11e3-9b9f-080027f263b8 |  random sample from 4 is 7
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 0411a8a6-5d7c-11e3-9b9f-080027f263b8 |  random sample from 4 is 8
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 0484beea-5d7c-11e3-9b9f-080027f263b8 |  random sample from 4 is 9
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 09787eaa-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 0
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 09ebb424-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 1
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 0a5ee188-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 2
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 0ad1f722-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 3
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 0b45899e-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 4
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 0bb8c008-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 5
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 0c2beb0a-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 6
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 0c9f4438-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 7
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 0d127d5e-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 8
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 0d85c3fe-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 9
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 247cb0fe-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 0
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 24f0aa86-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 1
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 256405f8-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 2
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 25d763d6-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 3
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 264b2dfc-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 4
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 26bf3e68-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 5
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 2732b776-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 6
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 27a60942-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 7
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 281a550e-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 8
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 288d6d64-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 9
 297bbbbc-405f-4276-bb9f-3696d3792be7 | 1ffc0a7a-5d7c-11e3-9b9f-080027f263b8 | random sample from 11 is 0
 297bbbbc-405f-4276-bb9f-3696d3792be7 | 206f5a3e-5d7c-11e3-9b9f-080027f263b8 | random sample from 11 is 1
 297bbbbc-405f-4276-bb9f-3696d3792be7 | 20e2a7c8-5d7c-11e3-9b9f-080027f263b8 | random sample from 11 is 2
 297bbbbc-405f-4276-bb9f-3696d3792be7 | 21562bf8-5d7c-11e3-9b9f-080027f263b8 | random sample from 11 is 3
 297bbbbc-405f-4276-bb9f-3696d3792be7 | 21c96c62-5d7c-11e3-9b9f-080027f263b8 | random sample from 11 is 4
 297bbbbc-405f-4276-bb9f-3696d3792be7 | 223cd4ea-5d7c-11e3-9b9f-080027f263b8 | random sample from 11 is 5
 297bbbbc-405f-4276-bb9f-3696d3792be7 | 22afdb98-5d7c-11e3-9b9f-080027f263b8 | random sample from 11 is 6
 297bbbbc-405f-4276-bb9f-3696d3792be7 | 2322f52e-5d7c-11e3-9b9f-080027f263b8 | random sample from 11 is 7
 297bbbbc-405f-4276-bb9f-3696d3792be7 | 23966658-5d7c-11e3-9b9f-080027f263b8 | random sample from 11 is 8
 297bbbbc-405f-4276-bb9f-3696d3792be7 | 24098200-5d7c-11e3-9b9f-080027f263b8 | random sample from 11 is 9
 1ec3c1d6-b530-4699-a788-24263dee7c0b | 0df8f054-5d7c-11e3-9b9f-080027f263b8 |  random sample from 7 is 0
 1ec3c1d6-b530-4699-a788-24263dee7c0b | 0e6c3500-5d7c-11e3-9b9f-080027f263b8 |  random sample from 7 is 1
 1ec3c1d6-b530-4699-a788-24263dee7c0b | 0edfab7a-5d7c-11e3-9b9f-080027f263b8 |  random sample from 7 is 2
 1ec3c1d6-b530-4699-a788-24263dee7c0b | 0f52b62e-5d7c-11e3-9b9f-080027f263b8 |  random sample from 7 is 3
 1ec3c1d6-b530-4699-a788-24263dee7c0b | 0fc5f648-5d7c-11e3-9b9f-080027f263b8 |  random sample from 7 is 4
 1ec3c1d6-b530-4699-a788-24263dee7c0b | 103960e2-5d7c-11e3-9b9f-080027f263b8 |  random sample from 7 is 5
 1ec3c1d6-b530-4699-a788-24263dee7c0b | 10ac9cd8-5d7c-11e3-9b9f-080027f263b8 |  random sample from 7 is 6
 1ec3c1d6-b530-4699-a788-24263dee7c0b | 112004b6-5d7c-11e3-9b9f-080027f263b8 |  random sample from 7 is 7
 1ec3c1d6-b530-4699-a788-24263dee7c0b | 1193367a-5d7c-11e3-9b9f-080027f263b8 |  random sample from 7 is 8
 1ec3c1d6-b530-4699-a788-24263dee7c0b | 1206529a-5d7c-11e3-9b9f-080027f263b8 |  random sample from 7 is 9
 be99398b-5c47-40cc-a90c-816678356d01 | ee5f027e-5d7b-11e3-9b9f-080027f263b8 |  random sample from 0 is 0
 be99398b-5c47-40cc-a90c-816678356d01 | eeda62fc-5d7b-11e3-9b9f-080027f263b8 |  random sample from 0 is 1
 be99398b-5c47-40cc-a90c-816678356d01 | ef4ed59c-5d7b-11e3-9b9f-080027f263b8 |  random sample from 0 is 2
 be99398b-5c47-40cc-a90c-816678356d01 | efc2d1f4-5d7b-11e3-9b9f-080027f263b8 |  random sample from 0 is 3
 be99398b-5c47-40cc-a90c-816678356d01 | f03710d2-5d7b-11e3-9b9f-080027f263b8 |  random sample from 0 is 4
 be99398b-5c47-40cc-a90c-816678356d01 | f0aa8da0-5d7b-11e3-9b9f-080027f263b8 |  random sample from 0 is 5
 be99398b-5c47-40cc-a90c-816678356d01 | f11e4790-5d7b-11e3-9b9f-080027f263b8 |  random sample from 0 is 6
 be99398b-5c47-40cc-a90c-816678356d01 | f1918c50-5d7b-11e3-9b9f-080027f263b8 |  random sample from 0 is 7
 be99398b-5c47-40cc-a90c-816678356d01 | f204f1ea-5d7b-11e3-9b9f-080027f263b8 |  random sample from 0 is 8
 be99398b-5c47-40cc-a90c-816678356d01 | f278746c-5d7b-11e3-9b9f-080027f263b8 |  random sample from 0 is 9
 ca407fc0-2e90-412e-9502-f2c848314e4d | f2ec8f28-5d7b-11e3-9b9f-080027f263b8 |  random sample from 1 is 0
 ca407fc0-2e90-412e-9502-f2c848314e4d | f360016a-5d7b-11e3-9b9f-080027f263b8 |  random sample from 1 is 1
 ca407fc0-2e90-412e-9502-f2c848314e4d | f3d3b600-5d7b-11e3-9b9f-080027f263b8 |  random sample from 1 is 2
 ca407fc0-2e90-412e-9502-f2c848314e4d | f4473de6-5d7b-11e3-9b9f-080027f263b8 |  random sample from 1 is 3
 ca407fc0-2e90-412e-9502-f2c848314e4d | f4bb73e6-5d7b-11e3-9b9f-080027f263b8 |  random sample from 1 is 4
 ca407fc0-2e90-412e-9502-f2c848314e4d | f52ee8b2-5d7b-11e3-9b9f-080027f263b8 |  random sample from 1 is 5
 ca407fc0-2e90-412e-9502-f2c848314e4d | f5a35670-5d7b-11e3-9b9f-080027f263b8 |  random sample from 1 is 6
 ca407fc0-2e90-412e-9502-f2c848314e4d | f616329e-5d7b-11e3-9b9f-080027f263b8 |  random sample from 1 is 7
 ca407fc0-2e90-412e-9502-f2c848314e4d | f68a677c-5d7b-11e3-9b9f-080027f263b8 |  random sample from 1 is 8
 ca407fc0-2e90-412e-9502-f2c848314e4d | f6fe5c7c-5d7b-11e3-9b9f-080027f263b8 |  random sample from 1 is 9
 86749f96-55a0-4b39-a69d-404073130598 | fbf7aa08-5d7b-11e3-9b9f-080027f263b8 |  random sample from 3 is 0
 86749f96-55a0-4b39-a69d-404073130598 | fc6b080e-5d7b-11e3-9b9f-080027f263b8 |  random sample from 3 is 1
 86749f96-55a0-4b39-a69d-404073130598 | fcddeef0-5d7b-11e3-9b9f-080027f263b8 |  random sample from 3 is 2
 86749f96-55a0-4b39-a69d-404073130598 | fd50da5a-5d7b-11e3-9b9f-080027f263b8 |  random sample from 3 is 3
 86749f96-55a0-4b39-a69d-404073130598 | fdc41fce-5d7b-11e3-9b9f-080027f263b8 |  random sample from 3 is 4
 86749f96-55a0-4b39-a69d-404073130598 | fe37787a-5d7b-11e3-9b9f-080027f263b8 |  random sample from 3 is 5
 86749f96-55a0-4b39-a69d-404073130598 | feaad77a-5d7b-11e3-9b9f-080027f263b8 |  random sample from 3 is 6
 86749f96-55a0-4b39-a69d-404073130598 | ff1de148-5d7b-11e3-9b9f-080027f263b8 |  random sample from 3 is 7
 86749f96-55a0-4b39-a69d-404073130598 | ff912130-5d7b-11e3-9b9f-080027f263b8 |  random sample from 3 is 8
 86749f96-55a0-4b39-a69d-404073130598 | 00044e62-5d7c-11e3-9b9f-080027f263b8 |  random sample from 3 is 9
 71f6e7d0-79fe-4d17-8d0e-67f952a41bfc | 1b7b6270-5d7c-11e3-9b9f-080027f263b8 | random sample from 10 is 0
 71f6e7d0-79fe-4d17-8d0e-67f952a41bfc | 1bee947a-5d7c-11e3-9b9f-080027f263b8 | random sample from 10 is 1
 71f6e7d0-79fe-4d17-8d0e-67f952a41bfc | 1c61af32-5d7c-11e3-9b9f-080027f263b8 | random sample from 10 is 2
 71f6e7d0-79fe-4d17-8d0e-67f952a41bfc | 1cd4f08c-5d7c-11e3-9b9f-080027f263b8 | random sample from 10 is 3
 71f6e7d0-79fe-4d17-8d0e-67f952a41bfc | 1d482e62-5d7c-11e3-9b9f-080027f263b8 | random sample from 10 is 4
 71f6e7d0-79fe-4d17-8d0e-67f952a41bfc | 1dbb4780-5d7c-11e3-9b9f-080027f263b8 | random sample from 10 is 5
 71f6e7d0-79fe-4d17-8d0e-67f952a41bfc | 1e2e8768-5d7c-11e3-9b9f-080027f263b8 | random sample from 10 is 6
 71f6e7d0-79fe-4d17-8d0e-67f952a41bfc | 1ea1ee92-5d7c-11e3-9b9f-080027f263b8 | random sample from 10 is 7
 71f6e7d0-79fe-4d17-8d0e-67f952a41bfc | 1f1535aa-5d7c-11e3-9b9f-080027f263b8 | random sample from 10 is 8
 71f6e7d0-79fe-4d17-8d0e-67f952a41bfc | 1f887696-5d7c-11e3-9b9f-080027f263b8 | random sample from 10 is 9
 0ad2eba1-0c61-46b5-b054-396682ca5ef5 | f7731530-5d7b-11e3-9b9f-080027f263b8 |  random sample from 2 is 0
 0ad2eba1-0c61-46b5-b054-396682ca5ef5 | f7e76be2-5d7b-11e3-9b9f-080027f263b8 |  random sample from 2 is 1
 0ad2eba1-0c61-46b5-b054-396682ca5ef5 | f85ac5e2-5d7b-11e3-9b9f-080027f263b8 |  random sample from 2 is 2
 0ad2eba1-0c61-46b5-b054-396682ca5ef5 | f8ceb8bc-5d7b-11e3-9b9f-080027f263b8 |  random sample from 2 is 3
 0ad2eba1-0c61-46b5-b054-396682ca5ef5 | f941e116-5d7b-11e3-9b9f-080027f263b8 |  random sample from 2 is 4
 0ad2eba1-0c61-46b5-b054-396682ca5ef5 | f9b539f4-5d7b-11e3-9b9f-080027f263b8 |  random sample from 2 is 5
 0ad2eba1-0c61-46b5-b054-396682ca5ef5 | fa293a8e-5d7b-11e3-9b9f-080027f263b8 |  random sample from 2 is 6
 0ad2eba1-0c61-46b5-b054-396682ca5ef5 | fa9cf938-5d7b-11e3-9b9f-080027f263b8 |  random sample from 2 is 7
 0ad2eba1-0c61-46b5-b054-396682ca5ef5 | fb1068f0-5d7b-11e3-9b9f-080027f263b8 |  random sample from 2 is 8
 0ad2eba1-0c61-46b5-b054-396682ca5ef5 | fb8412dc-5d7b-11e3-9b9f-080027f263b8 |  random sample from 2 is 9
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 2d8144e4-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 0
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 2df49b60-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 1
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 2e67bc58-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 2
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 2edadd8c-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 3
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 2f4dece6-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 4
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 2fc0d238-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 5
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 30344aba-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 6
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 30a7c42c-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 7
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 311aef10-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 8
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 318e621a-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 9
 1cadacb6-0fac-4c31-9d89-13422645bf7a | 127a083e-5d7c-11e3-9b9f-080027f263b8 |  random sample from 8 is 0
 1cadacb6-0fac-4c31-9d89-13422645bf7a | 12ed3e1c-5d7c-11e3-9b9f-080027f263b8 |  random sample from 8 is 1
 1cadacb6-0fac-4c31-9d89-13422645bf7a | 13607652-5d7c-11e3-9b9f-080027f263b8 |  random sample from 8 is 2
 1cadacb6-0fac-4c31-9d89-13422645bf7a | 13d38156-5d7c-11e3-9b9f-080027f263b8 |  random sample from 8 is 3
 1cadacb6-0fac-4c31-9d89-13422645bf7a | 1446ca80-5d7c-11e3-9b9f-080027f263b8 |  random sample from 8 is 4
 1cadacb6-0fac-4c31-9d89-13422645bf7a | 14ba3e48-5d7c-11e3-9b9f-080027f263b8 |  random sample from 8 is 5
 1cadacb6-0fac-4c31-9d89-13422645bf7a | 152d971c-5d7c-11e3-9b9f-080027f263b8 |  random sample from 8 is 6
 1cadacb6-0fac-4c31-9d89-13422645bf7a | 15a0c444-5d7c-11e3-9b9f-080027f263b8 |  random sample from 8 is 7
 1cadacb6-0fac-4c31-9d89-13422645bf7a | 1613de2a-5d7c-11e3-9b9f-080027f263b8 |  random sample from 8 is 8
 1cadacb6-0fac-4c31-9d89-13422645bf7a | 168758b4-5d7c-11e3-9b9f-080027f263b8 |  random sample from 8 is 9
 b4226e2d-2968-497f-aa36-a197595597c4 | 04f7fea0-5d7c-11e3-9b9f-080027f263b8 |  random sample from 5 is 0
 b4226e2d-2968-497f-aa36-a197595597c4 | 056b53dc-5d7c-11e3-9b9f-080027f263b8 |  random sample from 5 is 1
 b4226e2d-2968-497f-aa36-a197595597c4 | 05de68f4-5d7c-11e3-9b9f-080027f263b8 |  random sample from 5 is 2
 b4226e2d-2968-497f-aa36-a197595597c4 | 0651648a-5d7c-11e3-9b9f-080027f263b8 |  random sample from 5 is 3
 b4226e2d-2968-497f-aa36-a197595597c4 | 06c4aa26-5d7c-11e3-9b9f-080027f263b8 |  random sample from 5 is 4
 b4226e2d-2968-497f-aa36-a197595597c4 | 07380732-5d7c-11e3-9b9f-080027f263b8 |  random sample from 5 is 5
 b4226e2d-2968-497f-aa36-a197595597c4 | 07ab3b4e-5d7c-11e3-9b9f-080027f263b8 |  random sample from 5 is 6
 b4226e2d-2968-497f-aa36-a197595597c4 | 081e639e-5d7c-11e3-9b9f-080027f263b8 |  random sample from 5 is 7
 b4226e2d-2968-497f-aa36-a197595597c4 | 08913874-5d7c-11e3-9b9f-080027f263b8 |  random sample from 5 is 8
 b4226e2d-2968-497f-aa36-a197595597c4 | 0904feda-5d7c-11e3-9b9f-080027f263b8 |  random sample from 5 is 9
 a91231a1-d022-4b6c-9857-4caca423cf7f | 16fa90ea-5d7c-11e3-9b9f-080027f263b8 |  random sample from 9 is 0
 a91231a1-d022-4b6c-9857-4caca423cf7f | 176de716-5d7c-11e3-9b9f-080027f263b8 |  random sample from 9 is 1
 a91231a1-d022-4b6c-9857-4caca423cf7f | 17e17172-5d7c-11e3-9b9f-080027f263b8 |  random sample from 9 is 2
 a91231a1-d022-4b6c-9857-4caca423cf7f | 1854dbc6-5d7c-11e3-9b9f-080027f263b8 |  random sample from 9 is 3
 a91231a1-d022-4b6c-9857-4caca423cf7f | 18c81d7a-5d7c-11e3-9b9f-080027f263b8 |  random sample from 9 is 4
 a91231a1-d022-4b6c-9857-4caca423cf7f | 193b4e1c-5d7c-11e3-9b9f-080027f263b8 |  random sample from 9 is 5
 a91231a1-d022-4b6c-9857-4caca423cf7f | 19aea40c-5d7c-11e3-9b9f-080027f263b8 |  random sample from 9 is 6
 a91231a1-d022-4b6c-9857-4caca423cf7f | 1a21dad0-5d7c-11e3-9b9f-080027f263b8 |  random sample from 9 is 7
 a91231a1-d022-4b6c-9857-4caca423cf7f | 1a952dd2-5d7c-11e3-9b9f-080027f263b8 |  random sample from 9 is 8
 a91231a1-d022-4b6c-9857-4caca423cf7f | 1b086194-5d7c-11e3-9b9f-080027f263b8 |  random sample from 9 is 9
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2900e4a6-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 0
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 297452ec-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 1
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 29e78582-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 2
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2a5a9b6c-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 3
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2acdde06-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 4
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2b40dac8-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 5
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2bb42712-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 6
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2c273a54-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 7
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2c9a92b0-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 8
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2d0da66a-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 9

(150 rows)

cqlsh:volcanic_eruptions> 
cqlsh:volcanic_eruptions> CREATE INDEX ON eruptions_entries(time_taken);
cqlsh:volcanic_eruptions> 
cqlsh:volcanic_eruptions> 
cqlsh:volcanic_eruptions> select *  from eruptions_entries where time_taken > maxTimeuuid(' 2013-12-04 19:09:24+1200') ALLOW FILTERING;

 sensor_id                            | time_taken                           | reading
--------------------------------------+--------------------------------------+----------------------------
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 2d8144e4-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 0
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 2df49b60-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 1
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 2e67bc58-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 2
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 2edadd8c-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 3
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 2f4dece6-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 4
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 2fc0d238-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 5
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 30344aba-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 6
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 30a7c42c-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 7
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 311aef10-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 8
 1cb4d159-0828-4d2a-b102-c56f3c3b42b0 | 318e621a-5d7c-11e3-9b9f-080027f263b8 | random sample from 14 is 9
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2bb42712-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 6
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2c273a54-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 7
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2c9a92b0-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 8
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2d0da66a-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 9

(14 rows)

cqlsh:volcanic_eruptions> 
cqlsh:volcanic_eruptions> select * from eruptions_entries where time_taken > maxTimeuuid(' 2013-12-04 19:09:24+1200') and time_taken < minTimeuuid('2013-12-04 19:08:55+1200')ALLOW FILTERING;

 sensor_id                            | time_taken                           | reading
--------------------------------------+--------------------------------------+---------------------------
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 0077b960-5d7c-11e3-9b9f-080027f263b8 | random sample from 4 is 0
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 00eb39bc-5d7c-11e3-9b9f-080027f263b8 | random sample from 4 is 1
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 015e497a-5d7c-11e3-9b9f-080027f263b8 | random sample from 4 is 2
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 01d1735a-5d7c-11e3-9b9f-080027f263b8 | random sample from 4 is 3
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 0244a834-5d7c-11e3-9b9f-080027f263b8 | random sample from 4 is 4

~~Reduced for better reading.
 
 a91231a1-d022-4b6c-9857-4caca423cf7f | 17e17172-5d7c-11e3-9b9f-080027f263b8 | random sample from 9 is 2
 a91231a1-d022-4b6c-9857-4caca423cf7f | 1854dbc6-5d7c-11e3-9b9f-080027f263b8 | random sample from 9 is 3
 a91231a1-d022-4b6c-9857-4caca423cf7f | 18c81d7a-5d7c-11e3-9b9f-080027f263b8 | random sample from 9 is 4
 a91231a1-d022-4b6c-9857-4caca423cf7f | 193b4e1c-5d7c-11e3-9b9f-080027f263b8 | random sample from 9 is 5
 a91231a1-d022-4b6c-9857-4caca423cf7f | 19aea40c-5d7c-11e3-9b9f-080027f263b8 | random sample from 9 is 6
 a91231a1-d022-4b6c-9857-4caca423cf7f | 1a21dad0-5d7c-11e3-9b9f-080027f263b8 | random sample from 9 is 7

(98 rows)

cqlsh:volcanic_eruptions> 
cqlsh:volcanic_eruptions> select sensor_id, dateOf(time_taken), reading from eruptions_entries where sensor_id = c85114ae-be6e-498a-b54c-7ff59881ed6c;

 sensor_id                            | dateOf(time_taken)       | reading
--------------------------------------+--------------------------+---------------------------
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 2013-12-04 19:08:11+1200 | random sample from 4 is 0
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 2013-12-04 19:08:12+1200 | random sample from 4 is 1
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 2013-12-04 19:08:13+1200 | random sample from 4 is 2
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 2013-12-04 19:08:13+1200 | random sample from 4 is 3
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 2013-12-04 19:08:14+1200 | random sample from 4 is 4
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 2013-12-04 19:08:15+1200 | random sample from 4 is 5
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 2013-12-04 19:08:16+1200 | random sample from 4 is 6
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 2013-12-04 19:08:16+1200 | random sample from 4 is 7
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 2013-12-04 19:08:17+1200 | random sample from 4 is 8
 c85114ae-be6e-498a-b54c-7ff59881ed6c | 2013-12-04 19:08:18+1200 | random sample from 4 is 9

(10 rows)

cqlsh:volcanic_eruptions> 
cqlsh:volcanic_eruptions> select * from eruptions_entries where time_taken >= minTimeuuid('2013-12-04 19:08:55+1200')ALLOW FILTERING;

 sensor_id                            | time_taken                           | reading
--------------------------------------+--------------------------------------+----------------------------
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 247cb0fe-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 0
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 24f0aa86-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 1
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 256405f8-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 2
 c3adafb8-ef86-4f0b-9390-178ec6d7d4cc | 25d763d6-5d7c-11e3-9b9f-080027f263b8 | random sample from 12 is 3

~~Reduced for better reading.

 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2bb42712-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 6
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2c273a54-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 7
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2c9a92b0-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 8
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2d0da66a-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 9

(52 rows)

cqlsh:volcanic_eruptions> 
cqlsh:volcanic_eruptions> select *  from eruptions_entries where time_taken < maxTimeuuid('2013-12-04 19:09:22+1200') and time_taken > minTimeuuid('2013-12-04 19:08:23+1200') ALLOW FILTERING;

 sensor_id                            | time_taken                           | reading
--------------------------------------+--------------------------------------+----------------------------
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 09787eaa-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 0
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 09ebb424-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 1
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 0a5ee188-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 2
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 0ad1f722-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 3
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 0b45899e-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 4
 dad24a08-bcd6-4dcf-9c08-b6baa445c3c4 | 0bb8c008-5d7c-11e3-9b9f-080027f263b8 |  random sample from 6 is 5

~~Reduced for better reading.

 a91231a1-d022-4b6c-9857-4caca423cf7f | 1b086194-5d7c-11e3-9b9f-080027f263b8 |  random sample from 9 is 9
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2900e4a6-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 0
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 297452ec-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 1
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 29e78582-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 2
 bc82adbb-83f1-4c77-bb99-0a4418927c7b | 2a5a9b6c-5d7c-11e3-9b9f-080027f263b8 | random sample from 13 is 3

(78 rows)

cqlsh:volcanic_eruptions>