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 = WRESBAL×sorted by observation_date ↑×

observation_date leads no index, so this sort reads every matching row and keeps only the top 1,500 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_paramsjsonb

WRESBAL	1997-11-26	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1997-11-26	2004-09-02	2025-11-12	9.346000	9.346	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1997-12-03	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1997-12-03	2004-09-02	2025-11-12	12.677000	12.677	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1997-12-10	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1997-12-10	2004-09-02	2025-11-12	10.031000	10.031	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1997-12-17	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1997-12-17	2004-09-02	2025-11-12	9.355000	9.355	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1997-12-24	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1997-12-24	2004-09-02	2025-11-12	11.330000	11.330	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1997-12-31	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1997-12-31	2004-09-02	2025-11-12	11.824000	11.824	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-01-07	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-01-07	2004-09-02	2025-11-12	13.329000	13.329	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-01-14	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-01-14	2004-09-02	2025-11-12	9.761000	9.761	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-01-21	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-01-21	2004-09-02	2025-11-12	6.410000	6.410	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-01-28	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-01-28	2004-09-02	2025-11-12	9.759000	9.759	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-02-04	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-02-04	2004-09-02	2025-11-12	10.003000	10.003	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-02-11	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-02-11	2004-09-02	2025-11-12	7.504000	7.504	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-02-18	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-02-18	2004-09-02	2025-11-12	8.570000	8.570	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-02-25	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-02-25	2004-09-02	2025-11-12	10.977000	10.977	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-03-04	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-03-04	2004-09-02	2025-11-12	9.981000	9.981	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-03-11	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-03-11	2004-09-02	2025-11-12	10.402000	10.402	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-03-18	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-03-18	2004-09-02	2025-11-12	10.055000	10.055	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-03-25	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-03-25	2004-09-02	2025-11-12	9.706000	9.706	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-04-01	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-04-01	2004-09-02	2025-11-12	11.850000	11.850	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-04-08	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-04-08	2004-09-02	2025-11-12	9.403000	9.403	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-04-15	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-04-15	2004-09-02	2025-11-12	10.645000	10.645	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-04-22	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-04-22	2004-09-02	2025-11-12	13.356000	13.356	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-04-29	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-04-29	2004-09-02	2025-11-12	9.706000	9.706	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-05-06	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-05-06	2004-09-02	2025-11-12	9.977000	9.977	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-05-13	2025-11-13	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WRESBAL	1998-05-13	2004-09-02	2025-11-12	6.600000	6.600	fred_tier_a	/fred/series/observations	{"series_id":"WRESBAL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44