Given a data set with { Customer ID, Serial number, Intent : command, timestamp }. So, wirte a macro like function that could have go through a file with billions of rows and figures out if any cluster of events exists. what are they ?

One of my friend was asked in an interview was wondering how to solve it? I am trying to get more details about the question.

Any solutions would be really helpful. Thank you