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

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

PCU334112334112	2013-10-01	2015-04-14	9999-12-31	61.200000	61.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2013-11-01	2015-04-14	9999-12-31	61.400000	61.4	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2013-12-01	2015-04-14	9999-12-31	61.000000	61.0	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2014-01-01	2015-04-14	9999-12-31	61.000000	61.0	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2014-02-01	2015-04-14	9999-12-31	60.800000	60.8	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2014-03-01	2015-04-14	9999-12-31	60.800000	60.8	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2014-04-01	2015-04-14	9999-12-31	60.800000	60.8	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2014-05-01	2015-04-14	9999-12-31	60.700000	60.7	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2014-06-01	2015-04-14	9999-12-31	60.700000	60.7	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2014-07-01	2015-04-14	9999-12-31	60.700000	60.7	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2014-08-01	2015-04-14	9999-12-31	60.200000	60.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2014-09-01	2015-04-14	9999-12-31	60.200000	60.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2014-10-01	2015-04-14	9999-12-31	60.200000	60.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2014-11-01	2015-04-14	9999-12-31	60.100000	60.1	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2014-12-01	2015-05-14	9999-12-31	60.100000	60.1	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2014-12-01	2015-04-14	2015-05-13	60.200000	60.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-01-01	2015-06-12	9999-12-31	60.100000	60.1	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-01-01	2015-04-14	2015-06-11	60.300000	60.3	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-02-01	2015-07-15	9999-12-31	59.200000	59.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-02-01	2015-04-14	2015-07-14	59.500000	59.5	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-03-01	2015-08-14	9999-12-31	59.200000	59.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-03-01	2015-04-14	2015-08-13	59.500000	59.5	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-04-01	2015-09-11	9999-12-31	59.200000	59.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-04-01	2015-05-14	2015-09-10	59.500000	59.5	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-05-01	2015-10-14	9999-12-31	58.200000	58.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-05-01	2015-06-12	2015-10-13	59.200000	59.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-06-01	2015-11-13	9999-12-31	58.200000	58.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-06-01	2015-07-15	2015-11-12	58.100000	58.1	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-07-01	2015-08-14	9999-12-31	58.100000	58.1	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-08-01	2015-09-11	9999-12-31	58.100000	58.1	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-09-01	2016-02-17	9999-12-31	58.100000	58.1	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-09-01	2015-10-14	2016-02-16	57.900000	57.9	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-10-01	2016-03-15	9999-12-31	58.000000	58.0	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-10-01	2015-11-13	2016-03-14	57.200000	57.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-11-01	2015-12-11	9999-12-31	58.000000	58.0	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2015-12-01	2016-01-15	9999-12-31	58.000000	58.0	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-01-01	2016-02-17	9999-12-31	57.900000	57.9	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-02-01	2016-03-15	9999-12-31	57.800000	57.8	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-03-01	2016-04-13	9999-12-31	57.500000	57.5	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-04-01	2016-05-13	9999-12-31	57.500000	57.5	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-05-01	2016-10-14	9999-12-31	59.200000	59.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-05-01	2016-06-15	2016-10-13	59.300000	59.3	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-06-01	2016-11-16	9999-12-31	59.100000	59.1	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-06-01	2016-07-14	2016-11-15	59.200000	59.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-07-01	2016-12-14	9999-12-31	59.100000	59.1	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-07-01	2016-08-12	2016-12-13	59.200000	59.2	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-08-01	2016-09-15	9999-12-31	59.100000	59.1	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-09-01	2016-10-14	9999-12-31	59.100000	59.1	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-10-01	2016-11-16	9999-12-31	59.100000	59.1	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00
PCU334112334112	2016-11-01	2016-12-14	9999-12-31	58.300000	58.3	fred_tier_a	/fred/series/observations	{"series_id":"PCU334112334112","full_vintage":true}	2026-10-01	2026-10-01 06:00	2026-10-01 06:00