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×

observation_date leads no index, so this sort reads every matching row and keeps only the top 850 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	2023-09-04	2023-09-11	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	2023-09-01	2023-09-05	9999-12-31	31.870000	31.87	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	2023-08-31	2023-09-05	9999-12-31	31.870000	31.87	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	2023-08-30	2023-09-05	9999-12-31	31.820000	31.82	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	2023-08-29	2023-09-05	9999-12-31	31.850000	31.85	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	2023-08-28	2023-09-05	9999-12-31	31.880000	31.88	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	2023-08-25	2023-08-28	9999-12-31	31.800000	31.8	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	2023-08-24	2023-08-28	9999-12-31	31.820000	31.82	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	2023-08-23	2023-08-28	9999-12-31	31.870000	31.87	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	2023-08-22	2023-08-28	9999-12-31	31.980000	31.98	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	2023-08-21	2023-08-28	9999-12-31	31.930000	31.93	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	2023-08-18	2023-08-21	9999-12-31	31.910000	31.91	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	2023-08-17	2023-08-21	9999-12-31	31.950000	31.95	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	2023-08-16	2023-08-21	9999-12-31	31.960000	31.96	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	2023-08-15	2023-08-21	9999-12-31	31.910000	31.91	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	2023-08-14	2023-08-21	9999-12-31	31.940000	31.94	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	2023-08-11	2023-08-14	9999-12-31	31.870000	31.87	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	2023-08-10	2023-08-14	9999-12-31	31.780000	31.78	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	2023-08-09	2023-08-14	9999-12-31	31.770000	31.77	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	2023-08-08	2023-08-14	9999-12-31	31.850000	31.85	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	2023-08-07	2023-08-14	9999-12-31	31.710000	31.71	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	2023-08-04	2023-08-07	9999-12-31	31.630000	31.63	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	2023-08-03	2023-08-07	9999-12-31	31.650000	31.65	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	2023-08-02	2023-08-07	9999-12-31	31.640000	31.64	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	2023-08-01	2023-08-07	9999-12-31	31.560000	31.56	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	2023-07-31	2023-08-07	9999-12-31	31.450000	31.45	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	2023-07-28	2023-07-31	9999-12-31	31.400000	31.4	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	2023-07-27	2023-07-31	9999-12-31	31.320000	31.32	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	2023-07-26	2023-07-31	9999-12-31	31.190000	31.19	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	2023-07-25	2023-07-31	9999-12-31	31.290000	31.29	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	2023-07-24	2023-07-31	9999-12-31	31.360000	31.36	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	2023-07-21	2023-07-24	9999-12-31	31.250000	31.25	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	2023-07-20	2023-07-24	9999-12-31	31.090000	31.09	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	2023-07-19	2023-07-24	9999-12-31	31.130000	31.13	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	2023-07-18	2023-07-24	9999-12-31	30.960000	30.96	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	2023-07-17	2023-07-24	9999-12-31	31.020000	31.02	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	2023-07-14	2023-07-17	9999-12-31	30.900000	30.9	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	2023-07-13	2023-07-17	9999-12-31	30.940000	30.94	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	2023-07-12	2023-07-17	9999-12-31	31.240000	31.24	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	2023-07-11	2023-07-17	9999-12-31	31.300000	31.3	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	2023-07-10	2023-07-17	9999-12-31	31.370000	31.37	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	2023-07-07	2023-07-10	9999-12-31	31.240000	31.24	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	2023-07-06	2023-07-10	9999-12-31	31.320000	31.32	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	2023-07-05	2023-07-10	9999-12-31	31.140000	31.14	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	2023-07-04	2023-07-10	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	2023-07-03	2023-07-10	9999-12-31	31.100000	31.1	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	2023-06-30	2023-07-03	9999-12-31	31.140000	31.14	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	2023-06-29	2023-07-03	9999-12-31	31.060000	31.06	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	2023-06-28	2023-07-03	9999-12-31	31.080000	31.08	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	2023-06-27	2023-07-03	9999-12-31	31.020000	31.02	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