5 ms·
> Versioned modifications ("time travel") - ArcticDB is bitemporal. > Timeseries indexes. That's a nice addition.
by porker 2y ago
> Versioned modifications ("time travel") - ArcticDB is bitemporal. > Timeseries indexes.
That's a nice addition.
- blitzar 2y agoGiven how high a selling point this is, it is something that I cannot recall ever using in ArcticDB (5+ years of using). It's (financial) time series data, the past doesn't change. Back adjusting futures contracts or back adjusting for dividends / splits come to mind as I write this, but I would just reprocess these tasks from the raw data "as of date" if needed.
- jjmunro 2y ago100% makes sense, it depends what you're looking for. There are however lots of time-series that do change in Finance, e.g. valuations, estimates, alt-data (an obvious one is weather predictions). The time-travel feature can being super useful outside of external data changing as well, as an audit-log, and as a way to see how your all-time evaluations have changed (say backtests).
- nzjrs 2y agoId be interested to hear how often you have your team use this to also store historical backtest results as people iterate on strategies.
- dnadler 2y agoI’ve never seen it used for backtests personally. Generally backtested results are saved as a batch of variants following some naming convention as different symbols.
- jjmunro 2y agoSo, yes, separating the use-cases out... You would use some convention for naming and parametrising backtests, 'different' backtests would get stored separately. But once you start updating backtests, running them in a loop with changing data, that's when the time-travel feature starts to be useful.
- dnadler 2y agoYeah, that’s fair, and something you basically get for free. Also, hi James! :)
- jjmunro 2y agoIt's a primary use-case.
- dnadler 2y agoFor pricing data, sure, but for things like fundamentals or economics where there are estimates that are revised over time, one way to store this data is with a versioning feature. It allows for PIT data without much overhead, in theory. And actually, pricing can be revised as well, though it is much less common. That said, versioning is not the only way to handle these kinds of things. Versioning can also be useful as an audit trail for data transformation. Though again, these could be stored in another way as well.