Rolling Return and Asset Ranking | Dataford Interview Questions
Rolling Return and Asset Ranking
HardWindow FunctionsLag/LeadRanking
Problem
Write a SQL query using window functions to compute a rolling 30-day return, rank assets within each date, and compare each asset to its prior-day value.
Problem
Write a SQL query using window functions to compute a rolling 30-day return, rank assets within each date, and compare each asset to its prior-day value.
Your answer
Try one AI text evaluation on us
Get structured feedback, scored against a 4-axis rubric. Premium unlocks unlimited.
