Name: Commercial Paper
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Commercial Paper

Commercial paper, in the global financial market, is an unsecured promissory note with a fixed maturity of not more than 270 days.

Commercial paper is a money-market security issued (sold) by large corporations to obtain funds to meet short-term debt obligations (for example, payroll), and is backed only by an issuing bank or company promise to pay the face amount on the maturity date specified on the note. Since it is not backed by collateral, only firms with excellent credit ratings from a recognized credit rating agency will be able to sell their commercial paper at a reasonable price. Commercial paper is usually sold at a discount from face value, and generally carries lower interest repayment rates than bonds due to the shorter maturities of commercial paper. Typically, the longer the maturity on a note, the higher the interest rate the issuing institution pays. Interest rates fluctuate with market conditions, but are typically lower than banks' rates.

Commercial paper – though a short-term obligation – is issued as part of a continuous rolling program, which is either a number of years long (as in Europe), or open-ended (as in the U.S.)

Acknowledgements

This dataset was made available by the Federal Reserve. You can find the original dataset, updated daily, here.

Inspiration

Based solely on this dataset, when would you say the Great Recession financial crisis started? How does that compare with media reports?

Tables

Commercial Paper Rates

@kaggle.federalreserve_commercial_paper_rates.commercial_paper_rates

257.15 kB
5,128 rows
25 columns

CREATE TABLE commercial_paper_rates (
  "series_description" VARCHAR,
  "overnight_aa_nonfinancial_commercial_paper_interest_rate" VARCHAR,
  "n_7_day_aa_nonfinancial_commercial_paper_interest_rate" VARCHAR  -- 7-Day AA Nonfinancial Commercial Paper Interest Rate,
  "n_15_day_aa_nonfinancial_commercial_paper_interest_rate" VARCHAR  -- 15-Day AA Nonfinancial Commercial Paper Interest Rate,
  "n_30_day_aa_nonfinancial_commercial_paper_interest_rate" VARCHAR  -- 30-Day AA Nonfinancial Commercial Paper Interest Rate,
  "n_60_day_aa_nonfinancial_commercial_paper_interest_rate" VARCHAR  -- 60-Day AA Nonfinancial Commercial Paper Interest Rate,
  "n_90_day_aa_nonfinancial_commercial_paper_interest_rate" VARCHAR  -- 90-Day AA Nonfinancial Commercial Paper Interest Rate,
  "overnight_a2_p2_nonfinancial_commercial_paper_interest_rate" VARCHAR,
  "n_7_day_a2_p2_nonfinancial_commercial_paper_interest_rate" VARCHAR  -- 7-Day A2/P2 Nonfinancial Commercial Paper Interest Rate,
  "n_15_day_a2_p2_nonfinancial_commercial_paper_interest_rate" VARCHAR  -- 15-Day A2/P2 Nonfinancial Commercial Paper Interest Rate,
  "n_30_day_a2_p2_nonfinancial_commercial_paper_interest_rate" VARCHAR  -- 30-Day A2/P2 Nonfinancial Commercial Paper Interest Rate,
  "n_60_day_a2_p2_nonfinancial_commercial_paper_interest_rate" VARCHAR  -- 60-Day A2/P2 Nonfinancial Commercial Paper Interest Rate,
  "n_90_day_a2_p2_nonfinancial_commercial_paper_interest_rate" VARCHAR  -- 90-Day A2/P2 Nonfinancial Commercial Paper Interest Rate,
  "overnight_aa_financial_commercial_paper_interest_rate" VARCHAR,
  "n_7_day_aa_financial_commercial_paper_interest_rate" VARCHAR  -- 7-Day AA Financial Commercial Paper Interest Rate,
  "n_15_day_aa_financial_commercial_paper_interest_rate" VARCHAR  -- 15-Day AA Financial Commercial Paper Interest Rate,
  "n_30_day_aa_financial_commercial_paper_interest_rate" VARCHAR  -- 30-Day AA Financial Commercial Paper Interest Rate,
  "n_60_day_aa_financial_commercial_paper_interest_rate" VARCHAR  -- 60-Day AA Financial Commercial Paper Interest Rate,
  "n_90_day_aa_financial_commercial_paper_interest_rate" VARCHAR  -- 90-Day AA Financial Commercial Paper Interest Rate,
  "overnight_aa_asset_backed_commercial_paper_interest_rate" VARCHAR,
  "n_7_day_aa_asset_backed_commercial_paper_interest_rate" VARCHAR  -- 7-Day AA Asset-backed Commercial Paper Interest Rate,
  "n_15_day_aa_asset_backed_commercial_paper_interest_rate" VARCHAR  -- 15-Day AA Asset-backed Commercial Paper Interest Rate,
  "n_30_day_aa_asset_backed_commercial_paper_interest_rate" VARCHAR  -- 30-Day AA Asset-backed Commercial Paper Interest Rate,
  "n_60_day_aa_asset_backed_commercial_paper_interest_rate" VARCHAR  -- 60-Day AA Asset-backed Commercial Paper Interest Rate,
  "n_90_day_aa_asset_backed_commercial_paper_interest_rate" VARCHAR  -- 90-Day AA Asset-backed Commercial Paper Interest Rate
);

Commercial Paper Volumes

@kaggle.federalreserve_commercial_paper_rates.commercial_paper_volumes

547.09 kB
5,128 rows
31 columns

CREATE TABLE commercial_paper_volumes (
  "series_description" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_1_and_4__fedc16fc" VARCHAR  -- Total Value Of Issues, With A Maturity Between 1 And 4 Days, Used In Calculating The AA Nonfinancial CP Rates,
  "total_value_of_issues_with_a_maturity_between_5_and_9__b6fac5d8" VARCHAR  -- Total Value Of Issues, With A Maturity Between 5 And 9 Days, Used In Calculating The AA Nonfinancial CP Rates,
  "total_value_of_issues_with_a_maturity_between_10_and_2_b1540f18" VARCHAR  -- Total Value Of Issues, With A Maturity Between 10 And 20 Days, Used In Calculating The AA Nonfinancial CP Rates,
  "total_value_of_issues_with_a_maturity_between_21_and_4_2cb2d34f" VARCHAR  -- Total Value Of Issues, With A Maturity Between 21 And 40 Days, Used In Calculating The AA Nonfinancial CP Rates,
  "total_value_of_issues_with_a_maturity_between_41_and_8_553348b1" VARCHAR  -- Total Value Of Issues, With A Maturity Between 41 And 80 Days, Used In Calculating The AA Nonfinancial CP Rates,
  "total_value_of_issues_with_a_maturity_greater_than_80__fdc93f36" VARCHAR  -- Total Value Of Issues, With A Maturity Greater Than 80 Days, Used In Calculating The AA Nonfinancial CP Rates,
  "total_value_of_issues_with_a_maturity_between_1_and_4__f85a92b1" VARCHAR  -- Total Value Of Issues, With A Maturity Between 1 And 4 Days, Used In Calculating The A2/P2 Nonfinancial CP Rates,
  "total_value_of_issues_with_a_maturity_between_5_and_9__7df23589" VARCHAR  -- Total Value Of Issues, With A Maturity Between 5 And 9 Days, Used In Calculating The A2/P2 Nonfinancial CP Rates,
  "total_value_of_issues_with_a_maturity_between_10_and_2_1b8615be" VARCHAR  -- Total Value Of Issues, With A Maturity Between 10 And 20 Days, Used In Calculating The A2/P2 Nonfinancial CP Rates,
  "total_value_of_issues_with_a_maturity_between_21_and_4_c077925b" VARCHAR  -- Total Value Of Issues, With A Maturity Between 21 And 40 Days, Used In Calculating The A2/P2 Nonfinancial CP Rates,
  "total_value_of_issues_with_a_maturity_between_41_and_8_c597e39a" VARCHAR  -- Total Value Of Issues, With A Maturity Between 41 And 80 Days, Used In Calculating The A2/P2 Nonfinancial CP Rates,
  "total_value_of_issues_with_a_maturity_greater_than_80__94d22c67" VARCHAR  -- Total Value Of Issues, With A Maturity Greater Than 80 Days, Used In Calculating The A2/P2 Nonfinancial CP Rates,
  "total_value_of_issues_with_a_maturity_between_1_and_4__7f197166" VARCHAR  -- Total Value Of Issues, With A Maturity Between 1 And 4 Days, Used In Calculating The AA Financial CP Rates,
  "total_value_of_issues_with_a_maturity_between_5_and_9__972d3158" VARCHAR  -- Total Value Of Issues, With A Maturity Between 5 And 9 Days, Used In Calculating The AA Financial CP Rates,
  "total_value_of_issues_with_a_maturity_between_10_and_2_05cb74f5" VARCHAR  -- Total Value Of Issues, With A Maturity Between 10 And 20 Days, Used In Calculating The AA Financial CP Rates,
  "total_value_of_issues_with_a_maturity_between_21_and_4_b768322c" VARCHAR  -- Total Value Of Issues, With A Maturity Between 21 And 40 Days, Used In Calculating The AA Financial CP Rates,
  "total_value_of_issues_with_a_maturity_between_41_and_8_6d13633d" VARCHAR  -- Total Value Of Issues, With A Maturity Between 41 And 80 Days, Used In Calculating The AA Financial CP Rates,
  "total_value_of_issues_with_a_maturity_greater_than_80__6aa7f6cf" VARCHAR  -- Total Value Of Issues, With A Maturity Greater Than 80 Days, Used In Calculating The AA Financial CP Rates,
  "total_value_of_issues_with_a_maturity_between_1_and_4__1cada8f9" VARCHAR  -- Total Value Of Issues, With A Maturity Between 1 And 4 Days, Used In Calculating The AA Asset-backed CP Rates,
  "total_value_of_issues_with_a_maturity_between_5_and_9__71b8ecb7" VARCHAR  -- Total Value Of Issues, With A Maturity Between 5 And 9 Days, Used In Calculating The AA Asset-backed CP Rates,
  "total_value_of_issues_with_a_maturity_between_10_and_2_f10a3e1b" VARCHAR  -- Total Value Of Issues, With A Maturity Between 10 And 20 Days, Used In Calculating The AA Asset-backed CP Rates,
  "total_value_of_issues_with_a_maturity_between_21_and_4_0973c780" VARCHAR  -- Total Value Of Issues, With A Maturity Between 21 And 40 Days, Used In Calculating The AA Asset-backed CP Rates,
  "total_value_of_issues_with_a_maturity_between_41_and_8_a61b708d" VARCHAR  -- Total Value Of Issues, With A Maturity Between 41 And 80 Days, Used In Calculating The AA Asset-backed CP Rates,
  "total_value_of_issues_with_a_maturity_greater_than_80__b3aaa761" VARCHAR  -- Total Value Of Issues, With A Maturity Greater Than 80 Days, Used In Calculating The AA Asset-backed CP Rates,
  "total_value_of_cp_issues_with_a_maturity_between_1_and_4_days" VARCHAR,
  "total_value_of_issuers_of_cp_with_a_maturity_between_5_e22f8583" VARCHAR  -- Total Value Of Issuers Of CP With A Maturity Between 5 And 9 Days,
  "total_value_of_cp_issues_with_a_maturity_between_10_and_20_days" VARCHAR,
  "total_value_of_issuers_of_cp_with_a_maturity_between_2_26c7951c" VARCHAR  -- Total Value Of Issuers Of CP With A Maturity Between 21 And 40 Days,
  "total_value_of_issuers_of_cp_with_a_maturity_between_4_0dfcec7a" VARCHAR  -- Total Value Of Issuers Of CP With A Maturity Between 41 And 80 Days,
  "total_value_of_issuers_of_cp_with_a_maturity_greater_t_75bb7c52" VARCHAR  -- Total Value Of Issuers Of CP With A Maturity Greater Than 80 Days
);