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.77×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-09-21	2011-04-06	9999-12-31	19.770000	19.77	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-08	2011-04-06	9999-12-31	19.770000	19.77	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-15	2011-04-06	9999-12-31	19.770000	19.77	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-09-08	2011-04-06	9999-12-31	19.770000	19.77	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-09-11	2011-04-06	9999-12-31	19.770000	19.77	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	1992-12-28	2011-04-06	9999-12-31	19.770000	19.77	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-06-03	2011-04-06	9999-12-31	19.770000	19.77	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	1996-05-31	2011-04-06	9999-12-31	19.770000	19.77	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-02-06	2011-04-06	9999-12-31	19.770000	19.77	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