Get Count of Prometheus values by Day

count_by_day.sh

#!/bin/bash
startdate=2019-10-01
enddate=$(date -I)

d="$startdate"

while [ "$d" != "$enddate" ]; do
  current=$d
  d=$(date -I -d "$d + 1 day")
  data=$(curl -s 'http://prometheus/api/v1/query_range?query=probe_http_status_code\{job="kubernetes-services",instance=~".*conversion.*"\}&start='$current'T00:00:00.000Z&end='$d'T00:00:00.000Z&step=15s')
  count=$(echo ${data}|jq '.data.result[0].values[] | select( .[1] != "200")' 2>&1 |grep -c \"0\")
  echo ${current}:${count}
done