In this technical deep-dive, I

In this technical deep-dive, I engineered a robust SQL script to extract high-level financial insights from 20+ years of Nifty 50 data. I moved beyond basic queries to implement complex analytical functions that simulate real-world market tracking.

Market Sentiment Logic: Developed a CASE-based classifier to identify Bullish/Bearish trends using 50-day Moving Averages.

Volatility & Risk: Calculated day-on-day price fluctuations and ranked high-risk trading days.

Momentum Tracking: Integrated window functions (LAG/LEAD) to compute RSI-base logic and 30-day price momentum.

Efficiency Metrics: Analyzed Turnover Efficiency to understand market liquidity during peak trading hours.

This project demonstrates my ability to handle large-scale financial datasets and translate raw numbers into strategic market indicators.