Why not, it would be great for inventory tracking systems as you have an audit of all transactions.
You can’t scan 1 year of data every time, so now you need some type of external process that can either pre-compute those metrics (not flexible) or a compaction type process that makes it manageable to scan all that data.
Which is basically the trade off between something like stream processing or compaction in a database.