File size: 681 Bytes
717bee1 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | import yfinance as yf
import pandas as pd
import os
print(" Downloading fresh AAPL data...")
df = yf.download("AAPL", period="1mo", interval="1h", progress=False)
# Clean up the data
df = df.reset_index()
df.columns = ['datetime', 'open', 'high', 'low', 'close', 'volume']
# Convert datetime to string
df['datetime'] = df['datetime'].dt.strftime('%Y-%m-%d %H:%M:%S')
# Save to CSV (create directory if needed)
os.makedirs("server/data", exist_ok=True)
df.to_csv("server/data/prices.csv", index=False)
print(f"Saved {len(df)} rows of clean data")
print("\nFirst 3 rows:")
print(df[['datetime', 'close']].head(3))
print("\nLast 3 rows:")
print(df[['datetime', 'close']].tail(3))
|