Google Analytics, Dataform, Bigquery, Google Cloud Platform, Sql.
Accounting for “any time” is a bit harder task without refreshing the whole table, but that might be a margin of error you can live with. Or if you can’t…well that’s your choice. This is an important caveat because if you want to have the most complete dataset, you have to account for changes that