Skip to content

Instantly share code, notes, and snippets.

@parthi2929
Last active February 14, 2018 11:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save parthi2929/36e6898cff7be45ccdd008ec750e70e9 to your computer and use it in GitHub Desktop.
Save parthi2929/36e6898cff7be45ccdd008ec750e70e9 to your computer and use it in GitHub Desktop.
{ "_id" : 1, "__v" : 0, "data" : [ [ 1518449823, 569998, 569998, 569998, 569998, 36 ], [ 1518449853, 569998, 569998, 569998, 569998, 36 ], [ 1518449933, 569998, 569998, 569998, 569998, 36 ], [ 1518449973, 569998, 569998, 569998, 569998, 36 ], [ 1518450063, 569998, 569998, 569998, 569998, 36 ], [ 1518450093, 569998, 569998, 569998, 569998, 36 ], [ 1518450183, 569998, 569998, 569998, 569998, 36 ], [ 1518450213, 569998, 569998, 569998, 569998, 36 ], [ 1518450303, 569998, 569998, 563050, 563050, 36 ], [ 1518450333, 563050, 563050, 563050, 563050, 36 ], [ 1518450423, 563050, 563050, 563050, 563050, 36 ], [ 1518450453, 563050, 563050, 563050, 563050, 36 ], [ 1518450543, 563050, 563050, 563050, 563050, 36 ], [ 1518450573, 563050, 563050, 563050, 563050, 36 ], [ 1518450663, 563050, 568999, 563050, 568999, 36 ], [ 1518450693, 568999, 568999, 568999, 568999, 36 ], [ 1518450783, 568999, 568999, 568999, 568999, 36 ], [ 1518450813, 568999, 568999, 568999, 568999, 36 ], [ 1518450903, 568999, 568999, 563351, 563351, 36 ], [ 1518450933, 563351, 563351, 563351, 563351, 36 ], [ 1518451023, 563351, 567900, 563351, 567900, 36 ], [ 1518451053, 567900, 567900, 567900, 567900, 36 ], [ 1518451143, 567900, 567900, 567900, 567900, 36 ], [ 1518451173, 567900, 567900, 567900, 567900, 36 ], [ 1518451263, 567900, 567900, 567900, 567900, 36 ], [ 1518451293, 567900, 567900, 567900, 567900, 36 ], [ 1518451383, 567900, 567900, 567900, 567900, 36 ], [ 1518451413, 567900, 567900, 567900, 567900, 36 ], [ 1518451503, 567900, 567900, 565000, 566900, 36 ], [ 1518451533, 566900, 566900, 566900, 566900, 36 ], [ 1518451623, 566900, 566900, 566900, 566900, 36 ], [ 1518451653, 566900, 566900, 566900, 566900, 36 ], [ 1518451743, 566900, 566900, 565000, 565000, 36 ], [ 1518451773, 565000, 565000, 565000, 565000, 36 ], [ 1518451863, 565000, 565000, 565000, 565000, 36 ], [ 1518451893, 565000, 565000, 565000, 565000, 36 ], [ 1518451983, 565000, 567900, 565000, 567900, 36 ], [ 1518452013, 567900, 567900, 567900, 567900, 36 ], [ 1518452103, 567900, 567900, 567900, 567900, 36 ], [ 1518452133, 567900, 567900, 567900, 567900, 36 ], [ 1518452223, 567900, 567900, 567900, 567900, 35 ], [ 1518452253, 567900, 567900, 567900, 567900, 35 ], [ 1518452343, 567900, 567900, 567900, 567900, 35 ], [ 1518452373, 567900, 567900, 567900, 567900, 35 ], [ 1518452463, 567900, 569000, 567900, 569000, 35 ], [ 1518452493, 569000, 569000, 569000, 569000, 35 ], [ 1518452563, 569000, 569000, 569000, 569000, 35 ], [ 1518452613, 569000, 569000, 569000, 569000, 35 ], [ 1518452673, 569000, 569000, 569000, 569000, 35 ], [ 1518452743, 569000, 569000, 569000, 569000, 35 ], [ 1518452793, 569000, 569000, 569000, 569000, 35 ], [ 1518452873, 569000, 569000, 569000, 569000, 35 ], [ 1518452913, 569000, 569000, 569000, 569000, 35 ], [ 1518453003, 569000, 569000, 568999, 568999, 35 ], [ 1518453033, 568999, 568999, 568999, 568999, 35 ], [ 1518453103, 568999, 568999, 568999, 568999, 35 ], [ 1518453153, 568999, 568999, 568999, 568999, 35 ], [ 1518453223, 568999, 568999, 568999, 568999, 35 ], [ 1518453273, 568999, 568999, 568999, 568999, 35 ], [ 1518453343, 568999, 568999, 568999, 568999, 35 ], [ 1518453393, 568999, 568999, 568999, 568999, 35 ], [ 1518453463, 568999, 568999, 568999, 568999, 35 ], [ 1518453513, 568999, 568999, 568999, 568999, 35 ], [ 1518453603, 568999, 568999, 563000, 563000, 35 ], [ 1518453633, 563000, 563000, 563000, 563000, 35 ], [ 1518453723, 563000, 563005, 563000, 563005, 35 ], [ 1518453753, 563005, 563005, 563005, 563005, 35 ], [ 1518453843, 563005, 563005, 563005, 563005, 35 ], [ 1518453873, 563005, 563005, 563005, 563005, 35 ], [ 1518453973, 563005, 563005, 563005, 563005, 36 ], [ 1518453996, 563005, 563005, 563005, 563005, 0 ], [ 1518454086, 563005, 564000, 563005, 564000, 36 ], [ 1518454116, 564000, 564000, 564000, 564000, 36 ], [ 1518604024, 564000, 564000, 564000, 564000, 0 ], [ 1518604104, 564000, 574000, 564000, 574000, 34 ], [ 1518604144, 574000, 574000, 574000, 574000, 34 ], [ 1518604204, 574000, 574000, 574000, 574000, 34 ], [ 1518604294, 574000, 574000, 574000, 574000, 34 ], [ 1518604324, 574000, 574000, 574000, 574000, 34 ], [ 1518604404, 574000, 574000, 574000, 574000, 34 ], [ 1518604444, 574000, 574000, 574000, 574000, 34 ], [ 1518604524, 574000, 574000, 574000, 574000, 34 ], [ 1518604564, 574000, 574000, 574000, 574000, 34 ], [ 1518604624, 574000, 574000, 574000, 574000, 34 ], [ 1518604704, 574000, 574500, 574000, 574500, 34 ], [ 1518604744, 574500, 574500, 574500, 574500, 34 ], [ 1518604834, 574500, 575000, 574500, 575000, 34 ], [ 1518604874, 575000, 575000, 575000, 575000, 34 ], [ 1518604924, 575000, 575000, 575000, 575000, 34 ], [ 1518604987, 575000, 575000, 575000, 575000, 34 ], [ 1518605017, 575000, 575000, 575000, 575000, 34 ], [ 1518605107, 575000, 575000, 574500, 574500, 34 ], [ 1518605137, 574500, 574500, 574500, 574500, 34 ], [ 1518605227, 574500, 575900, 574500, 575900, 34 ], [ 1518605257, 575900, 575900, 575900, 575900, 34 ], [ 1518605384, 575900, 575900, 575900, 575900, 34 ], [ 1518605414, 575900, 575900, 575900, 575900, 34 ], [ 1518605509, 575900, 575900, 575900, 575900, 34 ], [ 1518605559, 575900, 575900, 575900, 575900, 34 ], [ 1518605673, 575900, 575900, 575900, 575900, 34 ], [ 1518605687, 575900, 575900, 575900, 575900, 0 ], [ 1518605783, 575900, 575900, 575000, 575000, 34 ], [ 1518605909, 575000, 575000, 575000, 575000, 34 ], [ 1518605949, 575000, 575000, 575000, 575000, 34 ], [ 1518605999, 575000, 575000, 575000, 575000, 34 ], [ 1518606089, 575000, 575000, 575000, 575000, 33 ], [ 1518606129, 575000, 575000, 575000, 575000, 33 ], [ 1518606179, 575000, 575000, 575000, 575000, 33 ], [ 1518606269, 575000, 575000, 573000, 573000, 33 ], [ 1518606309, 573000, 573000, 573000, 573000, 33 ], [ 1518606359, 573000, 573000, 573000, 573000, 33 ], [ 1518606449, 573000, 573100, 573000, 573100, 33 ], [ 1518606479, 573100, 573100, 573100, 573100, 33 ], [ 1518606559, 573100, 573100, 573100, 573100, 33 ], [ 1518606599, 573100, 573100, 573100, 573100, 33 ], [ 1518606679, 573100, 574000, 573100, 574000, 33 ], [ 1518606719, 574000, 574000, 574000, 574000, 33 ], [ 1518606779, 574000, 574000, 574000, 574000, 33 ], [ 1518606839, 574000, 574000, 574000, 574000, 33 ], [ 1518606919, 574000, 574000, 574000, 574000, 33 ], [ 1518606959, 574000, 574000, 574000, 574000, 33 ], [ 1518607019, 574000, 574000, 574000, 574000, 33 ], [ 1518607109, 574000, 574000, 573100, 573100, 34 ], [ 1518607149, 573100, 573100, 573100, 573100, 34 ], [ 1518607199, 573100, 573100, 573100, 573100, 34 ], [ 1518607289, 573100, 573100, 573100, 573100, 34 ], [ 1518607329, 573100, 573100, 573100, 573100, 34 ], [ 1518607379, 573100, 573100, 573100, 573100, 34 ] ] }
@parthi2929
Copy link
Author

time converted to seconds instead of milliseconds so mongodb aggregator $range can act on it..

@parthi2929
Copy link
Author

Updated with time gap.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment