This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Pricing Analyst at Redfin. The pricing strategy team wants to smooth out price volatility in listing histories to better understand pricing trends. For each listing, they need a 3-event moving average of price across all price history events (listed, price_change, pending, sold, etc.). This helps detect gradual price declines versus sudden drops.
You are a Pricing Analyst at Redfin. The pricing strategy team wants to smooth out price volatility in listing histories to better understand pricing trends. For each listing, they need a 3-event moving average of price across all price history events (listed, price_change, pending, sold, etc.). This helps detect gradual price declines versus sudden drops.