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

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

DCOILWTICO	1987-10-15	2011-04-06	9999-12-31	19.770000	19.77	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-10-16	2011-04-06	9999-12-31	20.230000	20.23	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-10-19	2011-04-06	9999-12-31	19.790000	19.79	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-10-20	2011-04-06	9999-12-31	19.790000	19.79	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-10-21	2011-04-06	9999-12-31	19.930000	19.93	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-10-22	2011-04-06	9999-12-31	20.190000	20.19	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-10-23	2011-04-06	9999-12-31	20.180000	20.18	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-10-26	2011-04-06	9999-12-31	20.000000	20.00	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-10-27	2011-04-06	9999-12-31	20.150000	20.15	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-10-28	2011-04-06	9999-12-31	20.100000	20.10	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-10-29	2011-04-06	9999-12-31	19.930000	19.93	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-10-30	2026-09-16	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-10-30	2011-04-06	2026-09-15	19.960000	19.96	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-02	2011-04-06	9999-12-31	19.640000	19.64	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-03	2011-04-06	9999-12-31	19.390000	19.39	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-04	2011-04-06	9999-12-31	19.090000	19.09	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-05	2011-04-06	9999-12-31	19.020000	19.02	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-06	2011-04-06	9999-12-31	18.730000	18.73	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-09	2011-04-06	9999-12-31	18.660000	18.66	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-10	2011-04-06	9999-12-31	18.980000	18.98	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-11	2011-04-06	9999-12-31	18.920000	18.92	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-12	2011-04-06	9999-12-31	18.930000	18.93	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-13	2011-04-06	9999-12-31	18.890000	18.89	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-16	2011-04-06	9999-12-31	18.690000	18.69	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-17	2011-04-06	9999-12-31	18.280000	18.28	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-18	2011-04-06	9999-12-31	18.620000	18.62	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-19	2011-04-06	9999-12-31	18.550000	18.55	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-20	2011-04-06	9999-12-31	18.870000	18.87	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-23	2011-04-06	9999-12-31	19.310000	19.31	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-24	2011-04-06	9999-12-31	18.730000	18.73	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-25	2011-04-06	9999-12-31	18.630000	18.63	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-26	2013-11-06	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-27	2011-04-06	9999-12-31	18.630000	18.63	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-11-30	2011-04-06	9999-12-31	18.520000	18.52	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-01	2011-04-06	9999-12-31	18.440000	18.44	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-02	2011-04-06	9999-12-31	18.590000	18.59	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-03	2026-09-16	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-03	2011-04-06	2026-09-15	18.870000	18.87	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-04	2011-04-06	9999-12-31	18.680000	18.68	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-07	2011-04-06	9999-12-31	18.300000	18.30	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-08	2011-04-06	9999-12-31	18.060000	18.06	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-09	2011-04-06	9999-12-31	18.530000	18.53	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-10	2026-09-16	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-10	2011-04-06	2026-09-15	18.510000	18.51	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-11	2026-09-16	9999-12-31	—	.	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-11	2011-04-06	2026-09-15	18.310000	18.31	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-14	2011-04-06	9999-12-31	17.470000	17.47	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-15	2011-04-06	9999-12-31	16.750000	16.75	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-16	2011-04-06	9999-12-31	15.970000	15.97	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00
DCOILWTICO	1987-12-17	2011-04-06	9999-12-31	15.970000	15.97	fred_tier_a	/fred/series/observations	{"series_id":"DCOILWTICO","full_vintage":true}	2026-09-28	2026-09-28 06:00	2026-09-28 06:00