create table Quote (Symbol char(10), Day date, Open real, High real, Low real, Close real, Volume integer); insert into Quote (Symbol,Day,Open,High,Low,Close,Volume) values ('IBM', date('01-Nov-2013'), 10.2, 11.0, 10.0, 10.5, 100); insert into Quote (Symbol,Day,Open,High,Low,Close,Volume) values ('IBM', date('02-Nov-2013'), 20.2, 20.2, 20.2, 20.2, 200); insert into Quote (Symbol,Day,Open,High,Low,Close,Volume) values ('IBM', date('04-Nov-2013'), 30.5, 31.0, 30.0, 30.2, 300); insert into Quote (Symbol,Day,Open,High,Low,Close,Volume) values ('IBM', date('05-Nov-2013'), 40.5, 41.0, 40.0, 40.2, 400); insert into Quote (Symbol,Day,Open,High,Low,Close,Volume) values ('IBM', date('06-Nov-2013'), 50.2, 51.0, 50.0, 50.5, 500); insert into Quote (Symbol,Day,Open,High,Low,Close,Volume) values ('ABB', date('03-Nov-2013'), 60.5, 61.0, 70.0, 60.2, 600); insert into Quote (Symbol,Day,Open,High,Low,Close,Volume) values ('ABB', date('06-Nov-2013'), 70.2, 71.0, 70.0, 70.5, 700); create extension imcs; select cs_create('Quote', 'Day', 'Symbol'); cs_create ----------- (1 row) select Quote_load(); quote_load ------------ 7 (1 row) select cs_used_memory(); cs_used_memory ---------------- 49152 (1 row)