Filtered table without using Pivot

I've attached a workbook which has a table of raw data on the left. The columns for this data are a timestamp, and a dollar amount.

To the right, I've got a "desired output" table. The desired output includes only data from the left table which falls within certain timeframes. These timeframes are shown to the right.

In other words, the desired output table will have a timestamp, and a dollar amount, in chronological order, showing only data from the original table which fits within specified time constraints.

Is there a way to create this new table without using PivotTables?

Thanks!

Yes, that works. Thank you! I would have never thought of using Aggregate.