This is the first comparison I've seen between BigQuery and Athena since Athena was released last year. Overall, it seems like BigQuery's performance is generally better while Athena is generally cheaper.

Big caveat here: this analysis intentionally ignores partitioning, which is possible in each platform (albeit differently). So, these results are instructive on relative performance but aren't representative of the way an optimized implementation would perform in the real world.