import pandas as pd calls_df, = pd.read_html("https://www.beleggen.nl/koersen/aex.aspx", thousands=".", header=0, match="Royal Dutch Shell A", parse_dates=["Tijd"]) print(calls_df.to_json(orient="records", date_format="iso"))