You are tasked with migrating a table to BigQuery, focusing on optimizing query performance for analyzing item sales and purchasing trends by state, city, and individual store. The table includes transaction time, items purchased, store ID, and store location details (city and state). Given that queries frequently analyze item sales over the last 30 days and examine purchasing trends by state, city, and store, how should you structure the table in BigQuery for optimal performance?