Yes this can be done with the GroupBy node!
You just set the date column and the state column as Group columns in the “Groups” tab of the node and in the “Manual Aggregation” tab you choose the column containing the count and select Sum as aggregation method to get the total sum of counts for each state on each date. Make sure your count column is processed as a numbers type (e.g. integer) beforehand.