You are right I did miss timestamp. It would be for display only (vuejs web app) and only 1 client would be fetching the data from db.
Would Redis be better? I was thinking of using a combination of the pub/sub feature of Redis and socket.io to stream from the C# API into my web app. (each...