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.

115,521 rowsCSV (111,473 exportable rows) — whole table, not this view

This table holds sources under different licences. The CSV contains 111,473 of 115,521 rows; fred_ice_oas is excluded. Browsing here is not redistribution — exporting is.

Sources in this table

fred_ice_oas4,048 rowsrestricted — hover for the licence
fred_tier_a111,473 rowsexportable

active:series_id = EFFR×value_raw = 1.00×

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	2004-06-22	2016-03-01	9999-12-31	1.000000	1.00	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	2004-06-21	2016-03-01	9999-12-31	1.000000	1.00	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	2004-06-18	2016-03-01	9999-12-31	1.000000	1.00	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	2004-06-16	2016-03-01	9999-12-31	1.000000	1.00	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	2004-06-11	2016-03-01	9999-12-31	1.000000	1.00	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	2004-06-10	2016-03-01	9999-12-31	1.000000	1.00	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	2004-05-27	2016-03-01	9999-12-31	1.000000	1.00	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	2004-05-25	2016-03-01	9999-12-31	1.000000	1.00	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	2004-05-24	2016-03-01	9999-12-31	1.000000	1.00	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	2004-05-20	2016-03-01	9999-12-31	1.000000	1.00	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	2004-05-19	2016-03-01	9999-12-31	1.000000	1.00	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	2004-05-18	2016-03-01	9999-12-31	1.000000	1.00	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	2004-05-13	2016-03-01	9999-12-31	1.000000	1.00	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	2004-05-10	2016-03-01	9999-12-31	1.000000	1.00	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	2004-05-06	2016-03-01	9999-12-31	1.000000	1.00	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	2004-05-04	2016-03-01	9999-12-31	1.000000	1.00	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	2004-04-22	2016-03-01	9999-12-31	1.000000	1.00	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	2004-04-19	2016-03-01	9999-12-31	1.000000	1.00	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	2004-04-13	2016-03-01	9999-12-31	1.000000	1.00	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	2004-04-12	2016-03-01	9999-12-31	1.000000	1.00	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	2004-04-07	2016-03-01	9999-12-31	1.000000	1.00	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	2004-04-06	2016-03-01	9999-12-31	1.000000	1.00	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	2004-04-02	2016-03-01	9999-12-31	1.000000	1.00	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	2004-03-29	2016-03-01	9999-12-31	1.000000	1.00	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	2004-03-26	2016-03-01	9999-12-31	1.000000	1.00	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	2004-03-18	2016-03-01	9999-12-31	1.000000	1.00	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	2004-03-17	2016-03-01	9999-12-31	1.000000	1.00	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	2004-03-10	2016-03-01	9999-12-31	1.000000	1.00	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	2004-03-08	2016-03-01	9999-12-31	1.000000	1.00	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	2004-03-05	2016-03-01	9999-12-31	1.000000	1.00	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	2004-03-03	2016-03-01	9999-12-31	1.000000	1.00	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	2004-03-02	2016-03-01	9999-12-31	1.000000	1.00	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	2004-02-23	2016-03-01	9999-12-31	1.000000	1.00	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	2004-02-19	2016-03-01	9999-12-31	1.000000	1.00	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	2004-02-18	2016-03-01	9999-12-31	1.000000	1.00	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	2004-02-11	2016-03-01	9999-12-31	1.000000	1.00	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	2004-02-10	2016-03-01	9999-12-31	1.000000	1.00	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	2004-02-04	2016-03-01	9999-12-31	1.000000	1.00	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	2004-01-29	2016-03-01	9999-12-31	1.000000	1.00	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	2004-01-23	2016-03-01	9999-12-31	1.000000	1.00	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	2004-01-21	2016-03-01	9999-12-31	1.000000	1.00	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	2004-01-12	2016-03-01	9999-12-31	1.000000	1.00	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	2003-12-23	2016-03-01	9999-12-31	1.000000	1.00	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	2003-11-20	2016-03-01	9999-12-31	1.000000	1.00	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	2003-11-12	2016-03-01	9999-12-31	1.000000	1.00	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	2003-11-06	2016-03-01	9999-12-31	1.000000	1.00	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	2003-09-18	2016-03-01	9999-12-31	1.000000	1.00	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	2003-09-11	2016-03-01	9999-12-31	1.000000	1.00	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	2003-08-26	2016-03-01	9999-12-31	1.000000	1.00	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	2003-08-04	2016-03-01	9999-12-31	1.000000	1.00	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