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 = DCOILWTICO×value_raw = 19.67×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

DCOILWTICO	1987-10-09	2011-04-06	9999-12-31	19.670000	19.67	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-10-12	2011-04-06	9999-12-31	19.670000	19.67	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1989-10-23	2011-04-06	9999-12-31	19.670000	19.67	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1993-01-26	2011-04-06	9999-12-31	19.670000	19.67	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1995-04-07	2011-04-06	9999-12-31	19.670000	19.67	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1995-05-09	2011-04-06	9999-12-31	19.670000	19.67	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1997-07-08	2011-04-06	9999-12-31	19.670000	19.67	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1997-07-28	2011-04-06	9999-12-31	19.670000	19.67	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1997-09-16	2011-04-06	9999-12-31	19.670000	19.67	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	2002-01-11	2011-04-06	9999-12-31	19.670000	19.67	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00