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 = DEXTAUS×sorted by observation_date ↑×

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

DEXTAUS	1985-06-24	2014-03-18	9999-12-31	39.910000	39.910	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-06-25	2014-03-18	9999-12-31	39.970000	39.970	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-06-26	2014-03-18	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-06-27	2014-03-18	9999-12-31	40.060000	40.060	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-06-28	2014-03-18	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-01	2014-03-18	9999-12-31	39.950000	39.950	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-02	2014-03-18	9999-12-31	40.050000	40.050	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-03	2014-03-18	9999-12-31	40.050000	40.050	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-04	2014-03-18	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-05	2014-03-18	9999-12-31	40.050000	40.050	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-08	2014-03-18	9999-12-31	40.050000	40.050	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-09	2014-03-18	9999-12-31	40.050000	40.050	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-10	2014-03-18	9999-12-31	40.080000	40.080	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-11	2014-03-18	9999-12-31	40.110000	40.110	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-12	2014-03-18	9999-12-31	40.070000	40.070	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-15	2014-03-18	9999-12-31	40.050000	40.050	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-16	2014-03-18	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-17	2014-03-18	9999-12-31	40.050000	40.050	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-18	2014-03-18	9999-12-31	40.050000	40.050	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-19	2014-03-18	9999-12-31	40.060000	40.060	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-22	2014-03-18	9999-12-31	40.110000	40.110	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-23	2014-03-18	9999-12-31	40.240000	40.240	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-24	2014-03-18	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-25	2014-03-18	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-26	2014-03-18	9999-12-31	40.430000	40.430	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-29	2014-03-18	9999-12-31	40.400000	40.400	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-30	2014-03-18	9999-12-31	40.380000	40.380	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-07-31	2014-03-18	9999-12-31	40.360000	40.360	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-01	2014-03-18	9999-12-31	40.340000	40.340	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-02	2014-03-18	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-05	2014-03-18	9999-12-31	40.440000	40.440	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-06	2014-03-18	9999-12-31	40.420000	40.420	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-07	2014-03-18	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-08	2014-03-18	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-09	2014-03-18	9999-12-31	40.460000	40.460	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-12	2014-03-18	9999-12-31	40.560000	40.560	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-13	2014-03-18	9999-12-31	40.530000	40.530	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-14	2014-03-18	9999-12-31	40.540000	40.540	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-15	2014-03-18	9999-12-31	40.580000	40.580	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-16	2014-03-18	9999-12-31	40.600000	40.600	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-19	2014-03-18	9999-12-31	40.570000	40.570	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-20	2014-03-18	9999-12-31	40.550000	40.550	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-21	2014-03-18	9999-12-31	40.520000	40.520	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-22	2014-03-18	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-23	2014-03-18	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-26	2014-03-18	9999-12-31	40.460000	40.460	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-27	2014-03-18	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-28	2014-03-18	9999-12-31	40.460000	40.460	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-29	2014-03-18	9999-12-31	40.490000	40.490	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DEXTAUS	1985-08-30	2014-03-18	9999-12-31	40.490000	40.490	fred_tier_a	/fred/series/observations	{"series_id":"DEXTAUS","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00