Alpha Vantage Connector Reference

The Alpha Vantage connector exposes 48 fields (41 metrics, 7 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Alpha Vantage Fields

Alpha Vantage time_series_daily fields

The time_series_daily report of the Alpha Vantage connector includes 5 fields.

ID	Type	Name	Description
time_series_daily__1_open	NUMERIC	time_series_daily.1. open	time_series_daily.1. open
time_series_daily__2_high	NUMERIC	time_series_daily.2. high	time_series_daily.2. high
time_series_daily__3_low	NUMERIC	time_series_daily.3. low	time_series_daily.3. low
time_series_daily__4_close	NUMERIC	time_series_daily.4. close	time_series_daily.4. close
time_series_daily__5_volume	NUMERIC	time_series_daily.5. volume	time_series_daily.5. volume

Alpha Vantage time_series_daily_adjusted fields

The time_series_daily_adjusted report of the Alpha Vantage connector includes 8 fields.

ID	Type	Name	Description
time_series_daily_adjusted__1_open	NUMERIC	time_series_daily_adjusted.1. open	time_series_daily_adjusted.1. open
time_series_daily_adjusted__2_high	NUMERIC	time_series_daily_adjusted.2. high	time_series_daily_adjusted.2. high
time_series_daily_adjusted__3_low	NUMERIC	time_series_daily_adjusted.3. low	time_series_daily_adjusted.3. low
time_series_daily_adjusted__4_close	NUMERIC	time_series_daily_adjusted.4. close	time_series_daily_adjusted.4. close
time_series_daily_adjusted__5_adjusted close	NUMERIC	time_series_daily_adjusted.5. adjusted close	time_series_daily_adjusted.5. adjusted close
time_series_daily_adjusted__6_volume	NUMERIC	time_series_daily_adjusted.6. volume	time_series_daily_adjusted.6. volume
time_series_daily_adjusted__7_dividend amount	NUMERIC	time_series_daily_adjusted.7. dividend amount	time_series_daily_adjusted.7. dividend amount
time_series_daily_adjusted__8_split coefficient	TEXT	time_series_daily_adjusted.8. split coefficient	time_series_daily_adjusted.8. split coefficient

Alpha Vantage time_series_intraday fields

The time_series_intraday report of the Alpha Vantage connector includes 5 fields.

ID	Type	Name	Description
time_series_intraday__1_open	NUMERIC	time_series_intraday.1. open	time_series_intraday.1. open
time_series_intraday__2_high	NUMERIC	time_series_intraday.2. high	time_series_intraday.2. high
time_series_intraday__3_low	NUMERIC	time_series_intraday.3. low	time_series_intraday.3. low
time_series_intraday__4_close	NUMERIC	time_series_intraday.4. close	time_series_intraday.4. close
time_series_intraday__5_volume	NUMERIC	time_series_intraday.5. volume	time_series_intraday.5. volume

Alpha Vantage time_series_monthly fields

The time_series_monthly report of the Alpha Vantage connector includes 5 fields.

ID	Type	Name	Description
time_series_monthly__1_open	NUMERIC	time_series_monthly.1. open	time_series_monthly.1. open
time_series_monthly__2_high	NUMERIC	time_series_monthly.2. high	time_series_monthly.2. high
time_series_monthly__3_low	NUMERIC	time_series_monthly.3. low	time_series_monthly.3. low
time_series_monthly__4_close	NUMERIC	time_series_monthly.4. close	time_series_monthly.4. close
time_series_monthly__5_volume	NUMERIC	time_series_monthly.5. volume	time_series_monthly.5. volume

Alpha Vantage time_series_monthly_adjusted fields

The time_series_monthly_adjusted report of the Alpha Vantage connector includes 7 fields.

ID	Type	Name	Description
time_series_monthly_adjusted__1_open	NUMERIC	time_series_monthly_adjusted.1. open	time_series_monthly_adjusted.1. open
time_series_monthly_adjusted__2_high	NUMERIC	time_series_monthly_adjusted.2. high	time_series_monthly_adjusted.2. high
time_series_monthly_adjusted__3_low	NUMERIC	time_series_monthly_adjusted.3. low	time_series_monthly_adjusted.3. low
time_series_monthly_adjusted__4_close	NUMERIC	time_series_monthly_adjusted.4. close	time_series_monthly_adjusted.4. close
time_series_monthly_adjusted__5_adjusted close	NUMERIC	time_series_monthly_adjusted.5. adjusted close	time_series_monthly_adjusted.5. adjusted close
time_series_monthly_adjusted__6_volume	NUMERIC	time_series_monthly_adjusted.6. volume	time_series_monthly_adjusted.6. volume
time_series_monthly_adjusted__7_dividend amount	NUMERIC	time_series_monthly_adjusted.7. dividend amount	time_series_monthly_adjusted.7. dividend amount

Alpha Vantage time_series_weekly fields

The time_series_weekly report of the Alpha Vantage connector includes 5 fields.

ID	Type	Name	Description
time_series_weekly__1_open	NUMERIC	time_series_weekly.1. open	time_series_weekly.1. open
time_series_weekly__2_high	NUMERIC	time_series_weekly.2. high	time_series_weekly.2. high
time_series_weekly__3_low	NUMERIC	time_series_weekly.3. low	time_series_weekly.3. low
time_series_weekly__4_close	NUMERIC	time_series_weekly.4. close	time_series_weekly.4. close
time_series_weekly__5_volume	NUMERIC	time_series_weekly.5. volume	time_series_weekly.5. volume

Alpha Vantage time_series_weekly_adjusted fields

The time_series_weekly_adjusted report of the Alpha Vantage connector includes 7 fields.

ID	Type	Name	Description
time_series_weekly_adjusted__1_open	NUMERIC	time_series_weekly_adjusted.1. open	time_series_weekly_adjusted.1. open
time_series_weekly_adjusted__2_high	NUMERIC	time_series_weekly_adjusted.2. high	time_series_weekly_adjusted.2. high
time_series_weekly_adjusted__3_low	NUMERIC	time_series_weekly_adjusted.3. low	time_series_weekly_adjusted.3. low
time_series_weekly_adjusted__4_close	NUMERIC	time_series_weekly_adjusted.4. close	time_series_weekly_adjusted.4. close
time_series_weekly_adjusted__5_adjusted close	NUMERIC	time_series_weekly_adjusted.5. adjusted close	time_series_weekly_adjusted.5. adjusted close
time_series_weekly_adjusted__6_volume	NUMERIC	time_series_weekly_adjusted.6. volume	time_series_weekly_adjusted.6. volume
time_series_weekly_adjusted__7_dividend amount	NUMERIC	time_series_weekly_adjusted.7. dividend amount	time_series_weekly_adjusted.7. dividend amount

Alpha Vantage other fields

The Alpha Vantage connector has 6 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
now	TIMESTAMP	Now	Current timestamp
quote__globalquote	TEXT	quote.Global Quote	quote.Global Quote	quote
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date