In [4]:
pip install -U polygon-api-client

Defaulting to user installation because normal site-packages is not writeableNote: you may need to restart the kernel to use updated packages.

Requirement already satisfied: polygon-api-client in c:\users\jamel\appdata\roaming\python\python311\site-packages (1.14.4)
Requirement already satisfied: certifi<2026.0.0,>=2022.5.18 in c:\programdata\anaconda3\lib\site-packages (from polygon-api-client) (2024.6.2)
Requirement already satisfied: urllib3<3.0.0,>=1.26.9 in c:\programdata\anaconda3\lib\site-packages (from polygon-api-client) (2.0.7)
Requirement already satisfied: websockets<15.0,>=10.3 in c:\users\jamel\appdata\roaming\python\python311\site-packages (from polygon-api-client) (14.2)
In [6]:
from polygon import RESTClient
In [8]:
client = RESTClient(api_key="")
In [12]:
import pandas as pd

ticker = "C:EURUSD"

# List Aggregates (Bars)
aggs = []
for a in client.list_aggs(ticker=ticker, multiplier=1, timespan="minute", from_="2024-09-06", to="2025-03-01", limit=50000):
    aggs.append(a)

# Convert the list of aggregates into a DataFrame
df = pd.DataFrame(aggs)

# Save the DataFrame to CSV
df.to_csv('EURUSD_data.csv', index=False)

print("Data saved successfully to EURUSD_data.csv")

Data saved successfully to EURUSD_data.csv
In [14]:
import pandas as pd

# Read existing CSV
df = pd.read_csv('EURUSD_data.csv')

# Save as Excel file
df.to_excel('EURUSD_data.xlsx', index=False)

print("Excel file EURUSD_data.xlsx created successfully.")

Excel file EURUSD_data.xlsx created successfully.