Posted Jan 27, 2026
Analyzed stocks and crypto volatility for risk and stability.

yfinance, pandas, SQLAlchemystock.py):merge records into PostgreSQL, preventing duplicates.AVG() OVER to calculate 20-day and 50-day Simple Moving Averages (SMA).LAG() to calculate Daily Returns, which serves as the basis for volatility math.