This post talks about how to insert data with historical timestamps using an automation.
This may also work using future timestamps.