transform raw option data into refined option data