Alpha Vantage Connector Reference

41 metrics7 dimensions

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