added api method to pull aggregate data for last day