Optimize trade PnL table updates

Company: Jane Street

Role: Software Engineer

Category: Coding & Algorithms

Difficulty: hard

Interview Round: Onsite

Quick Answer: This question evaluates understanding of incremental aggregation and state management, including handling overlapping predicates, caching expensive or asynchronous computations, and algorithmic complexity considerations in time-series PnL updates.