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.30×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-08-25	2011-04-06	9999-12-31	19.300000	19.30	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-06-12	2011-04-06	9999-12-31	19.300000	19.30	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-02-17	2011-04-06	9999-12-31	19.300000	19.30	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	1994-07-06	2011-04-06	9999-12-31	19.300000	19.30	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-02-28	2011-04-06	2026-09-15	19.300000	19.30	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-06-17	2011-04-06	9999-12-31	19.300000	19.30	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-15	2011-04-06	9999-12-31	19.300000	19.30	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	2001-12-21	2011-04-06	9999-12-31	19.300000	19.30	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-29	2011-04-06	9999-12-31	19.300000	19.30	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