[{"_id":{"$oid":"5f2701f50b702980ed7792e2"},"item":{"id":168216},"quantity":1267,"unit_price":3.45,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701f60b702980ed779a9f"},"item":{"id":168216},"quantity":4,"unit_price":393000,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701f60b702980ed77a20b"},"item":{"id":168216},"quantity":1727,"unit_price":2.4,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701fd0b702980ed783fa1"},"item":{"id":168216},"quantity":3000,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701fd0b702980ed783fef"},"item":{"id":168216},"quantity":3000,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701fe0b702980ed786c10"},"item":{"id":168216},"quantity":6,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701fe0b702980ed787063"},"item":{"id":168216},"quantity":347,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701ff0b702980ed7873ee"},"item":{"id":168216},"quantity":2,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701ff0b702980ed787afe"},"item":{"id":168216},"quantity":5,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701ff0b702980ed78822f"},"item":{"id":168216},"quantity":9,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701ff0b702980ed7883ff"},"item":{"id":168216},"quantity":3,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701ff0b702980ed78844b"},"item":{"id":168216},"quantity":1,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701ff0b702980ed788695"},"item":{"id":168216},"quantity":1000,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701ff0b702980ed788699"},"item":{"id":168216},"quantity":989,"unit_price":6.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701ff0b702980ed788764"},"item":{"id":168216},"quantity":500,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701ff0b702980ed78876d"},"item":{"id":168216},"quantity":602,"unit_price":5.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701ff0b702980ed78880c"},"item":{"id":168216},"quantity":4341,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701ff0b702980ed78886d"},"item":{"id":168216},"quantity":1000,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701ff0b702980ed788bf8"},"item":{"id":168216},"quantity":100,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2701ff0b702980ed788bfe"},"item":{"id":168216},"quantity":44,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702000b702980ed7894e7"},"item":{"id":168216},"quantity":100,"unit_price":2.38,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702000b702980ed7894f9"},"item":{"id":168216},"quantity":100,"unit_price":2.38,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702000b702980ed789504"},"item":{"id":168216},"quantity":100,"unit_price":2.38,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702000b702980ed789c26"},"item":{"id":168216},"quantity":3,"unit_price":2.37,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702000b702980ed789e0b"},"item":{"id":168216},"quantity":5,"unit_price":2.37,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702000b702980ed789e5a"},"item":{"id":168216},"quantity":220,"unit_price":2,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702000b702980ed78a1db"},"item":{"id":168216},"quantity":1,"unit_price":2,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702000b702980ed78a214"},"item":{"id":168216},"quantity":540,"unit_price":2,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702000b702980ed78a4bd"},"item":{"id":168216},"quantity":6,"unit_price":2,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702000b702980ed78a546"},"item":{"id":168216},"quantity":5,"unit_price":2,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702000b702980ed78a68d"},"item":{"id":168216},"quantity":24,"unit_price":2,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702010b702980ed78b422"},"item":{"id":168216},"quantity":100,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702010b702980ed78b443"},"item":{"id":168216},"quantity":8,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702010b702980ed78b509"},"item":{"id":168216},"quantity":773,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702010b702980ed78b876"},"item":{"id":168216},"quantity":1594,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702010b702980ed78b8ba"},"item":{"id":168216},"quantity":1256,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702020b702980ed78d77b"},"item":{"id":168216},"quantity":500,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702020b702980ed78d84c"},"item":{"id":168216},"quantity":2671,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702020b702980ed78de7a"},"item":{"id":168216},"quantity":1057,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702020b702980ed78e280"},"item":{"id":168216},"quantity":15,"unit_price":1.9,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702030b702980ed78e680"},"item":{"id":168216},"quantity":22,"unit_price":1.8,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702030b702980ed78e8b3"},"item":{"id":168216},"quantity":32,"unit_price":1.8,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702030b702980ed78efe5"},"item":{"id":168216},"quantity":11,"unit_price":1.8,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f2702030b702980ed78f564"},"item":{"id":168216},"quantity":5,"unit_price":1.8,"connected_realm_id":1602,"last_modified":1596391643},{"_id":{"$oid":"5f270ffd66082e8d260f4316"},"item":{"id":168216},"quantity":1267,"unit_price":3.45,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f270ffd66082e8d260f4aca"},"item":{"id":168216},"quantity":4,"unit_price":393000,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f270ffd66082e8d260f5233"},"item":{"id":168216},"quantity":1727,"unit_price":2.4,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100666082e8d260fe4ec"},"item":{"id":168216},"quantity":3000,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100666082e8d260fe536"},"item":{"id":168216},"quantity":3000,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100866082e8d261010e0"},"item":{"id":168216},"quantity":6,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100966082e8d2610152b"},"item":{"id":168216},"quantity":347,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100966082e8d261018b2"},"item":{"id":168216},"quantity":2,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100966082e8d26101fac"},"item":{"id":168216},"quantity":5,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100966082e8d2610268a"},"item":{"id":168216},"quantity":9,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100966082e8d26102859"},"item":{"id":168216},"quantity":3,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100966082e8d261028a4"},"item":{"id":168216},"quantity":1,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100a66082e8d26102aeb"},"item":{"id":168216},"quantity":1000,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100a66082e8d26102aef"},"item":{"id":168216},"quantity":989,"unit_price":6.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100a66082e8d26102bb7"},"item":{"id":168216},"quantity":500,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100a66082e8d26102bc0"},"item":{"id":168216},"quantity":602,"unit_price":5.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100a66082e8d26102c5e"},"item":{"id":168216},"quantity":4341,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100a66082e8d26102cbe"},"item":{"id":168216},"quantity":1000,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100a66082e8d2610303e"},"item":{"id":168216},"quantity":100,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100a66082e8d26103044"},"item":{"id":168216},"quantity":44,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100a66082e8d261038ca"},"item":{"id":168216},"quantity":100,"unit_price":2.38,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100a66082e8d261038dc"},"item":{"id":168216},"quantity":100,"unit_price":2.38,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100a66082e8d261038e7"},"item":{"id":168216},"quantity":100,"unit_price":2.38,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100b66082e8d26103fef"},"item":{"id":168216},"quantity":3,"unit_price":2.37,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100b66082e8d261041c1"},"item":{"id":168216},"quantity":5,"unit_price":2.37,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100b66082e8d2610420f"},"item":{"id":168216},"quantity":220,"unit_price":2,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100b66082e8d26104570"},"item":{"id":168216},"quantity":1,"unit_price":2,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100b66082e8d261045a9"},"item":{"id":168216},"quantity":540,"unit_price":2,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100b66082e8d26104840"},"item":{"id":168216},"quantity":6,"unit_price":2,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100b66082e8d261048bf"},"item":{"id":168216},"quantity":5,"unit_price":2,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100b66082e8d261049fd"},"item":{"id":168216},"quantity":24,"unit_price":2,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100c66082e8d26105750"},"item":{"id":168216},"quantity":100,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100c66082e8d26105770"},"item":{"id":168216},"quantity":8,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100c66082e8d26105831"},"item":{"id":168216},"quantity":773,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100c66082e8d26105b85"},"item":{"id":168216},"quantity":1594,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100c66082e8d26105bc6"},"item":{"id":168216},"quantity":1256,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100e66082e8d26107982"},"item":{"id":168216},"quantity":500,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100e66082e8d26107a46"},"item":{"id":168216},"quantity":2671,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100e66082e8d26108000"},"item":{"id":168216},"quantity":1057,"unit_price":1.95,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100e66082e8d261083d8"},"item":{"id":168216},"quantity":15,"unit_price":1.9,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100e66082e8d2610877a"},"item":{"id":168216},"quantity":22,"unit_price":1.8,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100e66082e8d2610898b"},"item":{"id":168216},"quantity":32,"unit_price":1.8,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100f66082e8d26108f7c"},"item":{"id":168216},"quantity":11,"unit_price":1.8,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100f66082e8d26109366"},"item":{"id":168216},"quantity":5,"unit_price":1.8,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100f66082e8d261098dc"},"item":{"id":168216},"quantity":1,"unit_price":1.8,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100f66082e8d26109931"},"item":{"id":168216},"quantity":2,"unit_price":1.8,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f27100f66082e8d2610993e"},"item":{"id":168216},"quantity":2,"unit_price":1.8,"connected_realm_id":1602,"last_modified":1596395245},{"_id":{"$oid":"5f271da50264a6973ec503e0"},"item":{"id":168216},"quantity":1267,"unit_price":3.45,"connected_realm_id":1602,"last_modified":1596398843},{"_id":{"$oid":"5f271da60264a6973ec50b8e"},"item":{"id":168216},"quantity":4,"unit_price":393000,"connected_realm_id":1602,"last_modified":1596398843},{"_id":{"$oid":"5f271da60264a6973ec512f6"},"item":{"id":168216},"quantity":1727,"unit_price":2.4,"connected_realm_id":1602,"last_modified":1596398843},{"_id":{"$oid":"5f271dae0264a6973ec59a77"},"item":{"id":168216},"quantity":3000,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596398843},{"_id":{"$oid":"5f271dae0264a6973ec59abf"},"item":{"id":168216},"quantity":3000,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596398843},{"_id":{"$oid":"5f271db00264a6973ec5c5ce"},"item":{"id":168216},"quantity":6,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596398843},{"_id":{"$oid":"5f271db00264a6973ec5ca14"},"item":{"id":168216},"quantity":347,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596398843},{"_id":{"$oid":"5f271db00264a6973ec5cd8d"},"item":{"id":168216},"quantity":2,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596398843},{"_id":{"$oid":"5f271db10264a6973ec5d467"},"item":{"id":168216},"quantity":5,"unit_price":2.39,"connected_realm_id":1602,"last_modified":1596398843}]

db.collection.aggregate([{$group:{_id:{item_id:"$item.id",connected_realm_id:"$connected_realm_id",last_modified:"$last_modified"},open_interest:{$sum:{$multiply:["$unit_price","$quantity"]}},quantity:{$sum:"$quantity"},price:{$min:"$unit_price"},}},{$project:{_id:{$concat:[{$toString:"$_id.item_id"}," - ",{$toString:"$_id.last_modified"}]},item_id:"$_id.item_id",connected_realm_id:"$_id.connected_realm_id",last_modified:"$_id.last_modified",price:"$price",quantity:"$quantity",open_interest:"$open_interest",}}])