CREATE TABLE sm_by_day ( device text, day text, timestamp timestamp, sensors list>>, PRIMARY KEY ( (device, day), timestamp ) );