Getting DISTINCT IDs for DISTINCT Dates in BigQuery Using Date Trunc and Group By

Optimizing Windowed Unique Person Count Calculation with Numba JIT Compiler