Write a SQL query using window functions to compute a rolling 7-day average and rank each asset by its daily return within sector.
