You should try it on ClickHouse Cloud - the pricing is not based on bytes, so the resulting cost would be near zero compared to $1M on BigQuery.

And it would probably execute faster... :)

(Disclaimer: I work at ClickHouse)