final hourly extraction