This article explains how to request a timeseries metric and more importantly, how to interpret the results so that you can create a throughput chart in Excel which matches the graphs seen in CMA.
https://support.catonetworks.com/hc/en-us/articles/25296975130525-Example-Site-Bandwidth-with-accountMetrics-API