FRED / ALFRED vintages

core.fred_observations

MIXED LICENCE. Holds the ICE BofA credit spreads, which may not be redistributed, alongside the ALFRED Tier A macro series, which may. Export is filtered per row on `source`; browsing is not.

140,329 rowsCSV (136,251 of 140,329 rows) — whole table, not this view

Sources in this table

fred_ice_oas4,078 rows
fred_tier_a136,251 rows

active:series_id = DGS2×value_raw = 0.19×sorted by observation_date ↑×

observation_date leads no index, so this sort reads every matching row and keeps only the top 50 in a heap (the page LIMIT), under a 5s statement timeout.

series_idtext	observation_date ↑date	realtime_startdate	realtime_enddate	valuenumeric	value_rawtext	sourcetext	endpointtext	request_params

DGS2	2011-08-09	2011-08-11	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2011-08-10	2011-08-12	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2011-08-11	2011-08-15	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2011-08-15	2011-08-17	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2011-08-17	2011-08-19	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2011-09-01	2011-09-06	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2011-09-08	2011-09-12	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2011-09-14	2011-09-16	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-05-04	2020-05-05	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-05-05	2020-05-06	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-05-27	2020-05-28	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-06-03	2020-06-04	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-06-04	2020-06-05	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-06-11	2020-06-12	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-06-12	2020-06-15	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-06-15	2020-06-16	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-06-17	2020-06-18	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-06-18	2020-06-19	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-06-19	2020-06-22	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-06-22	2020-06-23	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-06-24	2020-06-25	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-11-10	2020-11-12	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-11-16	2020-11-17	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2021-04-02	2021-04-05	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2021-07-08	2021-07-09	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2021-07-30	2021-08-02	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00