date            code     id    cur    beg_hr  end_hr beg_tip  end_tip
2011-01-21 12:00:00	1	BP1616	USD	0	18	0	20
2011-01-22 12:00:00	1	BP1616	USD	18	21	20	20
2011-01-23 12:00:00	1	BP1616	USD	21	21	20	20
2011-01-24 12:00:00	1	BP1616	USD	21	29	20	35
2011-01-25 12:00:00	1	BP1616	USD	29	37	35	50
2011-01-26 12:00:00	1	BP1616	USD	37	45	50	65

2011-01-21 12:00:00	1	KP1616	USD	0	8	0	60
2011-01-22 12:00:00	1	KP1616	USD	8	8	60	85
2011-01-23 12:00:00	1	KP1616	USD	8	8	85	85
2011-01-24 12:00:00	1	KP1616	USD	8	16	85	145
2011-01-25 12:00:00	1	KP1616	USD	16	24	145	205
2011-01-26 12:00:00	1	KP1616	USD	24	32	205	265

2011-01-21 12:00:00	1	PP3232	USD	0	104	0	20
2011-01-22 12:00:00	1	PP3232	USD	104	108	20	30
2011-01-23 12:00:00	1	PP3232	USD	108	108	30	30
2011-01-24 12:00:00	1	PP3232	USD	108	112	30	45
2011-01-25 12:00:00	1	PP3232	USD	112	116	45	60