The relatively new date-partitioning feature for tables has cut down query costs/time significantly.
Disclosure: I'm https://twitter.com/felipehoffa and I work for Google Cloud. And I'm really excited to reprocess all public tables into clustered ones.