File manipulations

Count by key (group by)

awk '{a[substr($1, 0, 6)]++}END{for (k in a) print k, a[k]}' input_file.txt