Jesus, refreshing my memory of AWK and scripting the aggregation myself would have been faster.