#
# Copyright (c) Ionplus AG and contributors. All rights reserved.
# Licensed under the MIT license. See LICENSE file in the project root for details.
#
import datetime
import pytest

from operator import itemgetter
from itertools import groupby


def create_cycle(seed_data, run, data):
    return seed_data.add_cycle(
        commit=False,
        run=run,
        number=data[1],
        runtime=data[2],
        end_of_cycle=datetime.datetime.fromisoformat(data[3]),
        r=data[4],
        g1=data[5],
        g2=data[6],
        ana=data[7],
        a=data[8],
        b=data[9],
        c=data[10],
    )


@pytest.fixture(scope='function')
def real_run(orm, seed_data):
    cycles = [
        create_cycle(seed_data, seed_data.run, d)
        for d in _data
        if d[0] == 20
    ]

    orm.commit()

    yield cycles

    for cycle in cycles:
        seed_data.delete(cycle, commit=False)
    orm.commit()


@pytest.fixture(scope='function')
def real_target(orm, seed_data):
    runs = []
    cycles = []
    for run_number, run_data in groupby(_data, itemgetter(0)):
        run = seed_data.add_run()

        cycles.extend(
            (create_cycle(seed_data, run, data) for data in run_data)
        )
        orm.commit()

        orm.session.execute(f'call calculate_run({run.id})')
        orm.commit()

        runs.append(run)

    yield runs

    for cycle in cycles:
        seed_data.delete(cycle, commit=False)
    orm.commit()

    for run in runs:
        seed_data.delete(run, commit=False)
    orm.commit()


_data = (
    # run, cycle, runtime, end_of_cycle, r, g1, g2, ana, a, b, c
    (1, 1, 19.582420, '2019-10-18 17:29:08', 5773, 2887, 1924, 67.595910822, 30.369207800, 0.331268825, 0.002322470),
    (1, 2, 19.580902, '2019-10-18 17:29:29', 5790, 2895, 1930, 66.121868114, 29.894880165, 0.326198784, 0.002179118),
    (1, 3, 19.582267, '2019-10-18 17:29:50', 5626, 2813, 1875, 64.757341252, 29.376149144, 0.320390657, 0.002081525),
    (1, 4, 19.586645, '2019-10-18 17:30:10', 5478, 2739, 1826, 64.091153487, 29.134147372, 0.317665025, 0.002023702),
    (1, 5, 19.601114, '2019-10-18 17:30:31', 5313, 2657, 1771, 63.089464058, 28.714689366, 0.312104769, 0.001961220),
    (1, 6, 19.599485, '2019-10-18 17:30:52', 5580, 2790, 1860, 63.604125466, 28.993111112, 0.315826788, 0.001955547),
    (1, 7, 19.585511, '2019-10-18 17:31:13', 5588, 2794, 1863, 63.499742121, 28.977610235, 0.315512980, 0.001933044),
    (1, 8, 19.586382, '2019-10-18 17:31:34', 5450, 2725, 1817, 63.417160127, 28.962532520, 0.315333495, 0.001911039),
    (1, 9, 19.595999, '2019-10-18 17:31:54', 5518, 2759, 1839, 63.344195935, 28.952152942, 0.315106927, 0.001890842),
    (1, 10, 19.596337, '2019-10-18 17:32:15', 5493, 2747, 1831, 63.199093412, 28.901387523, 0.314501877, 0.001867412),
    (1, 11, 19.596863, '2019-10-18 17:32:36', 5401, 2701, 1800, 63.195758801, 28.935768053, 0.314703142, 0.001849691),
    (1, 12, 19.583429, '2019-10-18 17:32:57', 5611, 2806, 1870, 62.990465776, 28.866777692, 0.313856910, 0.001835274),
    (1, 13, 19.586092, '2019-10-18 17:33:17', 5406, 2703, 1802, 62.877514391, 28.830572823, 0.313416913, 0.001822555),
    (1, 14, 19.599631, '2019-10-18 17:33:38', 5385, 2693, 1795, 62.956801268, 28.888912919, 0.313925924, 0.001813805),
    (1, 15, 19.597429, '2019-10-18 17:33:59', 5544, 2772, 1848, 63.181783396, 29.000958819, 0.315122659, 0.001812841),
    (2, 1, 19.598757, '2019-10-18 18:44:58', 5337, 2669, 1779, 60.074332704, 27.575581037, 0.299395157, 0.001931057),
    (2, 2, 19.586231, '2019-10-18 18:45:19', 5340, 2670, 1780, 62.531517871, 28.743010292, 0.312149509, 0.001868953),
    (2, 3, 19.601828, '2019-10-18 18:45:40', 5314, 2657, 1771, 62.898400823, 28.936374479, 0.314217155, 0.001830231),
    (2, 4, 19.599784, '2019-10-18 18:46:01', 5478, 2739, 1826, 63.249474749, 29.110423841, 0.316094410, 0.001810393),
    (2, 5, 19.586586, '2019-10-18 18:46:21', 5602, 2801, 1867, 63.660950551, 29.307670426, 0.318179091, 0.001800326),
    (2, 6, 19.595538, '2019-10-18 18:46:42', 5627, 2814, 1876, 63.999411111, 29.476679925, 0.319936884, 0.001791619),
    (2, 7, 19.596789, '2019-10-18 18:47:03', 5656, 2828, 1885, 64.281278030, 29.612263978, 0.321401349, 0.001783972),
    (2, 8, 19.583140, '2019-10-18 18:47:24', 5744, 2872, 1915, 64.587771522, 29.756643592, 0.322934153, 0.001782236),
    (2, 9, 19.586200, '2019-10-18 18:47:44', 5580, 2790, 1860, 64.834463040, 29.866346816, 0.324136505, 0.001784131),
    (2, 10, 19.599517, '2019-10-18 18:48:05', 5445, 2723, 1815, 64.839459901, 29.872932250, 0.324225968, 0.001779243),
    (2, 11, 19.597121, '2019-10-18 18:48:26', 5652, 2826, 1884, 64.972430175, 29.934767414, 0.324803025, 0.001775160),
    (2, 12, 19.598458, '2019-10-18 18:48:47', 5760, 2880, 1920, 65.195451009, 30.032420856, 0.325848246, 0.001773513),
    (2, 13, 19.583366, '2019-10-18 18:49:08', 5789, 2895, 1930, 65.506988267, 30.173847390, 0.327321389, 0.001770618),
    (2, 14, 19.595665, '2019-10-18 18:49:28', 5688, 2844, 1896, 65.675692404, 30.242882298, 0.328083547, 0.001766439),
    (2, 15, 19.594981, '2019-10-18 18:49:49', 5726, 2863, 1909, 65.936119244, 30.365809067, 0.329431592, 0.001767123),
    (3, 1, 19.597837, '2019-10-18 19:58:01', 5391, 2696, 1797, 62.189027932, 28.620464323, 0.310321676, 0.001850006),
    (3, 2, 19.596411, '2019-10-18 19:58:22', 5618, 2809, 1873, 65.152068805, 30.005102619, 0.325402683, 0.001814242),
    (3, 3, 19.596064, '2019-10-18 19:58:43', 5790, 2895, 1930, 66.095251944, 30.453888814, 0.330270659, 0.001803446),
    (3, 4, 16.145662, '2019-10-18 19:59:04', 4642, 2321, 1547, 66.588342280, 30.651384280, 0.329440814, 0.001801725),
    (3, 5, 19.587408, '2019-10-18 19:59:25', 5601, 2801, 1867, 66.112398251, 30.400506962, 0.330381718, 0.001776290),
    (3, 6, 19.583188, '2019-10-18 19:59:45', 5765, 2883, 1922, 67.186066048, 30.967200697, 0.335736178, 0.001799557),
    (3, 7, 19.595165, '2019-10-18 20:00:06', 5798, 2899, 1933, 67.448728653, 31.087282763, 0.337055883, 0.001797084),
    (3, 8, 19.581796, '2019-10-18 20:00:27', 6011, 3006, 2004, 67.870977759, 31.277960324, 0.339063676, 0.001803046),
    (3, 9, 19.593158, '2019-10-18 20:00:48', 5892, 2946, 1964, 68.008095908, 31.341737548, 0.339730694, 0.001805700),
    (3, 10, 19.593137, '2019-10-18 20:01:09', 5951, 2976, 1984, 68.132702415, 31.392809516, 0.340344029, 0.001807044),
    (3, 11, 19.594072, '2019-10-18 20:01:29', 6007, 3004, 2002, 68.041557957, 31.357266296, 0.339869450, 0.001800833),
    (3, 12, 19.592253, '2019-10-18 20:01:50', 6011, 3006, 2004, 68.002977983, 31.337626011, 0.339661694, 0.001794989),
    (3, 13, 19.595817, '2019-10-18 20:02:11', 5954, 2977, 1985, 67.960260937, 31.325888401, 0.339474754, 0.001788516),
    (3, 14, 19.596979, '2019-10-18 20:02:32', 5920, 2960, 1973, 67.946932239, 31.321576243, 0.339399470, 0.001787889),
    (3, 15, 19.581195, '2019-10-18 20:02:53', 5827, 2914, 1942, 68.093074044, 31.397659461, 0.340138904, 0.001791208),
    (4, 1, 19.595553, '2019-10-18 21:11:06', 5645, 2823, 1882, 63.201119632, 29.132191382, 0.315325388, 0.001838945),
    (4, 2, 19.596504, '2019-10-18 21:11:26', 5738, 2869, 1913, 66.149385584, 30.495710594, 0.330248938, 0.001797139),
    (4, 3, 19.592827, '2019-10-18 21:11:47', 5856, 2928, 1952, 67.013986016, 30.902617860, 0.334606508, 0.001790118),
    (4, 4, 19.580679, '2019-10-18 21:12:08', 5834, 2917, 1945, 67.419616255, 31.102432091, 0.336734318, 0.001787297),
    (4, 5, 19.580933, '2019-10-18 21:12:29', 5862, 2931, 1954, 67.787873714, 31.270150203, 0.338568974, 0.001785492),
    (4, 6, 19.585183, '2019-10-18 21:12:50', 5860, 2930, 1953, 68.117768591, 31.421423713, 0.340170586, 0.001787430),
    (4, 7, 19.592146, '2019-10-18 21:13:10', 5921, 2961, 1974, 68.289689695, 31.498474279, 0.341007459, 0.001792615),
    (4, 8, 19.580934, '2019-10-18 21:13:31', 5926, 2963, 1975, 68.427267729, 31.560124555, 0.341571878, 0.001791528),
    (4, 9, 19.592995, '2019-10-18 21:13:52', 5997, 2999, 1999, 68.545487864, 31.609849870, 0.342122646, 0.001790041),
    (4, 10, 19.586234, '2019-10-18 21:14:13', 5892, 2946, 1964, 68.542464733, 31.620434992, 0.342196075, 0.001787722),
    (4, 11, 19.581563, '2019-10-18 21:14:33', 5866, 2933, 1955, 68.472454798, 31.609308171, 0.341992410, 0.001781772),
    (4, 12, 19.582232, '2019-10-18 21:14:54', 5907, 2954, 1969, 68.243270410, 31.513956076, 0.340878170, 0.001772039),
    (4, 13, 19.594312, '2019-10-18 21:15:15', 6009, 3005, 2003, 68.183416575, 31.496003122, 0.340681841, 0.001766286),
    (4, 14, 19.595017, '2019-10-18 21:15:36', 5823, 2912, 1941, 68.123288518, 31.482516625, 0.340487878, 0.001758001),
    (4, 15, 19.581306, '2019-10-18 21:15:57', 5959, 2980, 1986, 68.044171252, 31.453605927, 0.340122672, 0.001750792),
    (5, 1, 19.597116, '2019-10-18 22:24:08', 5474, 2737, 1825, 63.009606965, 29.103173118, 0.314498020, 0.001781452),
    (5, 2, 19.596005, '2019-10-18 22:24:29', 5617, 2809, 1872, 65.970324002, 30.492968314, 0.329609786, 0.001746128),
    (5, 3, 19.582014, '2019-10-18 22:24:50', 5811, 2906, 1937, 66.954583793, 30.953282882, 0.334546057, 0.001741270),
    (5, 4, 19.592221, '2019-10-18 22:25:11', 5853, 2927, 1951, 67.402749071, 31.176797164, 0.336943824, 0.001739858),
    (5, 5, 19.591971, '2019-10-18 22:25:32', 6001, 3001, 2000, 67.857062763, 31.393049868, 0.339249587, 0.001748378),
    (5, 6, 19.596998, '2019-10-18 22:25:52', 5944, 2972, 1981, 68.198945594, 31.543161365, 0.340974891, 0.001761047),
    (5, 7, 19.594270, '2019-10-18 22:26:13', 5982, 2991, 1994, 68.598174160, 31.723280107, 0.342889851, 0.001772746),
    (5, 8, 19.594533, '2019-10-18 22:26:34', 6104, 3052, 2035, 68.890087526, 31.853348688, 0.344255009, 0.001775131),
    (5, 9, 19.591898, '2019-10-18 22:26:55', 6046, 3023, 2015, 69.057098011, 31.929919663, 0.345055294, 0.001772742),
    (5, 10, 19.583696, '2019-10-18 22:27:15', 6025, 3013, 2008, 69.344584434, 32.052757935, 0.346398571, 0.001779065),
    (5, 11, 19.579378, '2019-10-18 22:27:36', 6133, 3067, 2044, 69.640012282, 32.182526737, 0.347837279, 0.001785930),
    (5, 12, 19.580238, '2019-10-18 22:27:57', 6025, 3013, 2008, 69.754920875, 32.238054439, 0.348412870, 0.001784815),
    (5, 13, 19.591488, '2019-10-18 22:28:18', 6039, 3020, 2013, 69.748540917, 32.231434697, 0.348291484, 0.001782294),
    (5, 14, 19.578460, '2019-10-18 22:28:39', 6166, 3083, 2055, 69.718267320, 32.218210145, 0.348153443, 0.001783910),
    (5, 15, 19.591686, '2019-10-18 22:28:59', 6077, 3039, 2026, 69.735992237, 32.222379853, 0.348222112, 0.001784986),
    (6, 1, 19.596958, '2019-10-18 23:37:11', 5564, 2782, 1855, 63.849634642, 29.501684587, 0.318604260, 0.001798577),
    (6, 2, 19.589502, '2019-10-18 23:37:32', 5897, 2949, 1966, 66.659994705, 30.824619473, 0.332890031, 0.001759800),
    (6, 3, 19.579921, '2019-10-18 23:37:53', 6005, 3003, 2002, 67.667893849, 31.295264527, 0.337980279, 0.001753848),
    (6, 4, 19.581685, '2019-10-18 23:38:14', 5921, 2961, 1974, 68.050510617, 31.466477392, 0.339877586, 0.001749425),
    (6, 5, 19.578378, '2019-10-18 23:38:34', 6065, 3033, 2022, 68.303938375, 31.581418337, 0.341096608, 0.001751367),
    (6, 6, 19.593754, '2019-10-18 23:38:55', 5881, 2941, 1960, 68.452796192, 31.660475177, 0.341928694, 0.001753649),
    (6, 7, 19.590268, '2019-10-18 23:39:16', 5870, 2935, 1957, 68.487166505, 31.678682287, 0.342087681, 0.001755024),
    (6, 8, 19.594800, '2019-10-18 23:39:37', 5888, 2944, 1963, 67.823148999, 31.347064936, 0.338920322, 0.001732253),
    (6, 9, 19.592139, '2019-10-18 23:39:57', 5887, 2944, 1962, 68.663639646, 31.753587880, 0.342886907, 0.001752896),
    (6, 10, 19.592229, '2019-10-18 23:40:18', 6031, 3016, 2010, 68.576554214, 31.730064986, 0.342593376, 0.001745278),
    (6, 11, 19.581253, '2019-10-18 23:40:39', 5994, 2997, 1998, 68.390299099, 31.649644036, 0.341719509, 0.001732800),
    (6, 12, 19.580871, '2019-10-18 23:41:00', 5867, 2934, 1956, 68.169992326, 31.555783275, 0.340688953, 0.001724422),
    (6, 13, 19.598457, '2019-10-18 23:41:21', 5849, 2925, 1950, 67.924036499, 31.452687264, 0.339495255, 0.001715105),
    (6, 14, 19.598166, '2019-10-18 23:41:41', 5930, 2965, 1977, 67.817486942, 31.419836175, 0.339029345, 0.001705860),
    (6, 15, 19.585469, '2019-10-18 23:42:02', 5905, 2953, 1968, 67.764468964, 31.404624918, 0.338876387, 0.001699211),
    (7, 1, 19.586618, '2019-10-19 00:50:17', 5370, 2685, 1790, 61.989296794, 28.724673365, 0.309758535, 0.001689308),
    (7, 2, 19.598799, '2019-10-19 00:50:38', 5599, 2800, 1866, 64.998484866, 30.141393260, 0.325058332, 0.001650331),
    (7, 3, 19.594850, '2019-10-19 00:50:59', 5764, 2882, 1921, 66.331256937, 30.764944029, 0.331751245, 0.001650890),
    (7, 4, 19.593627, '2019-10-19 00:51:20', 5734, 2867, 1911, 66.933665452, 31.044307089, 0.334752050, 0.001652336),
    (7, 5, 19.595141, '2019-10-19 00:51:41', 5744, 2872, 1915, 67.140878027, 31.147335827, 0.335843752, 0.001650422),
    (7, 6, 19.593650, '2019-10-19 00:52:01', 5867, 2934, 1956, 67.362705264, 31.255563486, 0.336977888, 0.001652110),
    (7, 7, 19.596106, '2019-10-19 00:52:22', 5728, 2864, 1909, 66.559794012, 30.822314926, 0.332841379, 0.001627075),
    (7, 8, 19.593657, '2019-10-19 00:52:43', 5859, 2930, 1953, 67.761075362, 31.426015617, 0.338827856, 0.001661449),
    (7, 9, 19.596630, '2019-10-19 00:53:04', 5700, 2850, 1900, 67.805672404, 31.446799950, 0.339043220, 0.001663747),
    (7, 10, 19.593106, '2019-10-19 00:53:25', 5880, 2940, 1960, 67.846587407, 31.468191948, 0.339244692, 0.001664671),
    (7, 11, 19.595129, '2019-10-19 00:53:45', 5839, 2920, 1946, 67.893453225, 31.494073777, 0.339542836, 0.001666825),
    (7, 12, 19.592154, '2019-10-19 00:54:06', 6002, 3001, 2001, 67.841012744, 31.466918142, 0.339264785, 0.001660628),
    (7, 13, 19.595099, '2019-10-19 00:54:27', 5825, 2913, 1942, 67.892945078, 31.499276482, 0.339526006, 0.001662301),
    (7, 14, 19.581660, '2019-10-19 00:54:48', 5973, 2987, 1991, 67.909138857, 31.501703666, 0.339477646, 0.001663755),
    (7, 15, 19.583264, '2019-10-19 00:55:09', 5927, 2964, 1976, 67.850862206, 31.467354280, 0.339134203, 0.001659737),
    (8, 1, 19.587093, '2019-10-19 02:03:20', 5446, 2723, 1815, 62.486075979, 28.975517788, 0.312138292, 0.001663265),
    (8, 2, 19.584748, '2019-10-19 02:03:41', 5633, 2817, 1878, 65.381441232, 30.339648622, 0.326816741, 0.001629715),
    (8, 3, 19.595703, '2019-10-19 02:04:01', 5751, 2876, 1917, 66.651799091, 30.930065981, 0.333170759, 0.001631074),
    (8, 4, 19.593841, '2019-10-19 02:04:22', 5849, 2925, 1950, 67.262423524, 31.216470232, 0.336308570, 0.001633945),
    (8, 5, 19.592813, '2019-10-19 02:04:43', 5999, 3000, 2000, 67.705818322, 31.425586863, 0.338474492, 0.001640993),
    (8, 6, 19.581531, '2019-10-19 02:05:04', 5856, 2928, 1952, 68.079032932, 31.592609496, 0.340324561, 0.001651402),
    (8, 7, 19.593542, '2019-10-19 02:05:24', 5961, 2981, 1987, 68.366877801, 31.717112772, 0.341671091, 0.001662720),
    (8, 8, 19.593861, '2019-10-19 02:05:45', 5984, 2992, 1995, 68.511317285, 31.780237316, 0.342390233, 0.001667592),
    (8, 9, 19.594977, '2019-10-19 02:06:06', 5784, 2892, 1928, 68.625903700, 31.826189542, 0.342900928, 0.001673610),
    (8, 10, 19.595091, '2019-10-19 02:06:27', 5894, 2947, 1965, 68.683579056, 31.867851076, 0.343274533, 0.001675192),
    (8, 11, 19.580725, '2019-10-19 02:06:48', 5950, 2975, 1983, 68.629627095, 31.841606210, 0.342948310, 0.001672665),
    (8, 12, 19.593889, '2019-10-19 02:07:08', 5892, 2946, 1964, 68.506319608, 31.785805768, 0.342392805, 0.001668743),
    (8, 13, 19.592403, '2019-10-19 02:07:29', 5970, 2985, 1990, 68.388319667, 31.739275868, 0.341819619, 0.001664414),
    (8, 14, 19.594300, '2019-10-19 02:07:50', 5890, 2945, 1963, 68.348608524, 31.728998382, 0.341687445, 0.001658694),
    (8, 15, 19.594272, '2019-10-19 02:08:11', 5872, 2936, 1957, 68.156507453, 31.650092207, 0.340787671, 0.001650434),
    (9, 1, 19.599477, '2019-10-19 03:16:22', 5528, 2764, 1843, 62.142275766, 28.850568159, 0.309872166, 0.001631733),
    (9, 2, 19.605895, '2019-10-19 03:16:42', 5637, 2819, 1879, 65.380989799, 30.377877136, 0.327004075, 0.001619275),
    (9, 3, 19.596376, '2019-10-19 03:17:03', 5637, 2819, 1879, 66.305357929, 30.818010746, 0.331694224, 0.001619980),
    (9, 4, 19.587517, '2019-10-19 03:17:24', 5808, 2904, 1936, 66.607957333, 30.958243634, 0.333200039, 0.001618849),
    (9, 5, 19.596083, '2019-10-19 03:17:45', 5721, 2861, 1907, 66.953420405, 31.119196246, 0.334875850, 0.001626424),
    (9, 6, 19.598345, '2019-10-19 03:18:06', 5677, 2839, 1892, 67.222631860, 31.247033816, 0.336248456, 0.001631628),
    (9, 7, 19.605149, '2019-10-19 03:18:26', 5819, 2910, 1940, 67.375308915, 31.315729179, 0.337026161, 0.001637149),
    (9, 8, 19.583150, '2019-10-19 03:18:47', 5735, 2868, 1912, 67.575715347, 31.410039575, 0.338033704, 0.001648543),
    (9, 9, 19.594309, '2019-10-19 03:19:08', 5834, 2917, 1945, 67.691651601, 31.466254421, 0.338599656, 0.001651268),
    (9, 10, 19.580014, '2019-10-19 03:19:29', 5962, 2981, 1987, 67.803015728, 31.514114277, 0.339105840, 0.001652838),
    (9, 11, 19.583364, '2019-10-19 03:19:49', 5799, 2900, 1933, 67.792914803, 31.513967531, 0.339058936, 0.001653902),
    (9, 12, 19.594103, '2019-10-19 03:20:10', 5899, 2950, 1966, 67.737583058, 31.490011598, 0.338814512, 0.001650811),
    (9, 13, 19.580562, '2019-10-19 03:20:31', 5958, 2979, 1986, 67.729613052, 31.488358170, 0.338853741, 0.001651444),
    (9, 14, 19.594450, '2019-10-19 03:20:52', 5906, 2953, 1969, 67.728214367, 31.488482683, 0.338898320, 0.001651736),
    (9, 15, 19.593415, '2019-10-19 03:21:13', 5753, 2877, 1918, 66.912241536, 31.108389867, 0.335153263, 0.001629801),
    (10, 1, 19.587381, '2019-10-19 04:29:26', 5339, 2670, 1780, 62.651996395, 29.121358068, 0.313375817, 0.001662419),
    (10, 2, 19.598531, '2019-10-19 04:29:46', 5541, 2771, 1847, 65.098873676, 30.286817528, 0.325808251, 0.001631235),
    (10, 3, 19.599926, '2019-10-19 04:30:07', 5677, 2839, 1892, 66.210658897, 30.809198293, 0.331365131, 0.001640516),
    (10, 4, 19.592740, '2019-10-19 04:30:28', 5826, 2913, 1942, 66.737855553, 31.050105978, 0.334059834, 0.001649365),
    (10, 5, 19.596427, '2019-10-19 04:30:49', 5808, 2904, 1936, 67.048891852, 31.199734603, 0.335624178, 0.001651757),
    (10, 6, 19.597070, '2019-10-19 04:31:10', 5721, 2861, 1907, 67.361630387, 31.339188139, 0.337139389, 0.001656560),
    (10, 7, 19.596760, '2019-10-19 04:31:30', 5850, 2925, 1950, 67.695407200, 31.503028644, 0.338859304, 0.001663649),
    (10, 8, 19.592159, '2019-10-19 04:31:51', 6039, 3020, 2013, 67.980030593, 31.632435491, 0.340285005, 0.001666615),
    (10, 9, 19.581394, '2019-10-19 04:32:12', 5920, 2960, 1973, 68.098508268, 31.698339482, 0.340952031, 0.001665866),
    (10, 10, 19.594576, '2019-10-19 04:32:33', 5798, 2899, 1933, 68.156671765, 31.714668802, 0.341175338, 0.001667138),
    (10, 11, 19.595313, '2019-10-19 04:32:54', 5897, 2949, 1966, 68.193906237, 31.738886836, 0.341421213, 0.001669983),
    (10, 12, 19.599212, '2019-10-19 04:33:15', 5830, 2915, 1943, 68.243976217, 31.766893022, 0.341711830, 0.001671981),
    (10, 13, 19.594698, '2019-10-19 04:33:35', 5934, 2967, 1978, 68.145835185, 31.729985182, 0.341242106, 0.001670470),
    (10, 14, 19.580583, '2019-10-19 04:33:56', 6033, 3017, 2011, 67.960483271, 31.645418705, 0.340305836, 0.001669761),
    (10, 15, 19.594899, '2019-10-19 04:34:17', 5769, 2885, 1923, 67.814844067, 31.578139754, 0.339623891, 0.001666217),
    (11, 1, 19.597258, '2019-10-19 05:42:32', 5448, 2724, 1816, 62.760236580, 29.211701289, 0.314165587, 0.001670118),
    (11, 2, 19.582210, '2019-10-19 05:42:53', 5743, 2872, 1914, 65.263397645, 30.398233963, 0.326863793, 0.001637557),
    (11, 3, 19.583193, '2019-10-19 05:43:14', 5643, 2822, 1881, 66.359217386, 30.915362609, 0.332423047, 0.001646119),
    (11, 4, 19.585939, '2019-10-19 05:43:35', 5912, 2956, 1971, 66.947252935, 31.184936576, 0.335307519, 0.001654117),
    (11, 5, 19.593771, '2019-10-19 05:43:55', 5831, 2916, 1944, 67.209076078, 31.316511794, 0.336698673, 0.001657254),
    (11, 6, 19.594728, '2019-10-19 05:44:16', 5747, 2874, 1916, 67.366337231, 31.392651864, 0.337551814, 0.001656310),
    (11, 7, 19.583754, '2019-10-19 05:44:37', 5746, 2873, 1915, 67.400726602, 31.415961523, 0.337759771, 0.001653986),
    (11, 8, 19.583932, '2019-10-19 05:44:58', 5819, 2910, 1940, 67.378768145, 31.409598753, 0.337689292, 0.001649779),
    (11, 9, 19.593467, '2019-10-19 05:45:19', 5818, 2909, 1939, 67.322404279, 31.396668490, 0.337478657, 0.001643515),
    (11, 10, 19.594283, '2019-10-19 05:45:39', 5878, 2939, 1959, 67.287235945, 31.386885375, 0.337416088, 0.001638644),
    (11, 11, 19.597261, '2019-10-19 05:46:00', 5792, 2896, 1931, 67.191968704, 31.339545180, 0.336887592, 0.001632240),
    (11, 12, 19.582687, '2019-10-19 05:46:21', 5814, 2907, 1938, 67.201271337, 31.344909826, 0.336976998, 0.001630628),
    (11, 13, 19.595128, '2019-10-19 05:46:42', 5734, 2867, 1911, 67.247275670, 31.368227780, 0.337197373, 0.001634557),
    (11, 14, 19.596235, '2019-10-19 05:47:03', 5881, 2941, 1960, 67.257754002, 31.380739150, 0.337362501, 0.001636924),
    (11, 15, 19.582637, '2019-10-19 05:47:23', 5769, 2885, 1923, 67.172846670, 31.349534931, 0.336973775, 0.001630188),
    (12, 1, 19.602176, '2019-10-19 06:55:37', 5292, 2646, 1764, 61.617218660, 28.644258890, 0.308868279, 0.001611646),
    (12, 2, 19.596424, '2019-10-19 06:55:57', 5587, 2794, 1862, 64.722661400, 30.220887333, 0.324852876, 0.001594196),
    (12, 3, 19.582450, '2019-10-19 06:56:18', 5820, 2910, 1940, 65.630884287, 30.649207811, 0.329377849, 0.001591158),
    (12, 4, 19.595602, '2019-10-19 06:56:39', 5754, 2877, 1918, 65.942494627, 30.809841709, 0.331059251, 0.001590589),
    (12, 5, 19.594290, '2019-10-19 06:57:00', 5841, 2921, 1947, 66.051341590, 30.872489582, 0.331736762, 0.001585633),
    (12, 6, 19.598175, '2019-10-19 06:57:21', 5686, 2843, 1895, 66.176792737, 30.935133718, 0.332352037, 0.001582847),
    (12, 7, 19.596550, '2019-10-19 06:57:41', 5663, 2832, 1888, 66.398967675, 31.040683717, 0.333501285, 0.001584036),
    (12, 8, 19.580278, '2019-10-19 06:58:02', 5880, 2940, 1960, 66.551248373, 31.111242393, 0.334278037, 0.001584048),
    (12, 9, 19.582348, '2019-10-19 06:58:23', 5780, 2890, 1927, 66.676862775, 31.176271031, 0.334929464, 0.001585202),
    (12, 10, 19.587715, '2019-10-19 06:58:44', 5691, 2846, 1897, 66.770649716, 31.225342295, 0.335419995, 0.001587675),
    (12, 11, 19.583032, '2019-10-19 06:59:05', 5837, 2919, 1946, 66.800350099, 31.240133148, 0.335597410, 0.001587710),
    (12, 12, 19.600497, '2019-10-19 06:59:25', 5691, 2846, 1897, 66.844422394, 31.272980235, 0.335908402, 0.001587521),
    (12, 13, 19.581977, '2019-10-19 06:59:46', 5904, 2952, 1968, 66.814173288, 31.259796806, 0.335767201, 0.001583818),
    (12, 14, 19.595963, '2019-10-19 07:00:07', 5693, 2847, 1898, 66.836970829, 31.271969810, 0.335875050, 0.001581236),
    (12, 15, 19.582679, '2019-10-19 07:00:28', 5902, 2951, 1967, 66.832809964, 31.275779932, 0.335929781, 0.001579170),
    (13, 1, 19.599176, '2019-10-19 08:08:41', 5391, 2696, 1797, 61.862813253, 28.913821385, 0.310691767, 0.001573740),
    (13, 2, 19.593439, '2019-10-19 08:09:02', 5647, 2824, 1882, 64.163177898, 30.013903659, 0.322465441, 0.001537834),
    (13, 3, 19.595676, '2019-10-19 08:09:23', 5556, 2778, 1852, 64.303515980, 30.017407369, 0.323187894, 0.001522384),
    (13, 4, 19.592178, '2019-10-19 08:09:43', 5909, 2955, 1970, 65.531844617, 30.670439192, 0.329381854, 0.001550694),
    (13, 5, 19.597344, '2019-10-19 08:10:04', 5690, 2845, 1897, 65.798331202, 30.804390587, 0.330797582, 0.001559284),
    (13, 6, 19.588578, '2019-10-19 08:10:25', 5638, 2819, 1879, 66.013586305, 30.910310487, 0.331887829, 0.001562947),
    (13, 7, 19.595324, '2019-10-19 08:10:46', 5839, 2920, 1946, 66.222683289, 31.006551402, 0.332984825, 0.001565396),
    (13, 8, 19.582803, '2019-10-19 08:11:06', 5754, 2877, 1918, 66.254123038, 31.030212975, 0.333126723, 0.001561787),
    (13, 9, 19.597711, '2019-10-19 08:11:27', 5929, 2965, 1976, 66.233574819, 31.031848873, 0.333075313, 0.001557459),
    (13, 10, 19.595312, '2019-10-19 08:11:48', 5605, 2803, 1868, 66.237523424, 31.026881426, 0.333104446, 0.001557048),
    (13, 11, 19.594864, '2019-10-19 08:12:09', 5777, 2889, 1926, 66.292015459, 31.054844894, 0.333354489, 0.001559799),
    (13, 12, 19.584260, '2019-10-19 08:12:30', 5647, 2824, 1882, 66.397972045, 31.113987284, 0.333945928, 0.001565495),
    (13, 13, 19.596382, '2019-10-19 08:12:50', 5823, 2912, 1941, 66.458222931, 31.134182096, 0.334198666, 0.001570098),
    (13, 14, 19.594156, '2019-10-19 08:13:11', 5755, 2878, 1918, 66.570520761, 31.186927672, 0.334830263, 0.001572921),
    (13, 15, 19.593487, '2019-10-19 08:13:32', 5795, 2898, 1932, 66.680897719, 31.242197276, 0.335393435, 0.001573741),
    (14, 1, 19.587145, '2019-10-19 09:21:43', 5348, 2674, 1783, 61.679462270, 28.856791378, 0.310059057, 0.001570077),
    (14, 2, 19.591641, '2019-10-19 09:22:04', 5621, 2811, 1874, 64.041070975, 29.991451574, 0.322138320, 0.001546230),
    (14, 3, 19.597110, '2019-10-19 09:22:25', 5694, 2847, 1898, 64.946952790, 30.416079723, 0.326657562, 0.001554338),
    (14, 4, 19.596524, '2019-10-19 09:22:45', 5667, 2834, 1889, 65.614120912, 30.733680771, 0.329990391, 0.001565014),
    (14, 5, 19.597117, '2019-10-19 09:23:06', 5551, 2776, 1850, 65.908703642, 30.875115940, 0.331514793, 0.001570896),
    (14, 6, 19.582897, '2019-10-19 09:23:27', 5741, 2871, 1914, 66.088251427, 30.970113322, 0.332477616, 0.001571482),
    (14, 7, 19.597198, '2019-10-19 09:23:48', 5861, 2931, 1954, 66.167753186, 31.014752833, 0.332933520, 0.001573012),
    (14, 8, 19.582342, '2019-10-19 09:24:09', 5706, 2853, 1902, 66.245269927, 31.044682460, 0.333286761, 0.001573518),
    (14, 9, 19.581396, '2019-10-19 09:24:29', 5838, 2919, 1946, 66.387285197, 31.120542905, 0.334040333, 0.001575684),
    (14, 10, 19.597382, '2019-10-19 09:24:50', 5751, 2876, 1917, 66.497684415, 31.175910926, 0.334639799, 0.001579330),
    (14, 11, 19.590047, '2019-10-19 09:25:11', 5795, 2898, 1932, 66.573193551, 31.218551735, 0.335014996, 0.001579869),
    (14, 12, 19.582571, '2019-10-19 09:25:32', 5759, 2880, 1920, 66.643419079, 31.259458659, 0.335456726, 0.001578836),
    (14, 13, 19.595697, '2019-10-19 09:25:52', 5665, 2833, 1888, 66.746125979, 31.309240354, 0.335964332, 0.001581533),
    (14, 14, 19.594245, '2019-10-19 09:26:13', 5784, 2892, 1928, 66.886432777, 31.376790376, 0.336693062, 0.001583187),
    (14, 15, 19.592725, '2019-10-19 09:26:34', 5780, 2890, 1927, 66.990857831, 31.434864459, 0.337297517, 0.001583096),
    (15, 1, 19.592396, '2019-10-19 10:34:45', 5346, 2673, 1782, 61.407880935, 28.778546757, 0.309116748, 0.001562707),
    (15, 2, 19.594679, '2019-10-19 10:35:06', 5681, 2841, 1894, 63.762874819, 29.915135578, 0.321143613, 0.001534919),
    (15, 3, 19.596538, '2019-10-19 10:35:27', 5633, 2817, 1878, 64.567766633, 30.311390286, 0.325285753, 0.001534548),
    (15, 4, 19.604715, '2019-10-19 10:35:48', 5608, 2804, 1869, 65.030838602, 30.526002324, 0.327556837, 0.001534062),
    (15, 5, 19.584372, '2019-10-19 10:36:08', 5616, 2808, 1872, 65.300389801, 30.660079706, 0.328987000, 0.001534083),
    (15, 6, 19.587901, '2019-10-19 10:36:29', 5655, 2828, 1885, 65.497085155, 30.755316198, 0.329927701, 0.001537517),
    (15, 7, 19.584817, '2019-10-19 10:36:50', 5786, 2893, 1929, 65.712793569, 30.855451265, 0.331039778, 0.001544995),
    (15, 8, 19.596553, '2019-10-19 10:37:11', 5705, 2853, 1902, 65.960513025, 30.972860902, 0.332370933, 0.001551703),
    (15, 9, 19.583139, '2019-10-19 10:37:32', 5677, 2839, 1892, 66.213867562, 31.099739296, 0.333584148, 0.001555066),
    (15, 10, 19.583621, '2019-10-19 10:37:52', 5780, 2890, 1927, 66.340401287, 31.157540994, 0.334210633, 0.001554450),
    (15, 11, 19.585552, '2019-10-19 10:38:13', 5709, 2855, 1903, 66.327101202, 31.161659386, 0.334212838, 0.001552049),
    (15, 12, 19.595190, '2019-10-19 10:38:34', 5759, 2880, 1920, 66.338369875, 31.172876247, 0.334338969, 0.001548041),
    (15, 13, 19.594263, '2019-10-19 10:38:55', 5867, 2934, 1956, 66.407557528, 31.211202806, 0.334693697, 0.001543761),
    (15, 14, 19.594641, '2019-10-19 10:39:15', 5769, 2885, 1923, 66.538349531, 31.275004340, 0.335423142, 0.001541491),
    (15, 15, 19.594217, '2019-10-19 10:39:36', 5732, 2866, 1911, 66.718724030, 31.364484759, 0.336326599, 0.001541111),
    (16, 1, 19.585374, '2019-10-19 11:47:47', 5421, 2711, 1807, 61.367167418, 28.809575775, 0.309255930, 0.001520545),
    (16, 2, 19.583692, '2019-10-19 11:48:08', 5655, 2828, 1885, 63.663545240, 29.915782362, 0.320972384, 0.001493021),
    (16, 3, 19.583487, '2019-10-19 11:48:29', 5624, 2812, 1875, 64.585908659, 30.360552550, 0.325698098, 0.001495268),
    (16, 4, 19.596508, '2019-10-19 11:48:49', 5640, 2820, 1880, 65.162563575, 30.633432971, 0.328513868, 0.001498687),
    (16, 5, 19.584477, '2019-10-19 11:49:10', 5698, 2849, 1899, 65.554321650, 30.818765141, 0.330529823, 0.001502346),
    (16, 6, 19.595826, '2019-10-19 11:49:31', 5748, 2874, 1916, 65.832327497, 30.955948254, 0.331941871, 0.001508599),
    (16, 7, 19.584799, '2019-10-19 11:49:52', 5735, 2868, 1912, 66.029324079, 31.047975937, 0.332939004, 0.001511639),
    (16, 8, 19.595465, '2019-10-19 11:50:13', 5737, 2869, 1912, 66.233636558, 31.153402491, 0.334025522, 0.001515230),
    (16, 9, 19.593424, '2019-10-19 11:50:33', 5896, 2948, 1965, 66.400406340, 31.236734929, 0.334876485, 0.001519845),
    (16, 10, 19.581666, '2019-10-19 11:50:54', 5998, 2999, 1999, 66.535690416, 31.306971024, 0.335548867, 0.001519931),
    (16, 11, 19.584008, '2019-10-19 11:51:15', 5650, 2825, 1883, 66.600626307, 31.341768206, 0.335943698, 0.001517461),
    (16, 12, 19.588813, '2019-10-19 11:51:36', 5764, 2882, 1921, 66.634779627, 31.368363506, 0.336168937, 0.001513262),
    (16, 13, 19.582322, '2019-10-19 11:51:57', 5727, 2864, 1909, 66.706467987, 31.406520178, 0.336521652, 0.001511485),
    (16, 14, 19.581681, '2019-10-19 11:52:17', 5817, 2909, 1939, 66.738686214, 31.438038885, 0.336830420, 0.001509915),
    (16, 15, 19.588483, '2019-10-19 11:52:38', 5752, 2876, 1917, 66.702066893, 31.418616568, 0.336610584, 0.001504671),
    (17, 1, 19.603202, '2019-10-19 13:00:50', 5230, 2615, 1743, 60.982045668, 28.681830235, 0.307725217, 0.001473431),
    (17, 2, 19.597671, '2019-10-19 13:01:11', 5535, 2768, 1845, 63.291626122, 29.808348635, 0.319548877, 0.001439917),
    (17, 3, 19.583259, '2019-10-19 13:01:31', 5610, 2805, 1870, 64.131580356, 30.222932081, 0.323843168, 0.001436552),
    (17, 4, 19.584725, '2019-10-19 13:01:52', 5788, 2894, 1929, 64.618678843, 30.462177781, 0.326384135, 0.001439134),
    (17, 5, 19.594159, '2019-10-19 13:02:13', 5769, 2885, 1923, 64.974626785, 30.633186435, 0.328113925, 0.001442065),
    (17, 6, 19.598643, '2019-10-19 13:02:34', 5669, 2835, 1890, 65.239836830, 30.763564709, 0.329520928, 0.001441825),
    (17, 7, 19.596376, '2019-10-19 13:02:55', 5824, 2912, 1941, 65.356611080, 30.826634790, 0.330144958, 0.001441927),
    (17, 8, 19.592765, '2019-10-19 13:03:15', 5931, 2966, 1977, 65.439025426, 30.869795618, 0.330533616, 0.001440214),
    (17, 9, 19.582638, '2019-10-19 13:03:36', 5734, 2867, 1911, 65.553347429, 30.924513979, 0.331143593, 0.001439585),
    (17, 10, 19.596431, '2019-10-19 13:03:57', 5650, 2825, 1883, 65.661788812, 30.981525218, 0.331736156, 0.001438570),
    (17, 11, 19.595256, '2019-10-19 13:04:18', 5763, 2882, 1921, 65.773213108, 31.034370103, 0.332280710, 0.001437340),
    (17, 12, 19.583494, '2019-10-19 13:04:38', 5669, 2835, 1890, 65.973278374, 31.131445979, 0.333336557, 0.001438649),
    (17, 13, 19.583144, '2019-10-19 13:04:59', 5757, 2879, 1919, 66.142360553, 31.213196259, 0.334151387, 0.001438761),
    (17, 14, 19.594617, '2019-10-19 13:05:20', 5770, 2885, 1923, 66.323576348, 31.299182039, 0.335040795, 0.001441654),
    (17, 15, 19.593693, '2019-10-19 13:05:41', 5756, 2878, 1919, 66.435421919, 31.352260527, 0.335659376, 0.001442442),
    (18, 1, 19.585921, '2019-10-19 14:13:53', 5385, 2693, 1795, 60.976188753, 28.724524474, 0.308072959, 0.001413400),
    (18, 2, 19.589160, '2019-10-19 14:14:14', 5398, 2699, 1799, 63.429885100, 29.911388523, 0.320614574, 0.001398029),
    (18, 3, 19.598842, '2019-10-19 14:14:35', 5565, 2783, 1855, 64.406878304, 30.379555293, 0.325529073, 0.001405727),
    (18, 4, 19.583379, '2019-10-19 14:14:56', 5724, 2862, 1908, 64.874061019, 30.609911389, 0.327900744, 0.001411312),
    (18, 5, 19.596427, '2019-10-19 14:15:16', 5753, 2877, 1918, 65.236418588, 30.790476324, 0.329778724, 0.001412867),
    (18, 6, 19.596772, '2019-10-19 14:15:37', 5571, 2786, 1857, 65.519905299, 30.930312937, 0.331240494, 0.001409719),
    (18, 7, 19.594213, '2019-10-19 14:15:58', 5767, 2884, 1922, 65.731303288, 31.040364868, 0.332335694, 0.001408419),
    (18, 8, 19.584153, '2019-10-19 14:16:19', 5634, 2817, 1878, 65.909267018, 31.126106206, 0.333204809, 0.001410746),
    (18, 9, 19.305209, '2019-10-19 14:16:39', 5668, 2834, 1889, 66.046058253, 31.194872389, 0.333903382, 0.001409757),
    (18, 10, 17.489088, '2019-10-19 14:17:00', 5040, 2520, 1680, 66.160235594, 31.085153330, 0.333166929, 0.001409491),
    (18, 11, 19.597828, '2019-10-19 14:17:21', 5808, 2904, 1936, 66.184499343, 31.267454510, 0.334553586, 0.001406912),
    (18, 12, 19.583058, '2019-10-19 14:17:42', 5659, 2830, 1886, 66.161852168, 31.258985434, 0.334514395, 0.001404953),
    (18, 13, 19.594359, '2019-10-19 14:18:03', 5757, 2879, 1919, 66.261679099, 31.305974729, 0.334974278, 0.001404453),
    (18, 14, 19.596149, '2019-10-19 14:18:23', 5645, 2823, 1882, 66.428397243, 31.383581876, 0.335843278, 0.001406906),
    (18, 15, 19.580725, '2019-10-19 14:18:44', 5886, 2943, 1962, 66.531543393, 31.434164708, 0.336331599, 0.001407997),
    (19, 1, 19.586767, '2019-10-19 15:27:06', 5319, 2660, 1773, 61.135798807, 28.821254216, 0.308999029, 0.001381955),
    (19, 2, 19.584435, '2019-10-19 15:27:26', 5617, 2809, 1872, 63.499565497, 29.977142606, 0.321123063, 0.001368682),
    (19, 3, 19.594448, '2019-10-19 15:27:47', 5701, 2851, 1900, 64.447189857, 30.432625593, 0.325892630, 0.001374555),
    (19, 4, 19.585794, '2019-10-19 15:28:08', 5532, 2766, 1844, 64.905759818, 30.662952880, 0.328281954, 0.001378624),
    (19, 5, 19.591388, '2019-10-19 15:28:29', 5665, 2833, 1888, 65.217314996, 30.806483700, 0.329774925, 0.001383306),
    (19, 6, 19.595478, '2019-10-19 15:28:50', 5758, 2879, 1919, 65.486787533, 30.932514480, 0.331166477, 0.001387593),
    (19, 7, 19.582569, '2019-10-19 15:29:10', 5813, 2907, 1938, 65.701567869, 31.052441015, 0.332315191, 0.001392359),
    (19, 8, 19.594260, '2019-10-19 15:29:31', 5772, 2886, 1924, 65.861387365, 31.123681966, 0.333110632, 0.001393370),
    (19, 9, 19.597472, '2019-10-19 15:29:52', 5839, 2920, 1946, 65.940061330, 31.168062264, 0.333568223, 0.001392069),
    (19, 10, 19.596130, '2019-10-19 15:30:13', 5766, 2883, 1922, 66.013379887, 31.215058703, 0.334001403, 0.001389389),
    (19, 11, 19.595806, '2019-10-19 15:30:33', 5684, 2842, 1895, 66.060811114, 31.235325429, 0.334190651, 0.001387554),
    (19, 12, 19.596151, '2019-10-19 15:30:54', 5676, 2838, 1892, 65.980445333, 31.199154692, 0.333793351, 0.001384315),
    (19, 13, 19.581804, '2019-10-19 15:31:15', 5734, 2867, 1911, 65.963260545, 31.196902882, 0.333737675, 0.001379780),
    (19, 14, 19.584919, '2019-10-19 15:31:36', 5783, 2892, 1928, 65.946201575, 31.195245550, 0.333737576, 0.001376546),
    (19, 15, 19.595697, '2019-10-19 15:31:57', 5683, 2842, 1894, 65.833986951, 31.150838231, 0.333232099, 0.001370921),
    (20, 1, 19.599998, '2019-10-19 16:40:06', 5211, 2606, 1737, 60.364189853, 28.506482510, 0.305560848, 0.001331444),
    (20, 2, 19.595173, '2019-10-19 16:40:27', 5570, 2785, 1857, 62.327848057, 29.480394709, 0.315658639, 0.001303380),
    (20, 3, 19.595269, '2019-10-19 16:40:48', 5599, 2800, 1866, 63.170908560, 29.896064493, 0.319935163, 0.001304634),
    (20, 4, 19.591750, '2019-10-19 16:41:08', 5544, 2772, 1848, 63.676784871, 30.138744242, 0.322468806, 0.001304548),
    (20, 5, 19.597058, '2019-10-19 16:41:29', 5524, 2762, 1841, 64.029232776, 30.310583598, 0.324286136, 0.001304861),
    (20, 6, 19.584075, '2019-10-19 16:41:50', 5566, 2783, 1855, 64.295259541, 30.444809533, 0.325588726, 0.001307065),
    (20, 7, 19.595711, '2019-10-19 16:42:11', 5630, 2815, 1877, 64.481092715, 30.535273051, 0.326484466, 0.001308906),
    (20, 8, 19.583021, '2019-10-19 16:42:32', 5725, 2863, 1908, 64.590718449, 30.581876418, 0.327024866, 0.001308499),
    (20, 9, 19.596047, '2019-10-19 16:42:52', 5574, 2787, 1858, 64.619195422, 30.593025000, 0.327188182, 0.001308312),
    (20, 10, 19.583387, '2019-10-19 16:43:13', 5673, 2837, 1891, 64.570920372, 30.573745756, 0.326932442, 0.001308199),
    (20, 11, 19.591192, '2019-10-19 16:43:34', 5591, 2796, 1864, 64.520615264, 30.544889393, 0.326685005, 0.001306847),
    (20, 12, 19.597294, '2019-10-19 16:43:55', 5591, 2796, 1864, 64.490665966, 30.536473226, 0.326518245, 0.001303600),
    (20, 13, 19.585536, '2019-10-19 16:44:16', 5631, 2816, 1877, 64.481405707, 30.539797418, 0.326512530, 0.001301871),
    (20, 14, 19.594082, '2019-10-19 16:44:36', 5677, 2839, 1892, 64.437577816, 30.515363395, 0.326288135, 0.001300646),
    (20, 15, 19.597683, '2019-10-19 16:44:57', 5572, 2786, 1857, 64.436620564, 30.522394333, 0.326334687, 0.001298461),
    (21, 1, 19.603449, '2019-10-19 17:53:10', 5155, 2578, 1718, 59.123132373, 27.959757979, 0.299425851, 0.001274106),
    (21, 2, 19.600177, '2019-10-19 17:53:31', 5375, 2688, 1792, 60.998426933, 28.888411777, 0.309115161, 0.001248427),
    (21, 3, 19.588139, '2019-10-19 17:53:52', 5314, 2657, 1771, 61.803133631, 29.286808078, 0.313149756, 0.001250344),
    (21, 4, 19.597361, '2019-10-19 17:54:13', 5496, 2748, 1832, 62.295149219, 29.521589030, 0.315658521, 0.001255997),
    (21, 5, 19.597078, '2019-10-19 17:54:34', 5504, 2752, 1835, 62.624161847, 29.678417516, 0.317284251, 0.001257709),
    (21, 6, 19.597175, '2019-10-19 17:54:54', 5524, 2762, 1841, 62.802550112, 29.761700564, 0.318176683, 0.001258071),
    (21, 7, 19.596954, '2019-10-19 17:55:15', 5437, 2719, 1812, 62.135605829, 29.437343892, 0.313814295, 0.001240771),
    (21, 8, 19.597859, '2019-10-19 17:55:36', 5528, 2764, 1843, 62.999148438, 29.857506001, 0.319129432, 0.001260256),
    (21, 9, 19.584559, '2019-10-19 17:55:57', 5535, 2768, 1845, 63.089860139, 29.898829465, 0.319540188, 0.001264330),
    (21, 10, 19.585835, '2019-10-19 17:56:18', 5473, 2737, 1824, 63.124029841, 29.916226439, 0.319764906, 0.001269088),
    (21, 11, 19.583169, '2019-10-19 17:56:38', 5621, 2811, 1874, 63.105484419, 29.910098554, 0.319706923, 0.001273235),
    (21, 12, 19.597146, '2019-10-19 17:56:59', 5552, 2776, 1851, 63.087276627, 29.900948682, 0.319574297, 0.001271646),
    (21, 13, 19.592344, '2019-10-19 17:57:20', 5489, 2745, 1830, 63.018877741, 29.872877336, 0.319255204, 0.001271404),
    (21, 14, 19.597808, '2019-10-19 17:57:41', 5478, 2739, 1826, 62.939408244, 29.834060895, 0.318869011, 0.001268602),
    (21, 15, 19.601330, '2019-10-19 17:58:02', 5396, 2698, 1799, 62.796439527, 29.774606126, 0.318183562, 0.001261873),
    (22, 1, 19.600921, '2019-10-19 19:06:12', 4923, 2462, 1641, 58.003387484, 27.466511248, 0.293961253, 0.001246900),
    (22, 2, 19.587381, '2019-10-19 19:06:33', 5218, 2609, 1739, 59.518958854, 28.235838967, 0.301862793, 0.001207804),
    (22, 3, 19.588461, '2019-10-19 19:06:54', 5227, 2614, 1742, 60.218529051, 28.580654627, 0.305389010, 0.001204332),
    (22, 4, 19.593844, '2019-10-19 19:07:14', 5283, 2642, 1761, 60.555102470, 28.748598490, 0.307107000, 0.001203447),
    (22, 5, 19.588339, '2019-10-19 19:07:35', 5318, 2659, 1773, 60.809664985, 28.869831663, 0.308424865, 0.001205468),
    (22, 6, 19.598777, '2019-10-19 19:07:56', 5421, 2711, 1807, 60.997390021, 28.957577816, 0.309328124, 0.001208943),
    (22, 7, 19.600323, '2019-10-19 19:08:17', 5280, 2640, 1760, 61.066439334, 28.985541255, 0.309640905, 0.001211944),
    (22, 8, 19.587430, '2019-10-19 19:08:37', 5204, 2602, 1735, 61.070825218, 28.997838476, 0.309726773, 0.001212238),
    (22, 9, 19.586865, '2019-10-19 19:08:58', 5320, 2660, 1773, 61.017862072, 28.974120266, 0.309450334, 0.001207842),
    (22, 10, 19.601831, '2019-10-19 19:09:19', 5298, 2649, 1766, 61.022137871, 28.980345520, 0.309461938, 0.001204029),
    (22, 11, 19.586983, '2019-10-19 19:09:40', 5256, 2628, 1752, 61.022598702, 28.980633287, 0.309471440, 0.001200207),
    (22, 12, 19.587624, '2019-10-19 19:10:01', 5381, 2691, 1794, 61.016306786, 28.981775117, 0.309481709, 0.001196195),
    (22, 13, 19.599609, '2019-10-19 19:10:21', 5278, 2639, 1759, 60.920198877, 28.944150630, 0.309023629, 0.001191580),
    (22, 14, 19.598535, '2019-10-19 19:10:42', 5291, 2646, 1764, 60.805070022, 28.884359563, 0.308452295, 0.001186436),
    (22, 15, 19.587273, '2019-10-19 19:11:03', 5342, 2671, 1781, 60.820643353, 28.896270830, 0.308501424, 0.001183596),
)
