FitBit Fitness Tracker Data

id Id	activityhour ActivityHour	calories00 Calories00	calories01 Calories01	calories02 Calories02	calories03 Calories03	calories04 Calories04	calories05 Calories05	calories06 Calories06	calories07 Calories07	calories08 Calories08	calories09 Calories09	calories10 Calories10	calories11 Calories11	calories12 Calories12	calories13 Calories13	calories14 Calories14	calories15 Calories15	calories16 Calories16	calories17 Calories17	calories18 Calories18	calories19 Calories19	calories20 Calories20	calories21 Calories21	calories22 Calories22	calories23 Calories23	calories24 Calories24	calories25 Calories25	calories26 Calories26	calories27 Calories27	calories28 Calories28	calories29 Calories29	calories30 Calories30	calories31 Calories31	calories32 Calories32	calories33 Calories33	calories34 Calories34	calories35 Calories35	calories36 Calories36	calories37 Calories37	calories38 Calories38	calories39 Calories39	calories40 Calories40	calories41 Calories41	calories42 Calories42	calories43 Calories43	calories44 Calories44	calories45 Calories45	calories46 Calories46	calories47 Calories47	calories48 Calories48	calories49 Calories49	calories50 Calories50	calories51 Calories51	calories52 Calories52	calories53 Calories53	calories54 Calories54	calories55 Calories55	calories56 Calories56	calories57 Calories57	calories58 Calories58	calories59 Calories59
1503960366	4/13/2016 12:00:00 AM	1.88759994506836	2.20219993591309	0.94379997253418	0.94379997253418	0.94379997253418	2.04489994049072	0.94379997253418	2.20219993591309	0.94379997253418	0.786499977111816	0.94379997253418	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.94379997253418	0.94379997253418	0.786499977111816	0.786499977111816	0.786499977111816	1.88759994506836	0.94379997253418	0.94379997253418	0.94379997253418	0.94379997253418	2.04489994049072	2.35949993133545	0.94379997253418	2.04489994049072	0.94379997253418	0.94379997253418	0.94379997253418	2.04489994049072	1.88759994506836	0.94379997253418	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.94379997253418	2.04489994049072	2.04489994049072	0.94379997253418	2.35949993133545	1.88759994506836	0.94379997253418	0.94379997253418	0.94379997253418	0.94379997253418
1503960366	4/13/2016 1:00:00 AM	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.94379997253418	0.94379997253418	0.94379997253418	0.786499977111816	0.94379997253418	0.786499977111816	0.94379997253418	0.786499977111816	0.94379997253418	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816
1503960366	4/13/2016 2:00:00 AM	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816
1503960366	4/13/2016 3:00:00 AM	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	2.04489994049072	0.94379997253418	0.786499977111816	0.786499977111816	0.94379997253418	0.786499977111816	0.94379997253418	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.94379997253418	2.04489994049072	2.04489994049072	1.88759994506836	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816
1503960366	4/13/2016 4:00:00 AM	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.94379997253418	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816
1503960366	4/13/2016 5:00:00 AM	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.94379997253418	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816
1503960366	4/13/2016 6:00:00 AM	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.94379997253418	0.94379997253418	0.786499977111816	0.94379997253418	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.94379997253418	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816
1503960366	4/13/2016 7:00:00 AM	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	2.51679992675781	2.04489994049072	0.786499977111816	0.786499977111816	0.786499977111816	0.94379997253418	2.04489994049072	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	2.51679992675781	2.04489994049072	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	2.20219993591309	2.20219993591309	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	2.20219993591309
1503960366	4/13/2016 8:00:00 AM	0.94379997253418	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.94379997253418	0.786499977111816	0.786499977111816	1.88759994506836	0.94379997253418	2.20219993591309	0.94379997253418	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.94379997253418	2.51679992675781	0.94379997253418	0.786499977111816	0.94379997253418	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	2.83139991760254	0.94379997253418	2.04489994049072	0.94379997253418	0.94379997253418	0.786499977111816	2.51679992675781	2.35949993133545	0.94379997253418	0.94379997253418	0.94379997253418	0.786499977111816	0.786499977111816	2.20219993591309	0.94379997253418	2.35949993133545	0.94379997253418	0.94379997253418	0.94379997253418	0.786499977111816	2.51679992675781	0.94379997253418	2.83139991760254	1.88759994506836
1503960366	4/13/2016 9:00:00 AM	0.94379997253418	2.20219993591309	2.04489994049072	2.51679992675781	2.67409992218018	2.20219993591309	2.35949993133545	2.04489994049072	1.88759994506836	2.51679992675781	2.04489994049072	5.50549983978271	6.99984979629517	8.41555023193359	8.73015022277832	6.76389980316162	2.35949993133545	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.94379997253418	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	2.35949993133545	2.83139991760254	4.40439987182617	5.9773998260498	2.35949993133545	0.786499977111816	0.786499977111816	0.786499977111816	0.786499977111816	6.13469982147217	6.37064981460571	5.50549983978271	3.93249988555908	0.786499977111816	0.786499977111816	2.04489994049072	0.94379997253418	0.94379997253418	0.94379997253418	0.786499977111816	0.94379997253418	0.94379997253418	0.94379997253418	5.34819984436035


CREATE TABLE minutecalorieswide_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "calories00" DOUBLE,
  "calories01" DOUBLE,
  "calories02" DOUBLE,
  "calories03" DOUBLE,
  "calories04" DOUBLE,
  "calories05" DOUBLE,
  "calories06" DOUBLE,
  "calories07" DOUBLE,
  "calories08" DOUBLE,
  "calories09" DOUBLE,
  "calories10" DOUBLE,
  "calories11" DOUBLE,
  "calories12" DOUBLE,
  "calories13" DOUBLE,
  "calories14" DOUBLE,
  "calories15" DOUBLE,
  "calories16" DOUBLE,
  "calories17" DOUBLE,
  "calories18" DOUBLE,
  "calories19" DOUBLE,
  "calories20" DOUBLE,
  "calories21" DOUBLE,
  "calories22" DOUBLE,
  "calories23" DOUBLE,
  "calories24" DOUBLE,
  "calories25" DOUBLE,
  "calories26" DOUBLE,
  "calories27" DOUBLE,
  "calories28" DOUBLE,
  "calories29" DOUBLE,
  "calories30" DOUBLE,
  "calories31" DOUBLE,
  "calories32" DOUBLE,
  "calories33" DOUBLE,
  "calories34" DOUBLE,
  "calories35" DOUBLE,
  "calories36" DOUBLE,
  "calories37" DOUBLE,
  "calories38" DOUBLE,
  "calories39" DOUBLE,
  "calories40" DOUBLE,
  "calories41" DOUBLE,
  "calories42" DOUBLE,
  "calories43" DOUBLE,
  "calories44" DOUBLE,
  "calories45" DOUBLE,
  "calories46" DOUBLE,
  "calories47" DOUBLE,
  "calories48" DOUBLE,
  "calories49" DOUBLE,
  "calories50" DOUBLE,
  "calories51" DOUBLE,
  "calories52" DOUBLE,
  "calories53" DOUBLE,
  "calories54" DOUBLE,
  "calories55" DOUBLE,
  "calories56" DOUBLE,
  "calories57" DOUBLE,
  "calories58" DOUBLE,
  "calories59" DOUBLE
);