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 = EFFR×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

EFFR	2009-01-16	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2009-01-26	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2009-01-28	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2009-02-23	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2009-03-11	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2009-05-29	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2009-06-25	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-04-07	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-04-08	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-04-09	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-04-12	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-04-29	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-05-28	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-06-03	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-06-04	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-06-07	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-06-08	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-06-15	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-06-16	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-06-17	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-07-15	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-07-16	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-07-19	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-07-23	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-07-26	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-07-27	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-07-29	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-08-02	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-08-03	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-08-04	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-08-05	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-08-13	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-08-18	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-08-19	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-08-23	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-08-24	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-08-25	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-08-26	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-08-27	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-08-30	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-09-01	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-09-02	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-09-03	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-09-08	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-09-14	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-09-27	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-09-28	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-09-29	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-10-06	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
EFFR	2010-10-14	2016-03-01	9999-12-31	0.190000	0.19	fred_tier_a	/fred/series/observations	{"series_id":"EFFR","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00