WTH Isn't there a way to insert historical or backdated sensor data?

I have sensors that I update via MQTT, however the updates come in batches. So every hour I get 4 readings for a sensor. Right now my only options are to either do something like average those readings and insert a single record or to manually inerst the data into the database.

I have a thread here with some rather technical details on how I almost got this to work using the state_changed event, however the object being sent by scripts and automations is a Python dict, instead of a State object, and the receiving code cannot handle it.

Fixing that could be one way to solve this, although I’d be happy with a more user friendly solution.

Spook integration