0 - 2 of 2 tags for overlap

Hi all, it's my firt post, I hope you can help me here. Within the same day for one ID I have many overlapping events. Basically each event is added on top of scheduled events instead of overwriting existing records. Here is example:

I have a very large dataset of multiple part number with different pricing for different time periods.  Often all or a portion of a time period is superceded by a later record, and then returns to the original price after the superceding period ends.  I need a querty that sorts all this out and gives me a result showing the correct price in discrete time