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 = DGS2×source = fred_tier_a×value_raw = 0.50×

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

DGS2	2021-11-26	2021-11-29	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2021-11-01	2021-11-02	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2021-10-28	2021-10-29	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2021-10-27	2021-10-28	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-03-12	2020-03-13	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-03-11	2020-03-12	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2020-03-10	2020-03-11	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2015-04-16	2015-04-17	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2015-01-28	2015-01-29	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2014-10-31	2014-11-03	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2014-08-28	2014-08-29	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2014-07-23	2014-07-24	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2014-07-16	2014-07-17	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2014-06-20	2014-06-23	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2013-09-10	2013-09-11	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2011-07-01	2011-07-06	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2010-11-17	2010-11-19	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2010-09-15	2010-09-17	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2010-09-14	2010-09-16	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2010-09-02	2010-09-07	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2010-09-01	2010-09-03	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2010-08-30	2010-09-01	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2010-08-24	2010-08-26	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00
DGS2	2010-08-06	2010-08-10	9999-12-31	0.500000	0.50	fred_tier_a	/fred/series/observations	{"series_id":"DGS2","full_vintage":true}	2026-09-16	2026-09-16 06:00	2026-09-16 06:00