I think bigger issues would be time related queries when dataset gets bigger as opposed to write speeds. I think a time series database is best suited for this

I think bigger issues would be time related queries when dataset gets bigger as opposed to write speeds. I think a time series database is best suited for this kind of project (timescale build on top of postgres, influxdb, ...)