You operate a database that stores stock trades and an application that retrieves average stock...

Change the row key syntax in your Cloud Bigtable table to begin with the stock symbol.

Change the row key syntax in your Cloud Bigtable table to begin with a random number per second.

Change the data pipeline to use BigQuery for storing stock trades, and update your application.

Use Cloud Dataflow to write summary of each day’s stock trades to an Avro file on Cloud Storage. Update your application to read from Cloud Storage and Cloud Bigtable to compute the responses.