CREATE TABLE IF NOT EXISTS gen2_test_data (id int NOT NULL AUTO_INCREMENT, timestamp datetime , ard_ts text , t00 text , t01 text , t02 text , t03 text , t04 text , t05 text , t06 text , t07 text , t08 text , t09 text , t10 text , t11 text , t12 text , t13 text , t14 text , t15 text , t16 text , t17 text , t18 text , t19 text , PRIMARY KEY(id));
INSERT INTO test (ard_ts, t00, t01, t02, t03, t04, t05, t06, t07, t08, t09, t10, t11, t12, t13, t14, t15, t16, t17, t18, t19, timestamp) VALUES ('1363629', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:51:09'), ('1295898', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:49:58'), ('1222995', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:48:52'), ('1155149', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:47:37'), ('1030650', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:45:32'), ('966121', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:44:27'), ('902618', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:43:23'), ('832974', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:42:20'), ('749751', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:40:53'), ('622187', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:39:44'), ('539143', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:37:21'), ('463863', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:36:07'), ('388980', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:34:51'), ('309146', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:33:30'), ('228412', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:32:27'), ('159109', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:31:03'), ('96115', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:29:57'), ('8313', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:28:37'), ('283109', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:25:53'), ('214788', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:24:43'), ('149129', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:23:36'), ('77562', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:22:31'), ('8315', '-2.0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2021-03-28 02:21:21'), ('7133', '-2.0', '21.53', '21.53', '21.53', '21.53', '21.53', '21.53', '21.53', '21.53', '21.53', '21.67', '21.59', '21.83', '21.66', '21.56', '21.67', '21.47', '21.41', '21.62', '24.20', '2020-11-04 03:23:30'), ('334862', '-2.0', '21.58', '21.58', '21.58', '21.58', '21.58', '21.58', '21.58', '21.58', '21.58', '21.70', '21.64', '21.89', '21.72', '21.62', '21.70', '21.52', '21.39', '21.69', '25.78', '2020-11-04 03:21:44'), ('249056', '-2.0', '21.59', '21.59', '21.59', '21.59', '21.59', '21.59', '21.59', '21.59', '21.59', '21.75', '21.69', '21.94', '21.75', '21.66', '21.77', '21.56', '21.41', '21.72', '26.64', '2020-11-04 03:20:19'), ('155032', '-2.0', '21.66', '21.66', '21.66', '21.66', '21.66', '21.66', '21.66', '21.66', '21.66', '21.80', '21.73', '22.00', '21.83', '21.72', '21.80', '21.64', '21.47', '21.78', '25.34', '2020-11-04 03:18:54'), ('7134', '-2.0', '21.73', '21.73', '21.73', '21.73', '21.73', '21.73', '21.73', '21.73', '21.73', '21.89', '21.84', '22.11', '21.95', '21.81', '21.88', '21.81', '21.56', '21.88', '25.06', '2020-11-04 03:16:18'), ('70478', '-2.0', '22.06', '22.06', '22.06', '22.06', '22.06', '22.06', '22.06', '22.06', '22.06', '22.12', '22.17', '23.03', '22.61', '22.06', '22.08', '23.22', '22.14', '22.14', '22.67', '2020-11-04 03:08:23'), ('7132', '-2.0', '21.91', '21.91', '21.91', '21.91', '21.91', '21.91', '21.91', '21.91', '21.91', '22.05', '22.25', '22.50', '22.44', '22.05', '22.06', '22.28', '21.89', '22.11', '22.53', '2020-11-04 03:07:19'), ('31975', '22.94', '22.23', '21.95', '22.81', '22.12', '22.16', '22.81', '22.81', '22.67', '22.20', '22.11', '22.11', '22.11', '22.11', '22.11', '22.11', '22.11', '22.11', '22.11', '-2.0', '2020-11-04 03:03:28');