Skill Tracer
Skills › Scientific Agent Skills › usfiscaldata › datasets-securities.md

datasets-securities.md

264 lines · skills/usfiscaldata/references/datasets-securities.md at 5f2bc03

Open on GitHub
1# Securities & Savings Bonds Datasets — U.S. Treasury Fiscal Data
2

Securities & Savings Bonds Datasets — U.S. Treasury Fiscal Data

Raw lines 1 to 2
3## Treasury Securities Auctions Data
4
5**Endpoint:** `/v1/accounting/od/auctions_query`
6**Frequency:** As Needed
7**Date Range:** November 1979 to present
8
9Historical data on Treasury securities auctions including bills, notes, bonds, TIPS, and FRNs.
11**Key fields:**
12| Field | Type | Description |
13|-------|------|-------------|
14| `record_date` | DATE | Publication date; do not use as auction date |
15| `auction_date` | DATE | Date auction was held |
16| `security_type` | STRING | Basic security type; inspect `inflation_index_security` and `floating_rate` flags for TIPS/FRNs |
17| `security_term` | STRING | e.g., "4-Week", "2-Year", "10-Year" |
18| `cusip` | STRING | CUSIP identifier |
19| `offering_amt` | CURRENCY0 | Amount offered |
20| `high_yield` | NUMBER | High accepted yield (notes/bonds/TIPS; bills use `high_discnt_rate`) |
21| `int_rate` | NUMBER | Coupon/interest rate of the security |
22| `bid_to_cover_ratio` | NUMBER | Bid-to-cover ratio |
23| `total_accepted` | NUMBER | Total accepted amount (USD) |
24| `indirect_bidder_accepted` | NUMBER | Indirect bidder amount accepted (USD) |
25| `issue_date` | DATE | Issue/settlement date |
26| `maturity_date` | DATE | Maturity date |
28```python
29# Get recent 10-year Treasury note auctions
30resp = requests.get(
31 "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/auctions_query",
32 params={
33 "filter": "security_type:eq:Note,original_security_term:eq:10-Year,inflation_index_security:eq:No,floating_rate:eq:No",
34 "sort": "-auction_date",
35 "page[size]": 10
36 },
37 timeout=30,
39resp.raise_for_status()
40df = pd.DataFrame(resp.json()["data"])
42# Get all auctions in 2024
43resp = requests.get(
44 "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/auctions_query",
45 params={
46 "filter": "auction_date:gte:2024-01-01,auction_date:lte:2024-12-31",
47 "sort": "-auction_date",
48 "page[size]": 10000
49 },
50 timeout=30,
52resp.raise_for_status()
53assert resp.json()["meta"]["total-pages"] <= 1, "Use fetch_all for more pages"
54```

Treasury Securities Auctions Data

Endpoint: /v1/accounting/od/auctions_query Frequency: As Needed Date Range: November 1979 to present

Historical data on Treasury securities auctions including bills, notes, bonds, TIPS, and FRNs.

Key fields:

FieldTypeDescription
record_dateDATEPublication date; do not use as auction date
auction_dateDATEDate auction was held
security_typeSTRINGBasic security type; inspect inflation_index_security and floating_rate flags for TIPS/FRNs
security_termSTRINGe.g., "4-Week", "2-Year", "10-Year"
cusipSTRINGCUSIP identifier
offering_amtCURRENCY0Amount offered
high_yieldNUMBERHigh accepted yield (notes/bonds/TIPS; bills use high_discnt_rate)
int_rateNUMBERCoupon/interest rate of the security
bid_to_cover_ratioNUMBERBid-to-cover ratio
total_acceptedNUMBERTotal accepted amount (USD)
indirect_bidder_acceptedNUMBERIndirect bidder amount accepted (USD)
issue_dateDATEIssue/settlement date
maturity_dateDATEMaturity date
# Get recent 10-year Treasury note auctions
resp = requests.get(
    "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/auctions_query",
    params={
        "filter": "security_type:eq:Note,original_security_term:eq:10-Year,inflation_index_security:eq:No,floating_rate:eq:No",
        "sort": "-auction_date",
        "page[size]": 10
    },
    timeout=30,
)
resp.raise_for_status()
df = pd.DataFrame(resp.json()["data"])

# Get all auctions in 2024
resp = requests.get(
    "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/auctions_query",
    params={
        "filter": "auction_date:gte:2024-01-01,auction_date:lte:2024-12-31",
        "sort": "-auction_date",
        "page[size]": 10000
    },
    timeout=30,
)
resp.raise_for_status()
assert resp.json()["meta"]["total-pages"] <= 1, "Use fetch_all for more pages"
Raw lines 3 to 55
56## Treasury Securities Upcoming Auctions
58**Endpoint:** `/v1/accounting/od/upcoming_auctions`
59**Frequency:** As Needed
60**Date Range:** March 2024 to present
62Schedule data can include historical rows. Filter `auction_date:gte:<today>` for future auction dates, or `issue_date` for settlement timing. Do not assume an unfiltered response contains only upcoming events.
64**Key fields:**
65| Field | Type | Description |
66|-------|------|-------------|
67| `auction_date` | DATE | Scheduled auction date |
68| `security_type` | STRING | Security type |
69| `security_term` | STRING | Maturity term |
70| `offering_amt` | CURRENCY0 | Announced offering amount |
72```python
73# Get upcoming auctions
74from datetime import date
75resp = requests.get(
76 "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/upcoming_auctions",
77 params={"filter": f"auction_date:gte:{date.today().isoformat()}", "sort": "auction_date", "page[size]": 1000},
78 timeout=30,
80resp.raise_for_status()
81assert resp.json()["meta"]["total-pages"] <= 1, "Use fetch_all for more pages"
82upcoming = pd.DataFrame(resp.json()["data"])
83if upcoming.empty:
84 print("No upcoming rows returned for the requested date range")
85else:
86 print(upcoming[["auction_date", "security_type", "security_term", "offering_amt"]])
87```

Treasury Securities Upcoming Auctions

Endpoint: /v1/accounting/od/upcoming_auctions Frequency: As Needed Date Range: March 2024 to present

Schedule data can include historical rows. Filter auction_date:gte:<today> for future auction dates, or issue_date for settlement timing. Do not assume an unfiltered response contains only upcoming events.

Key fields:

FieldTypeDescription
auction_dateDATEScheduled auction date
security_typeSTRINGSecurity type
security_termSTRINGMaturity term
offering_amtCURRENCY0Announced offering amount
# Get upcoming auctions
from datetime import date
resp = requests.get(
    "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/upcoming_auctions",
    params={"filter": f"auction_date:gte:{date.today().isoformat()}", "sort": "auction_date", "page[size]": 1000},
    timeout=30,
)
resp.raise_for_status()
assert resp.json()["meta"]["total-pages"] <= 1, "Use fetch_all for more pages"
upcoming = pd.DataFrame(resp.json()["data"])
if upcoming.empty:
    print("No upcoming rows returned for the requested date range")
else:
    print(upcoming[["auction_date", "security_type", "security_term", "offering_amt"]])
Raw lines 56 to 88
89## Record-Setting Treasury Securities Auction Data
91**Frequency:** As Needed
93Tracks auction records (largest, highest rate, lowest rate, etc.) for each security type and term.

Record-Setting Treasury Securities Auction Data

Frequency: As Needed

Tracks auction records (largest, highest rate, lowest rate, etc.) for each security type and term.

Raw lines 89 to 94
95## Treasury Securities Buybacks
97**Frequency:** As Needed (2 data tables)
98**Date Range:** March 2000 to present
100Data on Treasury's secondary market buyback (repurchase) operations. Active since the program's relaunch in 2024.
102| Table | Endpoint | Description |
103|-------|----------|-------------|
104| Buybacks Operations | `/v1/accounting/od/buybacks_operations` | Announcements and results per operation |
105| Security Details | `/v1/accounting/od/buybacks_security_details` | Security details per operation |
107```python
108# Recent buyback operations
109resp = requests.get(
110 "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/buybacks_operations",
111 params={"sort": "-operation_date", "page[size]": 10},
112 timeout=30,
114resp.raise_for_status()
115df = pd.DataFrame(resp.json()["data"])
116print(df[["operation_date", "settlement_date"]].head())
117```
119---

Treasury Securities Buybacks

Frequency: As Needed (2 data tables) Date Range: March 2000 to present

Data on Treasury's secondary market buyback (repurchase) operations. Active since the program's relaunch in 2024.

TableEndpointDescription
Buybacks Operations/v1/accounting/od/buybacks_operationsAnnouncements and results per operation
Security Details/v1/accounting/od/buybacks_security_detailsSecurity details per operation
# Recent buyback operations
resp = requests.get(
    "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/buybacks_operations",
    params={"sort": "-operation_date", "page[size]": 10},
    timeout=30,
)
resp.raise_for_status()
df = pd.DataFrame(resp.json()["data"])
print(df[["operation_date", "settlement_date"]].head())

Raw lines 95 to 120
121## I Bonds Interest Rates
123**Endpoint:** `/v1/accounting/od/i_bonds_interest_rates`
124**Frequency:** Semi-Annual (May and November)
125**Date Range:** September 1998 to present
127Composite interest rates for Series I Savings Bonds, including fixed rate and inflation rate components.
129**Key fields:**
130| Field | Type | Description |
131|-------|------|-------------|
132| `issue_year_month` | STRING | Bond issue month (`YYYY-MM`); fixes the bond vintage |
133| `earning_period_start` | DATE | Start of published earning period |
134| `earning_period_end` | DATE | End of published earning period |
135| `fixed_rate` | PERCENTAGE | Fixed rate component |
136| `semi_annual_inflation_rate` | PERCENTAGE | Semi-annual CPI-U inflation rate |
137| `combined_rate` | PERCENTAGE | Combined composite rate |
139Do not take the first row sorted only by earning period: many issue-month
140vintages share that period and have different fixed rates. Filter
141`issue_year_month` for the bond, and choose the earning period appropriate to the
142reporting date. The first period may be shorter than six months. The current
143rate for newly issued bonds is not the rate for every outstanding I Bond.
144See [examples.md](examples.md) for a query that names its issue vintage.

I Bonds Interest Rates

Endpoint: /v1/accounting/od/i_bonds_interest_rates Frequency: Semi-Annual (May and November) Date Range: September 1998 to present

Composite interest rates for Series I Savings Bonds, including fixed rate and inflation rate components.

Key fields:

FieldTypeDescription
issue_year_monthSTRINGBond issue month (YYYY-MM); fixes the bond vintage
earning_period_startDATEStart of published earning period
earning_period_endDATEEnd of published earning period
fixed_ratePERCENTAGEFixed rate component
semi_annual_inflation_ratePERCENTAGESemi-annual CPI-U inflation rate
combined_ratePERCENTAGECombined composite rate

Do not take the first row sorted only by earning period: many issue-month vintages share that period and have different fixed rates. Filter issue_year_month for the bond, and choose the earning period appropriate to the reporting date. The first period may be shorter than six months. The current rate for newly issued bonds is not the rate for every outstanding I Bond. See examples.md for a query that names its issue vintage.

Raw lines 121 to 145
146## U.S. Treasury Savings Bonds: Issues, Redemptions & Maturities
148Three data tables under `/v1/accounting/od/`:
150| Table | Endpoint | Description |
151|-------|----------|-------------|
152| Issues, Redemptions & Maturities | `/v1/accounting/od/savings_bonds_report` | Paper-bond counts by series |
153| Matured Unredeemed Debt | `/v1/accounting/od/savings_bonds_mud` | Matured unredeemed debt |
154| Piece Information by Series | `/v1/accounting/od/savings_bonds_pcs` | Piece information by series |
156**Frequency:** Monthly
157**Date Range:** September 1998 to present
159The `savings_bonds_report` table counts paper bonds by series; its fields are not dollar amounts. Its API coverage starts in January 2019; the other tables have different start dates. These counts should not be interpreted as all electronic and paper savings-bond sales.
161**Key fields (savings_bonds_report):**
162| Field | Type | Description |
163|-------|------|-------------|
164| `record_date` | DATE | Month end date |
165| `series_cd` | STRING | Bond series (EE, I, HH) |
166| `bonds_issued_cnt` | NUMBER | Count of paper bonds issued |
167| `bonds_redeemed_cnt` | NUMBER | Count redeemed |
168| `bonds_matured_cnt` | NUMBER | Count matured |
169| `bonds_out_cnt` | NUMBER | Count outstanding |

U.S. Treasury Savings Bonds: Issues, Redemptions & Maturities

Three data tables under /v1/accounting/od/:

TableEndpointDescription
Issues, Redemptions & Maturities/v1/accounting/od/savings_bonds_reportPaper-bond counts by series
Matured Unredeemed Debt/v1/accounting/od/savings_bonds_mudMatured unredeemed debt
Piece Information by Series/v1/accounting/od/savings_bonds_pcsPiece information by series

Frequency: Monthly Date Range: September 1998 to present

The savings_bonds_report table counts paper bonds by series; its fields are not dollar amounts. Its API coverage starts in January 2019; the other tables have different start dates. These counts should not be interpreted as all electronic and paper savings-bond sales.

Key fields (savings_bonds_report):

FieldTypeDescription
record_dateDATEMonth end date
series_cdSTRINGBond series (EE, I, HH)
bonds_issued_cntNUMBERCount of paper bonds issued
bonds_redeemed_cntNUMBERCount redeemed
bonds_matured_cntNUMBERCount matured
bonds_out_cntNUMBERCount outstanding
Raw lines 146 to 170
171## Savings Bonds Value Files
173**Frequency:** Semi-Annual
174**Date Range:** May 1992 to present
176Files for calculating current redemption values of savings bonds.

Savings Bonds Value Files

Frequency: Semi-Annual Date Range: May 1992 to present

Files for calculating current redemption values of savings bonds.

Raw lines 171 to 177
178## Accrual Savings Bonds Redemption Tables (Discontinued)
180**Endpoint:** `/v2/accounting/od/redemption_tables`
181**Frequency:** Discontinued (last updated 2022)
182**Date Range:** March 1999 – May 2023
184Monthly redemption value tables for historical savings bonds.

Accrual Savings Bonds Redemption Tables (Discontinued)

Endpoint: /v2/accounting/od/redemption_tables Frequency: Discontinued (last updated 2022) Date Range: March 1999 – May 2023

Monthly redemption value tables for historical savings bonds.

Raw lines 178 to 185
186## Savings Bonds Securities Sold (Discontinued)
188**Endpoint:** `/v1/accounting/od/slgs_savings_bonds` (despite its name, this is historical savings-bond statistics, not SLGS interest rates).
190**Frequency:** Discontinued
191**Date Range:** October 1998 – June 2022
193---

Savings Bonds Securities Sold (Discontinued)

Endpoint: /v1/accounting/od/slgs_savings_bonds (despite its name, this is historical savings-bond statistics, not SLGS interest rates).

Frequency: Discontinued Date Range: October 1998 – June 2022


Raw lines 186 to 194
195## State and Local Government Series (SLGS) Securities
197**Endpoint:** `/v1/accounting/od/slgs_securities`
198**Frequency:** Daily
199**Date Range:** October 1998 to present
201SLGS securities outstanding data — non-marketable special purpose securities sold to state and local governments.

State and Local Government Series (SLGS) Securities

Endpoint: /v1/accounting/od/slgs_securities Frequency: Daily Date Range: October 1998 to present

SLGS securities outstanding data — non-marketable special purpose securities sold to state and local governments.

Raw lines 195 to 202
203## Monthly State and Local Government Series (SLGS) Securities Program
205**Endpoint:** `/v2/accounting/od/slgs_statistics`
207**Frequency:** Monthly
208**Date Range:** March 2014 to present
210Monthly statistics on the SLGS program.
212---

Monthly State and Local Government Series (SLGS) Securities Program

Endpoint: /v2/accounting/od/slgs_statistics

Frequency: Monthly Date Range: March 2014 to present

Monthly statistics on the SLGS program.


Raw lines 203 to 213
214## Electronic Securities Transactions
216**Frequency:** Monthly (8 data tables)
217**Date Range:** January 2000 to present
219Counts of sales, transfers, redemptions, outstanding securities and accounts in TreasuryDirect. These transaction tables do not provide bond values or yields; do not describe them as TRADES settlement data.
221---

Electronic Securities Transactions

Frequency: Monthly (8 data tables) Date Range: January 2000 to present

Counts of sales, transfers, redemptions, outstanding securities and accounts in TreasuryDirect. These transaction tables do not provide bond values or yields; do not describe them as TRADES settlement data.


Raw lines 214 to 222
223## Federal Investments Program

Federal Investments Program

Raw lines 223 to 224
225### Interest Cost by Fund
226**Frequency:** Monthly
227**Date Range:** October 2001 to present
229Monthly interest components by Federal Investments Program account/Treasury Account Symbol, including premiums, discounts, interest payments and inflation compensation.

Interest Cost by Fund

Frequency: Monthly Date Range: October 2001 to present

Monthly interest components by Federal Investments Program account/Treasury Account Symbol, including premiums, discounts, interest payments and inflation compensation.

Raw lines 225 to 230
231### Principal Outstanding
232**Frequency:** Monthly (2 tables)
233**Date Range:** October 2017 to present

Principal Outstanding

Frequency: Monthly (2 tables) Date Range: October 2017 to present

Raw lines 231 to 234
235### Statement of Account
236**Frequency:** Monthly (3 tables)
237**Date Range:** November 2011 to present
239---

Statement of Account

Frequency: Monthly (3 tables) Date Range: November 2011 to present


Raw lines 235 to 240
241## Federal Borrowings Program

Federal Borrowings Program

Raw lines 241 to 242
243### Distribution and Transaction Data
244**Frequency:** Daily (2 tables)
245**Date Range:** September 2000 to present

Distribution and Transaction Data

Frequency: Daily (2 tables) Date Range: September 2000 to present

Raw lines 243 to 246
247### Interest on Uninvested Funds
248**Frequency:** Quarterly
249**Date Range:** December 2016 to present

Interest on Uninvested Funds

Frequency: Quarterly Date Range: December 2016 to present

Raw lines 247 to 250
251### Summary General Ledger Balances Report
252**Frequency:** Monthly (2 tables)
253**Date Range:** October 2005 to present

Summary General Ledger Balances Report

Frequency: Monthly (2 tables) Date Range: October 2005 to present

Raw lines 251 to 254
255## Official sources
257Reviewed 2026-09-30 against the current dataset dictionaries and live API responses.
259- [Treasury Securities Auctions Data](https://fiscaldata.treasury.gov/datasets/treasury-securities-auctions-data/)
260- [Upcoming Auctions](https://fiscaldata.treasury.gov/datasets/upcoming-auctions/)
261- [I Bonds Interest Rates](https://fiscaldata.treasury.gov/datasets/i-bonds-interest-rates/)
262- [Savings Bonds Issues Redemptions Maturities By Series](https://fiscaldata.treasury.gov/datasets/savings-bonds-issues-redemptions-maturities-by-series/)
263- [Slgs Securities](https://fiscaldata.treasury.gov/datasets/slgs-securities/)
264- [Slgs Securities Program Stats](https://fiscaldata.treasury.gov/datasets/slgs-securities-program-stats/)