Write a query utilizing window functions to calculate the rolling 7-day average of trade executions for a specific security.