mongo stats

event.json

db.events.find({email:"[email protected]"}, {media_id:1, media_duration:1, percent_viewed:1}).pretty()
{
	"_id" : "v20150225_44ba9409-0811-4b55-ac72-b9db56692029.1425632019000",
	"percent_viewed" : 0.006943268075083266,
	"media_id" : "9wypa2kelr",
	"media_duration" : 495.876
}
{
	"_id" : "1424814515957e0.35607868363149464.1424814517000",
	"percent_viewed" : 0.02628883027208419,
	"media_id" : "9wypa2kelr",
	"media_duration" : 495.876
}
{
	"_id" : "1424814433068e0.9482095343992114.1424814489000",
	"percent_viewed" : 0.014692073488822073,
	"media_id" : "qs50nkxbhj",
	"media_duration" : 316.293
}
{
	"_id" : "1424814433068e0.9482095343992114.1424814434000",
	"percent_viewed" : 0.00006856552847892327,
	"media_id" : "9wypa2kelr",
	"media_duration" : 495.876
}
{
	"_id" : "1424619745038e0.7901077731512487.1424814102000",
	"percent_viewed" : 1,
	"media_id" : "ut2iolanie",
	"media_duration" : 296.3
}
{
	"_id" : "1424619745038e0.7901077731512487.1424813512000",
	"percent_viewed" : 0.9932387516025533,
	"media_id" : "qjxm9lp61p",
	"media_duration" : 589.684
}
{
	"_id" : "1424619745038e0.7901077731512487.1424812587000",
	"percent_viewed" : 0.9951360664255753,
	"media_id" : "dyd5354rwb",
	"media_duration" : 767.897
}
{
	"_id" : "1424619745038e0.7901077731512487.1424734740000",
	"percent_viewed" : 0.9917586732895146,
	"media_id" : "wn6wg26l6o",
	"media_duration" : 572.966
}
{
	"_id" : "1424619745038e0.7901077731512487.1424734437000",
	"percent_viewed" : 0.9845651913313657,
	"media_id" : "eukrf10oqv",
	"media_duration" : 308.653
}
{
	"_id" : "1424619745038e0.7901077731512487.1424733839000",
	"percent_viewed" : 0.9925365701310869,
	"media_id" : "nwc5x0q8sa",
	"media_duration" : 592.355
}
{
	"_id" : "1424619745038e0.7901077731512487.1424733177000",
	"percent_viewed" : 0.9952444379542233,
	"media_id" : "iqmm7dxlwi",
	"media_duration" : 677.943
}
{
	"_id" : "1424619745038e0.7901077731512487.1424732935000",
	"percent_viewed" : 0.9805749035355162,
	"media_id" : "t715lfyqdm",
	"media_duration" : 242.058
}
{
	"_id" : "1424619745038e0.7901077731512487.1424732490000",
	"percent_viewed" : 0.9921658493778829,
	"media_id" : "869df1wkh8",
	"media_duration" : 439.869
}
{
	"_id" : "1424619745038e0.7901077731512487.1424732141000",
	"percent_viewed" : 0.988186590121565,
	"media_id" : "ncqtocv2p0",
	"media_duration" : 262.329
}
{
	"_id" : "1424619745038e0.7901077731512487.1424731579000",
	"percent_viewed" : 0.992403094915419,
	"media_id" : "iv7qmgo2q6",
	"media_duration" : 555.621
}
{
	"_id" : "1424619745038e0.7901077731512487.1424730887000",
	"percent_viewed" : 0.9953535788642401,
	"media_id" : "rgm3584il8",
	"media_duration" : 696.45
}
{
	"_id" : "1424619745038e0.7901077731512487.1424730552000",
	"percent_viewed" : 0.9858193538752551,
	"media_id" : "wg4xd5w6xj",
	"media_duration" : 321.424
}
{
	"_id" : "1424619745038e0.7901077731512487.1424730058000",
	"percent_viewed" : 0.992381333964681,
	"media_id" : "18caq3ov2g",
	"media_duration" : 494.181
}
{
	"_id" : "1424619745038e0.7901077731512487.1424729408000",
	"percent_viewed" : 0.9928567446700446,
	"media_id" : "4wpklainqj",
	"media_duration" : 645.784
}
{
	"_id" : "1424619745038e0.7901077731512487.1424648988000",
	"percent_viewed" : 0.9919230850980921,
	"media_id" : "ik5zdw6xd7",
	"media_duration" : 423.429
}
Type "it" for more
> it
{
	"_id" : "1424619745038e0.7901077731512487.1424648446000",
	"percent_viewed" : 0.9938000421212871,
	"media_id" : "161jjdc1ft",
	"media_duration" : 541.294
}
{
	"_id" : "1424619745038e0.7901077731512487.1424648129000",
	"percent_viewed" : 0.9858422412130524,
	"media_id" : "qs50nkxbhj",
	"media_duration" : 316.293
}
{
	"_id" : "1424619745038e0.7901077731512487.1424647386000",
	"percent_viewed" : 0.9937221101862181,
	"media_id" : "6zu1eh26ib",
	"media_duration" : 745.792
}
{
	"_id" : "1424619745038e0.7901077731512487.1424646909000",
	"percent_viewed" : 0.9902695192059459,
	"media_id" : "vn8775l068",
	"media_duration" : 476.441
}
{
	"_id" : "1424619745038e0.7901077731512487.1424646529000",
	"percent_viewed" : 0.9889055112091465,
	"media_id" : "alqbpnqpa4",
	"media_duration" : 366.308
}
{
	"_id" : "1424619745038e0.7901077731512487.1424643358000",
	"percent_viewed" : 0.9907127913200019,
	"media_id" : "aepqnfs61f",
	"media_duration" : 513.825
}
{
	"_id" : "1424619745038e0.7901077731512487.1424642770000",
	"percent_viewed" : 0.9623012284953042,
	"media_id" : "it8bs2blbw",
	"media_duration" : 580.629
}
{
	"_id" : "1424619745038e0.7901077731512487.1424642350000",
	"percent_viewed" : 0.9885713317798281,
	"media_id" : "l5zg5gh1hr",
	"media_duration" : 413.259
}
{
	"_id" : "1424619745038e0.7901077731512487.1424641912000",
	"percent_viewed" : 0.9919412599280119,
	"media_id" : "omvalmq8ll",
	"media_duration" : 438.406
}
{
	"_id" : "1424619745038e0.7901077731512487.1424640889000",
	"percent_viewed" : 0.9916849825828575,
	"media_id" : "ash91ob455",
	"media_duration" : 367.167
}
{
	"_id" : "1424619745038e0.7901077731512487.1424640530000",
	"percent_viewed" : 1,
	"media_id" : "nb3piyv6wm",
	"media_duration" : 315.201
}
{
	"_id" : "1424619745038e0.7901077731512487.1424619747000",
	"percent_viewed" : 0.9891985005165124,
	"media_id" : "a9m1f0rd16",
	"media_duration" : 375.596
}
{
	"_id" : "1424553188439e0.6449382344726473.1424558804000",
	"percent_viewed" : 0.015452773724959798,
	"media_id" : "a9m1f0rd16",
	"media_duration" : 375.596
}
{
	"_id" : "1424553188439e0.6449382344726473.1424558296000",
	"percent_viewed" : 0.9924987198697004,
	"media_id" : "hiztji3wbd",
	"media_duration" : 529.243
}
{
	"_id" : "1424553188439e0.6449382344726473.1424557533000",
	"percent_viewed" : 0.9935606853412532,
	"media_id" : "tbkcbrp5wb",
	"media_duration" : 754.894
}
{
	"_id" : "1424553188439e0.6449382344726473.1424556574000",
	"percent_viewed" : 1,
	"media_id" : "nqm3epqw5l",
	"media_duration" : 854.717
}
{
	"_id" : "1424553188439e0.6449382344726473.1424555967000",
	"percent_viewed" : 0.8953931802366042,
	"media_id" : "mzcyp51deu",
	"media_duration" : 574.8
}
{
	"_id" : "1424553188439e0.6449382344726473.1424555429000",
	"percent_viewed" : 0.9914847446329077,
	"media_id" : "oyoohdwifb",
	"media_duration" : 552.068
}
{
	"_id" : "1424553188439e0.6449382344726473.1424554960000",
	"percent_viewed" : 0.7521508045539248,
	"media_id" : "7rr033k8n8",
	"media_duration" : 588.152
}
{
	"_id" : "1424553188439e0.6449382344726473.1424554237000",
	"percent_viewed" : 0.9960653148790988,
	"media_id" : "h0km2t6qmy",
	"media_duration" : 671.21
}
Type "it" for more
> it
{
	"_id" : "1424553188439e0.6449382344726473.1424553684000",
	"percent_viewed" : 0.9913464821770566,
	"media_id" : "18u18r6vqw",
	"media_duration" : 538.856
}
{
	"_id" : "1424553188439e0.6449382344726473.1424553190000",
	"percent_viewed" : 0.9753305261799321,
	"media_id" : "9wypa2kelr",
	"media_duration" : 495.876
}