Regarding if upstream service is needed for bandwidth usage history, as it needs computing power - well not at all. DD-WRT has basic banding report by days of month for close to 10 years [0]. I'm personally using it for 5+ years on a 20$ TP-Link and it just works, without the need of an external service.
[0] https://www.dd-wrt.com/wiki/images/3/3c/TrafficByMonth.Sampl...