Below BigQuery looks at extracting unique user counts using day parting between two fixed dates from a Google Analytics App + Web property.

SELECT event_date and user counts FROM ‘table-name.*’ goes through all the partitioned tables [by day] to pull the user counts.

WHERE event_date BETWEEN checks between two dates [All of August 2020] while ORDER BY event_date ASC sorts it in ascending order.

Query and Result below: