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

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

Sources in this table

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

active:series_id = EFFR×source = fred_tier_a×value_raw = 1.02×

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

EFFR	2004-06-23	2016-03-01	9999-12-31	1.020000	1.02	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-14	2016-03-01	9999-12-31	1.020000	1.02	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-01	2016-03-01	9999-12-31	1.020000	1.02	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-28	2016-03-01	9999-12-31	1.020000	1.02	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-14	2016-03-01	9999-12-31	1.020000	1.02	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-08	2016-03-01	9999-12-31	1.020000	1.02	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-25	2016-03-01	9999-12-31	1.020000	1.02	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-25	2016-03-01	9999-12-31	1.020000	1.02	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-17	2016-03-01	9999-12-31	1.020000	1.02	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-12	2016-03-01	9999-12-31	1.020000	1.02	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-27	2016-03-01	9999-12-31	1.020000	1.02	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-22	2016-03-01	9999-12-31	1.020000	1.02	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-20	2016-03-01	9999-12-31	1.020000	1.02	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-22	2016-03-01	9999-12-31	1.020000	1.02	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-25	2016-03-01	9999-12-31	1.020000	1.02	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-03	2016-03-01	9999-12-31	1.020000	1.02	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-10-23	2016-03-01	9999-12-31	1.020000	1.02	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-10-20	2016-03-01	9999-12-31	1.020000	1.02	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-10-09	2016-03-01	9999-12-31	1.020000	1.02	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-10-02	2016-03-01	9999-12-31	1.020000	1.02	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-22	2016-03-01	9999-12-31	1.020000	1.02	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-12	2016-03-01	9999-12-31	1.020000	1.02	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-11	2016-03-01	9999-12-31	1.020000	1.02	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-07-21	2016-03-01	9999-12-31	1.020000	1.02	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-07-17	2016-03-01	9999-12-31	1.020000	1.02	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