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

This table holds sources under different licences. The CSV contains 111,461 of 115,494 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,461 rowsexportable

active:series_id = EFFR×value_raw = 0.98×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_paramsjsonb

EFFR	2003-07-11	2016-03-01	9999-12-31	0.980000	0.98	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-27	2016-03-01	9999-12-31	0.980000	0.98	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-04	2016-03-01	9999-12-31	0.980000	0.98	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-07	2016-03-01	9999-12-31	0.980000	0.98	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-17	2016-03-01	9999-12-31	0.980000	0.98	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-28	2016-03-01	9999-12-31	0.980000	0.98	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-04	2016-03-01	9999-12-31	0.980000	0.98	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-05	2016-03-01	9999-12-31	0.980000	0.98	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-07	2016-03-01	9999-12-31	0.980000	0.98	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-14	2016-03-01	9999-12-31	0.980000	0.98	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-18	2016-03-01	9999-12-31	0.980000	0.98	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-19	2016-03-01	9999-12-31	0.980000	0.98	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-21	2016-03-01	9999-12-31	0.980000	0.98	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-24	2016-03-01	9999-12-31	0.980000	0.98	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-03	2016-03-01	9999-12-31	0.980000	0.98	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-05	2016-03-01	9999-12-31	0.980000	0.98	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-19	2016-03-01	9999-12-31	0.980000	0.98	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-29	2016-03-01	9999-12-31	0.980000	0.98	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-16	2016-03-01	9999-12-31	0.980000	0.98	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-30	2016-03-01	9999-12-31	0.980000	0.98	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-12	2016-03-01	9999-12-31	0.980000	0.98	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-02	2016-03-01	9999-12-31	0.980000	0.98	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