You can generate a series of dates in a given range right at the database level

⚡️ Database Tip

When doing statistical aggregations by time, you may have gaps in your data. You don't have to fill them manually with code! You can generate a series of dates from a start to end time and use these days to join to your statistical data with gaps.