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 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

DCOILWTICO	1987-08-06	2011-04-06	9999-12-31	21.170000	21.17	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-08-07	2011-04-06	9999-12-31	21.010000	21.01	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-08-10	2011-04-06	9999-12-31	20.700000	20.70	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-08-11	2011-04-06	9999-12-31	21.070000	21.07	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-08-12	2011-04-06	9999-12-31	20.960000	20.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-08-13	2011-04-06	9999-12-31	20.760000	20.76	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-08-14	2011-04-06	9999-12-31	20.530000	20.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-08-17	2011-04-06	9999-12-31	19.850000	19.85	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-08-18	2011-04-06	9999-12-31	19.840000	19.84	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-08-19	2011-04-06	9999-12-31	19.710000	19.71	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-08-20	2011-04-06	9999-12-31	19.470000	19.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-08-21	2011-04-06	9999-12-31	19.200000	19.20	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-08-24	2011-04-06	9999-12-31	19.180000	19.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-08-25	2011-04-06	9999-12-31	19.300000	19.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-08-26	2011-04-06	9999-12-31	19.490000	19.49	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-08-27	2011-04-06	9999-12-31	19.690000	19.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-08-28	2011-04-06	9999-12-31	19.440000	19.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-08-31	2011-04-06	9999-12-31	19.760000	19.76	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-09-01	2011-04-06	9999-12-31	19.610000	19.61	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-09-02	2011-04-06	9999-12-31	19.620000	19.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-09-03	2011-04-06	9999-12-31	19.480000	19.48	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-09-04	2011-04-06	9999-12-31	19.340000	19.34	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-09-07	2011-04-06	9999-12-31	19.340000	19.34	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-09-08	2011-04-06	9999-12-31	18.990000	18.99	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-09-09	2011-04-06	9999-12-31	19.430000	19.43	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-09-10	2011-04-06	9999-12-31	19.720000	19.72	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-09-11	2011-04-06	9999-12-31	19.420000	19.42	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-09-14	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-09-15	2011-04-06	9999-12-31	19.660000	19.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-09-16	2011-04-06	9999-12-31	19.710000	19.71	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-09-17	2011-04-06	9999-12-31	19.580000	19.58	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-09-18	2011-04-06	9999-12-31	19.580000	19.58	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-09-21	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-09-22	2011-04-06	9999-12-31	19.350000	19.35	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-09-23	2011-04-06	9999-12-31	19.660000	19.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-09-24	2011-04-06	9999-12-31	19.610000	19.61	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-09-25	2011-04-06	9999-12-31	19.470000	19.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-09-28	2011-04-06	9999-12-31	19.480000	19.48	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-09-29	2011-04-06	9999-12-31	19.580000	19.58	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-09-30	2011-04-06	9999-12-31	19.620000	19.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-10-01	2011-04-06	9999-12-31	19.620000	19.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-10-02	2011-04-06	9999-12-31	19.880000	19.88	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-05	2011-04-06	9999-12-31	19.810000	19.81	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-06	2011-04-06	9999-12-31	19.330000	19.33	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-07	2011-04-06	9999-12-31	19.680000	19.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-10-08	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-09	2011-04-06	9999-12-31	19.670000	19.67	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-12	2011-04-06	9999-12-31	19.670000	19.67	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-13	2011-04-06	9999-12-31	19.660000	19.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-10-14	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