U.S. Treasury auction results since 1979
Results of every U.S. Treasury marketable securities auction since 1979 — bills, notes, bonds, TIPS and floating-rate notes — with the winning (high) yield or rate, amounts offered, bid for and accepted, and bid-to-cover ratio. One row per auction.
Columns
Stable keys — use them in the API, SQL and code
| Key | Name | Type | Description |
|---|---|---|---|
| auction_date | Auction date | date | Date the auction was held. |
| security_type | Type | string | Bill, Note or Bond (TIPS and FRNs are notes or bonds; see the flag columns). |
| security_term | Term | string | Term of the security sold, e.g. '13-Week', '10-Year', or the remaining term for a reopening. |
| cusip | CUSIP | string | CUSIP identifier of the security. |
| issue_date | Issue date | date | Settlement (issue) date. |
| maturity_date | Maturity date | date | Date the security matures. |
| reopening | Reopening | boolean | True if the auction reopened an existing security. |
| original_security_term | Original term | string | Term of the security when first issued (differs from Term for reopenings). |
| tips | TIPS | boolean | True for Treasury inflation-protected securities. |
| frn | FRN | boolean | True for floating-rate notes. |
| cash_management_bill | Cash management bill | boolean | True for cash management bills (off-cycle bills sold to cover short-term cash needs). |
| coupon_rate | Coupon | number · % | Annual interest (coupon) rate of a note or bond. |
| high_yield | High yield | number · % | Highest accepted yield (notes, bonds, TIPS); for TIPS a real yield. |
| high_discount_rate | High discount rate | number · % | Highest accepted discount rate (bills). |
| high_investment_rate | High investment rate | number · % | Bond-equivalent yield at the high discount rate (bills). |
| high_discount_margin | High discount margin | number · % | Highest accepted spread over the 13-week bill index (FRNs). |
| high_price | Price at high | number · per 100 face | Price per $100 of face value at the high yield or rate. |
| offering_amount | Offering amount | number · USD | Amount Treasury announced it would sell. |
| total_tendered | Total tendered | number · USD | Total amount of bids received. |
| total_accepted | Total accepted | number · USD | Total amount of bids accepted, as reported by Treasury. |
| bid_to_cover_ratio | Bid-to-cover | number | Ratio of bids tendered to bids accepted, as published by Treasury (from 1994). |
| primary_dealer_accepted | Primary dealers | number · USD | Amount accepted from primary dealers (from April 2008). |
| direct_bidder_accepted | Direct bidders | number · USD | Amount accepted from direct bidders (from April 2008). |
| indirect_bidder_accepted | Indirect bidders | number · USD | Amount accepted from indirect bidders, which include foreign central banks bidding through the New York Fed (from April 2008). |
| soma_accepted | SOMA | number · USD | Amount accepted for the Federal Reserve's System Open Market Account (from April 2008). |
| noncompetitive_accepted | Noncompetitive | number · USD | Amount of noncompetitive bids accepted. |
| auction_format | Format | string | Single-Price, Multi-Price or Price-Based auction. |
More in Markets & Finance
U.S. Treasury par yield curve rates, daily since 1990
Daily U.S. Treasury par yield curve rates for every published maturity from 1 month to 30 years, as published by the U.S. Department of the Treasury. One row per business day.
U.S. public companies and their latest annual financials
Every company with a stock ticker that files with the U.S. SEC, with its exchange and latest annual revenue, net income, operating income, diluted EPS, assets, liabilities, equity and cash from its XBRL filings. One row per company.
Federal Reserve balance sheet (H.4.1), weekly since 2002
The Federal Reserve's consolidated balance sheet every Wednesday since December 2002 from the H.4.1 release: total assets, Treasury and mortgage-backed securities, loans and swap lines, and the main liabilities — currency, bank reserves, reverse repos and the Treasury's cash account. One row per week.
Conforming loan limits by U.S. county (FHFA), every year since 2015
The maximum size of a mortgage Fannie Mae and Freddie Mac may buy in every U.S. county and territory, for one- to four-unit homes, for each calendar year since 2015 as set by the Federal Housing Finance Agency. One row per county per year.
U.S. Treasury reporting rates of exchange, quarterly since 2001
The official exchange rates the U.S. Treasury sets each quarter for converting about 170 foreign currencies into U.S. dollars in federal government reporting, since March 2001. One row per currency per quarter (plus mid-quarter amendments).
U.S. money-market interest rates (Fed H.15), daily since 1954
Daily U.S. short-term interest rates from the Federal Reserve's H.15 release: the effective federal funds rate since 1954, Treasury bill rates, AA commercial paper rates, the bank prime loan rate and the Fed's discount rate. One row per business day.