def append_time(df):
    df['time'] = df['timestamp'].apply(lambda x: datetime.fromtimestamp(x / 1000))
    start = datetime(2017, 11, 18, 1, 46, 30)
    delta = start - df.iloc[0]['time']
    df['time'] = df['time'] + delta
    return df