datasets-securities.md
264 lines · skills/usfiscaldata/references/datasets-securities.md at 5f2bc03
Securities & Savings Bonds Datasets — U.S. Treasury Fiscal Data
Raw lines 1 to 2Treasury 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:
| Field | Type | Description |
|---|---|---|
record_date | DATE | Publication date; do not use as auction date |
auction_date | DATE | Date auction was held |
security_type | STRING | Basic security type; inspect inflation_index_security and floating_rate flags for TIPS/FRNs |
security_term | STRING | e.g., "4-Week", "2-Year", "10-Year" |
cusip | STRING | CUSIP identifier |
offering_amt | CURRENCY0 | Amount offered |
high_yield | NUMBER | High accepted yield (notes/bonds/TIPS; bills use high_discnt_rate) |
int_rate | NUMBER | Coupon/interest rate of the security |
bid_to_cover_ratio | NUMBER | Bid-to-cover ratio |
total_accepted | NUMBER | Total accepted amount (USD) |
indirect_bidder_accepted | NUMBER | Indirect bidder amount accepted (USD) |
issue_date | DATE | Issue/settlement date |
maturity_date | DATE | Maturity 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 55Treasury 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:
| Field | Type | Description |
|---|---|---|
auction_date | DATE | Scheduled auction date |
security_type | STRING | Security type |
security_term | STRING | Maturity term |
offering_amt | CURRENCY0 | Announced 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 88Record-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 94Treasury 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.
| Table | Endpoint | Description |
|---|---|---|
| Buybacks Operations | /v1/accounting/od/buybacks_operations | Announcements and results per operation |
| Security Details | /v1/accounting/od/buybacks_security_details | Security 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
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:
| Field | Type | Description |
|---|---|---|
issue_year_month | STRING | Bond issue month (YYYY-MM); fixes the bond vintage |
earning_period_start | DATE | Start of published earning period |
earning_period_end | DATE | End of published earning period |
fixed_rate | PERCENTAGE | Fixed rate component |
semi_annual_inflation_rate | PERCENTAGE | Semi-annual CPI-U inflation rate |
combined_rate | PERCENTAGE | Combined 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.
U.S. Treasury Savings Bonds: Issues, Redemptions & Maturities
Three data tables under /v1/accounting/od/:
| Table | Endpoint | Description |
|---|---|---|
| Issues, Redemptions & Maturities | /v1/accounting/od/savings_bonds_report | Paper-bond counts by series |
| Matured Unredeemed Debt | /v1/accounting/od/savings_bonds_mud | Matured unredeemed debt |
| Piece Information by Series | /v1/accounting/od/savings_bonds_pcs | Piece 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):
| Field | Type | Description |
|---|---|---|
record_date | DATE | Month end date |
series_cd | STRING | Bond series (EE, I, HH) |
bonds_issued_cnt | NUMBER | Count of paper bonds issued |
bonds_redeemed_cnt | NUMBER | Count redeemed |
bonds_matured_cnt | NUMBER | Count matured |
bonds_out_cnt | NUMBER | Count outstanding |
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 177Accrual 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 185Savings 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
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 202Monthly 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
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
Federal Investments Program
Raw lines 223 to 224Interest 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 230Principal Outstanding
Frequency: Monthly (2 tables) Date Range: October 2017 to present
Raw lines 231 to 234Statement of Account
Frequency: Monthly (3 tables) Date Range: November 2011 to present
Raw lines 235 to 240
Federal Borrowings Program
Raw lines 241 to 242Distribution and Transaction Data
Frequency: Daily (2 tables) Date Range: September 2000 to present
Raw lines 243 to 246Interest on Uninvested Funds
Frequency: Quarterly Date Range: December 2016 to present
Raw lines 247 to 250Summary General Ledger Balances Report
Frequency: Monthly (2 tables) Date Range: October 2005 to present
Raw lines 251 to 254Official sources
Reviewed 2026-09-30 against the current dataset dictionaries and live API responses.
- Treasury Securities Auctions Data
- Upcoming Auctions
- I Bonds Interest Rates
- Savings Bonds Issues Redemptions Maturities By Series
- Slgs Securities
- Slgs Securities Program Stats