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 = WALCL×

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

WALCL	2012-05-09	2012-05-10	2013-04-17	2866466.000000	2866466	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-05-02	2013-04-18	9999-12-31	2864280.000000	2864280	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-05-02	2012-05-03	2013-04-17	2866606.000000	2866606	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-04-25	2013-04-18	9999-12-31	2866561.000000	2866561	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-04-25	2012-04-26	2013-04-17	2868889.000000	2868889	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-04-18	2013-04-18	9999-12-31	2875470.000000	2875470	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-04-18	2012-04-19	2013-04-17	2877835.000000	2877835	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-04-11	2013-04-18	9999-12-31	2867200.000000	2867200	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-04-11	2012-04-12	2013-04-17	2869519.000000	2869519	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-04-04	2013-04-18	9999-12-31	2865478.000000	2865478	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-04-04	2012-04-05	2013-04-17	2867800.000000	2867800	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-03-28	2013-04-18	9999-12-31	2878137.000000	2878137	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-03-28	2012-03-29	2013-04-17	2880463.000000	2880463	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-03-21	2013-04-18	9999-12-31	2892646.000000	2892646	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-03-21	2012-03-22	2013-04-17	2894991.000000	2894991	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-03-14	2013-04-18	9999-12-31	2893560.000000	2893560	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-03-14	2012-03-15	2013-04-17	2895849.000000	2895849	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-03-07	2013-04-18	9999-12-31	2884747.000000	2884747	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-03-07	2012-03-08	2013-04-17	2887054.000000	2887054	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-02-29	2013-04-18	9999-12-31	2925722.000000	2925722	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-02-29	2012-03-01	2013-04-17	2928042.000000	2928042	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-02-22	2013-04-18	9999-12-31	2932813.000000	2932813	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-02-22	2012-02-23	2013-04-17	2935149.000000	2935149	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-02-15	2013-04-18	9999-12-31	2937893.000000	2937893	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-02-15	2012-02-16	2013-04-17	2940244.000000	2940244	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-02-08	2013-04-18	9999-12-31	2928275.000000	2928275	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-02-08	2012-02-09	2013-04-17	2930570.000000	2930570	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-02-01	2013-04-18	9999-12-31	2924947.000000	2924947	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-02-01	2012-02-02	2013-04-17	2927251.000000	2927251	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-01-25	2013-04-18	9999-12-31	2919545.000000	2919545	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-01-25	2012-01-26	2013-04-17	2921869.000000	2921869	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-01-18	2013-04-18	9999-12-31	2919423.000000	2919423	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-01-18	2012-01-19	2013-04-17	2921751.000000	2921751	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-01-11	2013-04-18	9999-12-31	2899149.000000	2899149	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-01-11	2012-01-12	2013-04-17	2901503.000000	2901503	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-01-04	2013-04-18	9999-12-31	2917689.000000	2917689	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2012-01-04	2012-01-05	2013-04-17	2920069.000000	2920069	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2011-12-28	2013-04-18	9999-12-31	2926095.000000	2926095	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2011-12-28	2011-12-29	2013-04-17	2928485.000000	2928485	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2011-12-21	2013-04-18	9999-12-31	2916085.000000	2916085	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2011-12-21	2011-12-22	2013-04-17	2918506.000000	2918506	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2011-12-14	2013-04-18	9999-12-31	2902488.000000	2902488	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2011-12-14	2011-12-15	2013-04-17	2904959.000000	2904959	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2011-12-07	2013-04-18	9999-12-31	2820691.000000	2820691	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2011-12-07	2011-12-08	2013-04-17	2823207.000000	2823207	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2011-11-30	2013-04-18	9999-12-31	2814235.000000	2814235	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2011-11-30	2011-12-01	2013-04-17	2816773.000000	2816773	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2011-11-23	2013-04-18	9999-12-31	2821980.000000	2821980	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2011-11-23	2011-11-25	2013-04-17	2824537.000000	2824537	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44
WALCL	2011-11-16	2013-04-18	9999-12-31	2831576.000000	2831576	fred_tier_a	/fred/series/observations	{"series_id":"WALCL","full_vintage":true}	2026-09-08	2026-09-08 21:44	2026-09-08 21:44