Write a query to calculate a rolling 30-day average of transaction volumes for a financial services client.
