query and process into a normalized series of bins