Quant & AIGuide
The nearest record can come from the future: testing pandas time joins
A BTC decision at 10000 milliseconds matches data available at 10010. A four-row synthetic example exposes future matches, stale records and accidental joins across assets.