Ask the Grid
Open live grid

Peso Exchange Rate and US Macro Series (FRED)

Named FRED series, long by series.

FREDPrices dataBaja California market
Query with the agent
Native record
series x observation date
daily (business days) to quarterly by series publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · observation_date

Overview

DEXMXUS is Mexican pesos per US dollar (the Fed's H.10 noon buying rate), the rate to convert CENACE's peso prices; the others are US rates, credit spreads and inflation.

Query contract

Preserve one canonical row per (series_id, observation_date) before aggregating.

Analysis rules

  • Filter one series_id. For a date without a DEXMXUS value (weekends, US holidays) use the last observation before it.

Interpretation

  • DEXMXUS posts weekly, so the latest value can be a week old.

Schema4

Column
Type
series_idLowCardinality(String)
observation_dateDate
valueNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

series_idobservation_datevalueingested_at
BAA10Y2026-09-241.392026-09-26 13:15:20.170262
BAA10Y2026-09-231.392026-09-26 13:15:20.170262
BAA10Y2026-09-221.422026-09-26 13:15:20.170262
BAA10Y2026-09-211.422026-09-26 13:15:20.170262
BAA10Y2026-09-181.42026-09-26 13:15:20.170262
DEXMXUS2026-09-1817.24542026-09-26 13:15:24.254752
DEXMXUS2026-09-1717.18292026-09-26 13:15:24.254752
BAA10Y2026-09-171.442026-09-26 13:15:20.170262
DEXMXUS2026-09-1617.1362026-09-26 13:15:24.254752
BAA10Y2026-09-161.432026-09-26 13:15:20.170262
BAA10Y2026-09-151.482026-09-26 13:15:20.170262
DEXMXUS2026-09-1517.13932026-09-26 13:15:24.254752
DEXMXUS2026-09-1417.11042026-09-26 13:15:24.254752
BAA10Y2026-09-141.472026-09-26 13:15:20.170262
DEXMXUS2026-09-1116.97042026-09-26 13:15:24.254752
BAA10Y2026-09-111.52026-09-26 13:15:20.170262
BAA10Y2026-09-101.512026-09-26 13:15:20.170262
DEXMXUS2026-09-1016.9732026-09-26 13:15:24.254752
DEXMXUS2026-09-0916.89412026-09-26 13:15:24.254752
BAA10Y2026-09-091.552026-09-26 13:15:20.170262
DEXMXUS2026-09-0816.91372026-09-26 13:15:24.254752
BAA10Y2026-09-081.572026-09-26 13:15:20.170262
BAA10Y2026-09-041.562026-09-26 13:15:20.170262
DEXMXUS2026-09-0416.8632026-09-26 13:15:24.254752
DEXMXUS2026-09-0316.96022026-09-26 13:15:24.254752

Coverage

51.1% complete10,129 gap days10,592 days with data
Show coverage history
Coverage: 51.1%Days with data: 10,592Gaps: 10,129
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007
2006
2005
2004
2003
2002
2001
2000
1999
1998
1997
1996
1995
1994
1993
1992
1991
1990
1989
1988
1987
1986
1985
1984
1983
1982
1981
1980
1979
1978
1977
1976
1975
1974
1973
1972
1971
1970
gaplessmore