A stream would be a better choice, yes. All you need is to look for the Add / Update / Delete StreamEntries services on the stream.
But keep in mind the current ThWx limitations: Where Should I Store My Thingworx Data?
We sometimes create a Stream for each device, so that we can keep the number of rows low, rather than store all data for all devices in a single stream. Regardless, if you are going to keep more than 1/2 a million rows in a single stream, which is not really that much, you should offload that to SQL and use the Database ThingTemplate to wire it in.