JUHE API Marketplace
Back to datasets
Dataset assetOpen Source CommunityStock MarketTime Series Data

Alpha Vantage Stock Market Data

Daily time‑series stock data obtained from the Alpha Vantage API, containing selected company stock information. The dataset includes columns such as ticker symbol, date, and closing price.

Source
github
Created
Nov 14, 2024
Updated
Nov 18, 2024
Signals
266 views
Availability
Linked source ready
Overview

Dataset description and usage context

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.
Need downstream help?

Pair the dataset with AI analysis and content workflows.

Once the source passes your review, move straight into summarization, transformation, report drafting, or presentation generation with the JuheAI toolchain.

Explore AI studio