How to affordably store large volumes of logs?

Hello,

We're using Application Insights and generate 20GB of logs per day which we rarely query. It serves more of an audit log which gets used when we need to investigate something. You can imagine how expensive it is, and therefore we are looking for an alternative solution.

I'm curious to know how you guys store large volumes of logs and what is your most common query pattern?