pull the data by unique ID

You need a change to the criteria "most oldest kgs of unique ID in last 30 days". 9/23/2017 - 30 days is 8/24/2017. The most recent date for Product ID 10800001 is 8/22/2017 which is 32 days back.

Nothing qualifies.

I certainly agree with Dave in that it is easier to help if the sample data and expected results actually agree.
The following array entered formulas* seem to be what you are looking for, although they are not going to yield the expected results from the data provided.
In B3 and down:

Formula:

=MAX(IF(Raw!A$3:A$42=A3,Raw!B$3:B$42))

In C3 and down:

Formula:

=INDEX(Raw!C$3:C$42,MATCH(MIN(IF(Raw!A$3:A$42=A3,IF(Raw!B$3:B$42>=TODAY()-30,Raw!B$3:B$42))),Raw!B$3:B$42,0))

In D3 and down:

Formula:

=INDEX(Raw!D$3:D$42,MATCH(MIN(IF(Raw!A$3:A$42=A3,IF(Raw!B$3:B$42>=TODAY()-90,Raw!B$3:B$42))),Raw!B$3:B$42,0))

*In each case select the cell in row 3 of the given column,
Paste the formula into the formula bar,
Simultaneously press the Ctrl, Shift and Enter keys,
Double click the fill handle.
Let us know if you have any questions.