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,500 rowsCSV (111,467 exportable rows) — whole table, not this view

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

Sources in this table

fred_ice_oas4,033 rowsrestricted — hover for the licence
fred_tier_a111,467 rowsexportable

active:series_id = EFFR×value_raw = 1.72×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	2002-01-03	2016-03-01	9999-12-31	1.720000	1.72	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	2002-02-12	2016-03-01	9999-12-31	1.720000	1.72	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	2002-04-08	2016-03-01	9999-12-31	1.720000	1.72	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	2002-05-07	2016-03-01	9999-12-31	1.720000	1.72	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	2002-05-20	2016-03-01	9999-12-31	1.720000	1.72	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	2002-06-11	2016-03-01	9999-12-31	1.720000	1.72	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	2002-07-02	2016-03-01	9999-12-31	1.720000	1.72	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	2002-07-05	2016-03-01	9999-12-31	1.720000	1.72	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	2002-07-09	2016-03-01	9999-12-31	1.720000	1.72	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	2002-07-16	2016-03-01	9999-12-31	1.720000	1.72	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	2002-07-19	2016-03-01	9999-12-31	1.720000	1.72	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	2002-08-02	2016-03-01	9999-12-31	1.720000	1.72	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	2002-08-19	2016-03-01	9999-12-31	1.720000	1.72	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	2002-08-21	2016-03-01	9999-12-31	1.720000	1.72	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	2002-08-23	2016-03-01	9999-12-31	1.720000	1.72	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	2002-09-11	2016-03-01	9999-12-31	1.720000	1.72	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	2002-09-13	2016-03-01	9999-12-31	1.720000	1.72	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	2002-09-17	2016-03-01	9999-12-31	1.720000	1.72	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	2002-10-04	2016-03-01	9999-12-31	1.720000	1.72	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	2002-10-08	2016-03-01	9999-12-31	1.720000	1.72	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	2002-10-30	2016-03-01	9999-12-31	1.720000	1.72	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-09-28	2016-03-01	9999-12-31	1.720000	1.72	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-10-19	2016-03-01	9999-12-31	1.720000	1.72	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-10-22	2016-03-01	9999-12-31	1.720000	1.72	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-10-26	2016-03-01	9999-12-31	1.720000	1.72	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