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

observation_date leads no index, so this sort reads every matching row and keeps only the top 1,450 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

UNRATE	1972-08-01	1977-02-04	9999-12-31	5.600000	5.6	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-08-01	1976-02-06	1977-02-03	5.700000	5.7	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-08-01	1972-09-01	1976-02-05	5.600000	5.6	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-07-01	1973-02-02	9999-12-31	5.600000	5.6	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-07-01	1972-08-04	1973-02-01	5.500000	5.5	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-06-01	1982-02-05	9999-12-31	5.700000	5.7	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-06-01	1974-02-01	1982-02-04	5.600000	5.6	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-06-01	1972-07-07	1974-01-31	5.500000	5.5	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-05-01	1982-02-05	9999-12-31	5.700000	5.7	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-05-01	1976-02-06	1982-02-04	5.600000	5.6	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-05-01	1974-02-01	1976-02-05	5.700000	5.7	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-05-01	1973-02-02	1974-01-31	5.800000	5.8	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-05-01	1972-06-02	1973-02-01	5.900000	5.9	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-04-01	1975-02-07	9999-12-31	5.700000	5.7	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-04-01	1973-02-02	1975-02-06	5.800000	5.8	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-04-01	1972-05-05	1973-02-01	5.900000	5.9	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-03-01	1975-02-07	9999-12-31	5.800000	5.8	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-03-01	1972-04-07	1975-02-06	5.900000	5.9	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-02-01	1975-02-07	9999-12-31	5.700000	5.7	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-02-01	1973-02-02	1975-02-06	5.800000	5.8	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-02-01	1972-03-03	1973-02-01	5.700000	5.7	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-01-01	1976-02-06	9999-12-31	5.800000	5.8	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1972-01-01	1972-02-04	1976-02-05	5.900000	5.9	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-12-01	1975-02-07	9999-12-31	6.000000	6.0	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-12-01	1974-02-01	1975-02-06	5.900000	5.9	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-12-01	1972-02-04	1974-01-31	6.000000	6.0	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-12-01	1972-01-07	1972-02-03	6.100000	6.1	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-11-01	1971-12-03	9999-12-31	6.000000	6.0	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-10-01	1982-02-05	9999-12-31	5.800000	5.8	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-10-01	1973-02-02	1982-02-04	5.900000	5.9	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-10-01	1971-11-05	1973-02-01	5.800000	5.8	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-09-01	1976-02-06	9999-12-31	6.000000	6.0	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-09-01	1973-02-02	1976-02-05	5.900000	5.9	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-09-01	1971-10-08	1973-02-01	6.000000	6.0	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-08-01	1975-02-07	9999-12-31	6.100000	6.1	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-08-01	1974-02-01	1975-02-06	6.000000	6.0	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-08-01	1971-09-03	1974-01-31	6.100000	6.1	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-07-01	1976-02-06	9999-12-31	6.000000	6.0	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-07-01	1972-02-04	1976-02-05	5.900000	5.9	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-07-01	1971-08-06	1972-02-03	5.800000	5.8	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-06-01	1976-02-06	9999-12-31	5.900000	5.9	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-06-01	1972-02-04	1976-02-05	5.800000	5.8	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-06-01	1971-07-02	1972-02-03	5.600000	5.6	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-05-01	1976-02-06	9999-12-31	5.900000	5.9	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-05-01	1973-02-02	1976-02-05	6.000000	6.0	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-05-01	1972-02-04	1973-02-01	6.100000	6.1	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-05-01	1971-06-04	1972-02-03	6.200000	6.2	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-04-01	1973-02-02	9999-12-31	5.900000	5.9	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-04-01	1972-02-04	1973-02-01	6.000000	6.0	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
UNRATE	1971-04-01	1971-05-07	1972-02-03	6.100000	6.1	fred_tier_a	/fred/series/observations	{"series_id":"UNRATE","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44