get_treasury_auctions
Returns Treasury security auctions — Bills (≤1yr), Notes (2-10yr), Bonds (20-30yr), TIPS (inflation-protected), and FRNs (floating-rate). Each record is one CUSIP issuance with announcement metadata + post- auction results. Key signal fields agents care about: - bid_to_cover_ratio: demand. >2.5 strong, <2.0 weak. - high_yield / average_yield: market clearing rate. - direct_bidder / indirect_bidder breakdowns: domestic vs foreign demand. - soma_holdings + soma_included: Fed System Open Market Account allocation. A live measure of Fed QE/QT activity on each issue. Records have a two-stage lifecycle: announcement (results fields null) → post-auction (full results populated). Idempotent saves on cusip + auction_date overwrite cleanly when results publish. Security types: 'Bill', 'Note', 'Bond', 'TIPS', 'FRN', 'CMB' (cash- management bill). Use security_type filter to focus on one term group. Note: Treasury reports TIPS and FRNs under security_type Note/Bond with an inflation-indexed / floating-rate flag (not as their own type); filtering security_type:'TIPS' or 'FRN' here resolves to those flags for convenience.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cusip | No | Filter to one specific CUSIP issuance. | |
| limit | No | Default 50, max 500. | |
| since | No | ISO date YYYY-MM-DD. Applied to sort_by field. | |
| until | No | ISO date YYYY-MM-DD. | |
| sort_by | No | Default auction_date. | |
| reopening | No | Filter to reopenings (new tranches of an existing CUSIP) only when true. | |
| sort_order | No | Default desc. | |
| security_type | No | e.g. 'Bill', 'Note', 'Bond', 'TIPS', 'FRN', 'CMB'. | |
| min_bid_to_cover | No | Filter to auctions with bid_to_cover_ratio >= this value (e.g. 2.5 for strong-demand auctions only). | |
| min_offering_amount | No | Filter to auctions with offering_amount >= this dollar amount. |