Fix timezone issue and normalize data