There is an “asof” operator that can be used to do that. But at the moment it’s part of the Paradigm4 EE kit, not publicly open. Here are some notes on it, in the context of finance data:
You can ask firstname.lastname@example.org for more information. We often build special tools for folks.