Dataset Overview

Data Source

• Source: Alpha Vantage API
• Details: Daily time‑series stock data covering selected companies.

Dataset Structure

• Table: RAW_DATA.LAB2
• Columns:
  • symbol: Stock ticker (e.g., NFLX, ISRG)
  • date: Record date
  • close: Closing price for the day

Data Processing Workflow

1. Extraction: Pull stock data via the Alpha Vantage API.
2. ETL: Load data into Snowflake table RAW_DATA.LAB2 using Airflow.
3. ELT: Transform raw data with dbt to compute key metrics (7‑day moving average, Relative Strength Index (RSI), price momentum).
4. Visualization: Present analysis results using Tableau, Superset, or Preset.

Key Metrics

• 7‑day moving average
• Relative Strength Index (RSI)
• Price momentum

Use Cases

• Application: Stock price analysis for assessing trends, momentum, and performance of companies such as ISRG and NFLX.