Database

[{"_id":"61013d6dda7d7c0015af5ccf","balances":[{"address":"0x1fc3ddeb035310930a444c0fa59c01618d5902af","symbol":"HBTC","balance":5.21419339e-10,"usdvalue":0.000020969961637162402},{"address":"0x1fc3ddeb035310930a444c0fa59c01618d5902af","symbol":"NSBT","balance":1.258566,"usdvalue":27.427343477595258},{"address":"0x1fc3ddeb035310930a444c0fa59c01618d5902af","symbol":"CRV","balance":517.985955847106,"usdvalue":806.7017064052314},{"address":"0x1fc3ddeb035310930a444c0fa59c01618d5902af","symbol":"USDT","balance":0.003469,"usdvalue":0.003470159747979122}],"address":"0x1fc3ddeb035310930a444c0fa59c01618d5902af","ethervalue":0.7604598621232733,"createdAt":"2021-07-28T11:20:13.927Z","updatedAt":"2021-07-28T11:20:13.927Z","__v":0}]

Query

db.collection.aggregate([{$unwind:"$balances"},{$group:{_id:"$balances.symbol",balance:{$sum:"$balances.balance"},usdvalue:{$sum:"$balances.usdvalue"}}},{$addFields:{symbol:"$_id",_id:"$$REMOVE"}}])

Result