Chart not loading properly

[EryanNeo]

Question

Hello All,

Im using Xubuntu version 26:
Distributor ID: Ubuntu
Description: Ubuntu 26.04 LTS
Release: 26.04
Codename: resolute

In this os, while running a code to make a chart, I get error in the way candles are assigned time.

Case 1:
I used AAPL stock data from Yfinance, even though candles are of different dates, Im shown candles with date 21 Jan 1970, and candles varying in minutes.

Here is the code that I have used:
`import pandas as pd
from lightweight_charts import Chart

if name == 'main':

chart = Chart()
df = pd.read_csv('aapl.csv')
chart.set(df)

chart.show(block=True)`

and the output that I get is as below:

Here is the file aapl.csv:

aapl.csv

Case 2:
Here I have used personal data which contains time in timestamp. In this case, all candles are superimposed on top of each other, result is I get a single candle. What I suspect is that all candles are of same time 1 Jan 1970, which causes it to come on top of the previous one.

Code:
`import pandas as pd
from lightweight_charts import Chart

if name == 'main':

chart = Chart()
df = pd.read_csv('../data.csv')
df['time'] = pd.to_datetime(df['time'], unit = 's')
chart.set(df)

chart.show(block=True)`

The output in this case is as below:

The data file data.csv is as below:

data.csv

Python version: 3.14
Lightweight_charts version: 2.1

(eryan) eryan@eryan:~/Desktop/popaPig/pythonLightWeightCharts/test$ python --version
Python 3.14.4
(eryan) eryan@eryan:~/Desktop/popaPig/pythonLightWeightCharts/test$ pip show lightweight-charts
Name: lightweight-charts
Version: 2.1
Summary: Python framework for TradingView's Lightweight Charts JavaScript library.
Home-page: https://github.com/louisnw01/lightweight-charts-python
Author: louisnw
Author-email: 
License: MIT
Location: /home/eryan/Desktop/popaPig/eryan/lib/python3.14/site-packages
Requires: pandas, pywebview
Required-by: 

The same code works fine in Windows, Please suggest me the errors that might be behind this behaviour.

Thanks for the help.

Regards,
Aryan.

Code example

[EryanNeo]

Well Friends,
I found out a solution to this,
when I passed my date / time , its format used to be in seconds.

`print(df1["time"].dtype)

print(pd.api.types.is_datetime64_any_dtype(df1["time"]))

print(df1["time"].head())`

datetime64[s] True 0 2024-01-01 03:45:00 1 2024-01-01 03:50:00 2 2024-01-01 03:55:00 3 2024-01-01 04:00:00 4 2024-01-01 04:05:00 Name: time, dtype: datetime64[s]

and the library has a function which expects time in nanoseconds format:
def _df_datetime_format(self, df: pd.DataFrame, exclude_lowercase=None): df = df.copy() df.columns = self._format_labels(df, df.columns, df.index, exclude_lowercase) self._set_interval(df) if not pd.api.types.is_datetime64_any_dtype(df['time']): df['time'] = pd.to_datetime(df['time']) **df['time'] = df['time'].astype('int64') // 10 ** 9** return df

the line in bold, divides the time by 10**9 which if it in seconds gave 1 as output and so all my dates got convered to unix timestamp 1.

So i modified my df before passing it to the library as in the code below:

`import pandas as pd
from lightweight_charts import Chart

if name == 'main':

chart = Chart()
df = pd.read_csv('../data.csv')
df['time'] = pd.to_datetime(df['time'] + 5.5 * 3600, unit = 's')
**df["time"] = df["time"].astype("datetime64[ns]")**
print(df.iloc[0])
chart.set(df)

chart.show(block=True)`

the line in bold, converts seconds format to nanosecond format and the output is well expected, Please find it below: