pull the data by unique ID

Hi Experts,

I have file with two tabs, 1st is the Raw data and second one is Result, I need three formula in result tab, 1st is most recent time will be show of this unique product product, there are many products of same Id I need most recent time of this ID, second formula I need most oldest kgs of unique ID in last 30 days, Third I need most oldest kgs of unique ID in last 90 days, I have attached screenshot and also excel file.

Thanks in advance.

Farhan