Wat is As-of join?

An as-of join matches each row of a left table (decision times) with the last row of a right table (observations) whose time is at or before the left row’s time, optionally within a tolerance; strictly before when the right table’s rows become known only after their stamp.