Snapshot historical data

[jreis]

I just found this Finding active days for a subscription/user/account (date spining)

which is pretty close to what I want to achieve