Overview
The Alphavantage connector imports daily time series stock price data for specified ticker symbols. It also supports a static metadata table for symbol reference (manually managed).
Granularity: Daily stock price data per ticker symbol
Purpose: Track daily open, high, low, close, and volume values for equities
Refresh cadence: Daily replace
Metadata: Optional lookup table for symbol info
Connection Setup / Requirements
Key | Description | Required | Type | Size |
api_key | API key for Alphavantage API | Yes | Hidden | — |
Import Configuration
Data Import Job
Setting | Value |
Feed | alphavantage |
Job Label | Alphavantage Stock - Daily |
Status | Enabled (1) |
Target Tables | alphavantage_data_stockdaily |
Target Types | Data |
Update Mode | Replace |
Create Targets | True |
Date Column | date |
Look-back Quantity | 1 day |
First Run (UTC) | 04:00 |
Poll Frequency | Every 24 hours |
Options (Target):
Key | Description | Required | Type |
method | API method used: | Yes | Hidden |
symbols | Comma-separated ticker symbols (e.g., MSFT) | Yes | Text |
Metadata Job (Manual Lookup Table)
Setting | Value |
Type | Lookup |
Table | alphavantage_meta_symbol |
Description | Alphavantage - Meta Symbol |
Update Mode | Refresh |
Create Target | False (static or manually managed) |
Tables Created and Their Fields
Data Table
alphavantage_data_stockdaily
Field Name | Description |
date | Date of stock price (YYYY-MM-DD) |
symbol | Stock ticker symbol (e.g., AAPL) |
open | Opening price of the day |
high | Highest price during the day |
low | Lowest price during the day |
close | Closing price of the day |
volume | Trading volume of the day |
Metadata Table
alphavantage_meta_symbol (optional, static lookup)
Field Name | Description |
symbol | Ticker symbol (e.g., MSFT) |
name | Company name (if managed manually) |
sector | Sector/industry (optional) |
Import Schedule
Job Type | Frequency | Look-back Window | First Run (UTC) |
Stock Daily | 24 h | 1 day | 04:00 |
Meta Symbol | Manual or Scheduled | 0 | N/A |
Dimensions
No dimensions are predefined. Dimensions can be created using fields such as:
symboldate
Metrics (Derived Custom Metrics – Suggested)
These can be created post-import in your BI layer:
Metric Name | Formula | Description |
Average Close | AVG(alphavantage_data_stockdaily.close) | Avg daily close price |
Total Volume | SUM(alphavantage_data_stockdaily.volume) | Sum of volume over period |
Daily High Max | MAX(alphavantage_data_stockdaily.high) | Highest high in time range |
Daily Low Min | MIN(alphavantage_data_stockdaily.low) | Lowest low in time range |
Table Relationships
No joins or foreign key relationships are currently configured.
Optionally,
symbolcan be used to join withalphavantage_meta_symbol.symbol.
Summary
The Alphavantage connector pulls daily stock market data across multiple symbols. It supports a fully automated pipeline for pricing data and a manual or static table for symbol-level metadata. Ideal for financial dashboards or stock performance tracking.