There's an opportunity for a tool that combines this sort of technology in the backend with a spreadsheet-like GUI powered by formulas and all the user friendliness that comes with a non-programmer interface. Wall Street would forever be changed. Source: I'm one of the poor souls fighting my CPU and RAM to do the same thing with Excel and non-native add-ins by {FactSet, Capital IQ, Bloomberg}
This stuff
SELECT * FROM balances
LATEST BY balance_ccy, cust_id
WHERE timestamp <= '2020-04-22T16:15:00.000Z'
AND NOT inactive;