Figured it out
I got a dataset of all the dates in the range.
I got all the dates in my query.
I then iterated over the dates, and if the date was in the first dataset, I wrote the blanks.
If the date was in the second list, I wrote the values from the query.
Had one issue, and I resolved it setting the values of the spaces and zeros to strings.