Commercial Paper

Rates & Volumes for 1998-2017

@kaggle.federalreserve_commercial_paper_rates

Table List

2 tables(785.39 KB)

Commercial Paper Volumes

@kaggle.federalreserve_commercial_paper_rates.commercial_paper_volumes

534.27 KB
5128 rows
31 columns

series_description Series Description	total_value_of_issues_with_a_maturity_between_1_and_4__fedc16fc 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Total Value Of CP Issues With A Maturity Between 1 And 4 Days	total_value_of_issuers_of_cp_with_a_maturity_between_5_e22f8583 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 Total Value Of CP Issues With A Maturity Between 10 And 20 Days	total_value_of_issuers_of_cp_with_a_maturity_between_2_26c7951c 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 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 Total Value Of Issuers Of CP With A Maturity Greater Than 80 Days
Unit:	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency	Currency
Multiplier:	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000	1000000
Currency:	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD	USD
Unique Identifier:	CP/VOL/NONFIN.1_4.AA.AMT	CP/VOL/NONFIN.5_9.AA.AMT	CP/VOL/NONFIN.10_20.AA.AMT	CP/VOL/NONFIN.21_40.AA.AMT	CP/VOL/NONFIN.41_80.AA.AMT	CP/VOL/NONFIN.GT80.AA.AMT	CP/VOL/NONFIN.1_4.A2P2.AMT	CP/VOL/NONFIN.5_9.A2P2.AMT	CP/VOL/NONFIN.10_20.A2P2.AMT	CP/VOL/NONFIN.21_40.A2P2.AMT	CP/VOL/NONFIN.41_80.A2P2.AMT	CP/VOL/NONFIN.GT80.A2P2.AMT	CP/VOL/FIN.1_4.AA.AMT	CP/VOL/FIN.5_9.AA.AMT	CP/VOL/FIN.10_20.AA.AMT	CP/VOL/FIN.21_40.AA.AMT	CP/VOL/FIN.41_80.AA.AMT	CP/VOL/FIN.GT80.AA.AMT	CP/VOL/AB.1_4.AA.AMT	CP/VOL/AB.5_9.AA.AMT	CP/VOL/AB.10_20.AA.AMT	CP/VOL/AB.21_40.AA.AMT	CP/VOL/AB.41_80.AA.AMT	CP/VOL/AB.GT80.AA.AMT	CP/VOL/MKT.1_4.MKT.AMT	CP/VOL/MKT.5_9.MKT.AMT	CP/VOL/MKT.10_20.MKT.AMT	CP/VOL/MKT.21_40.MKT.AMT	CP/VOL/MKT.41_80.MKT.AMT	CP/VOL/MKT.GT80.MKT.AMT
Time Period	NONFIN.1_4.AA.AMT	NONFIN.5_9.AA.AMT	NONFIN.10_20.AA.AMT	NONFIN.21_40.AA.AMT	NONFIN.41_80.AA.AMT	NONFIN.GT80.AA.AMT	NONFIN.1_4.A2P2.AMT	NONFIN.5_9.A2P2.AMT	NONFIN.10_20.A2P2.AMT	NONFIN.21_40.A2P2.AMT	NONFIN.41_80.A2P2.AMT	NONFIN.GT80.A2P2.AMT	FIN.1_4.AA.AMT	FIN.5_9.AA.AMT	FIN.10_20.AA.AMT	FIN.21_40.AA.AMT	FIN.41_80.AA.AMT	FIN.GT80.AA.AMT	AB.1_4.AA.AMT	AB.5_9.AA.AMT	AB.10_20.AA.AMT	AB.21_40.AA.AMT	AB.41_80.AA.AMT	AB.GT80.AA.AMT	MKT.1_4.MKT.AMT	MKT.5_9.MKT.AMT	MKT.10_20.MKT.AMT	MKT.21_40.MKT.AMT	MKT.41_80.MKT.AMT	MKT.GT80.MKT.AMT
1998-01-02	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND
1998-01-05	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND
1998-01-06	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND
1998-01-07	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND
1998-01-08	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND	ND


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_5_and_9__b6fac5d8" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_10_and_2_b1540f18" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_21_and_4_2cb2d34f" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_41_and_8_553348b1" VARCHAR,
  "total_value_of_issues_with_a_maturity_greater_than_80__fdc93f36" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_1_and_4__f85a92b1" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_5_and_9__7df23589" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_10_and_2_1b8615be" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_21_and_4_c077925b" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_41_and_8_c597e39a" VARCHAR,
  "total_value_of_issues_with_a_maturity_greater_than_80__94d22c67" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_1_and_4__7f197166" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_5_and_9__972d3158" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_10_and_2_05cb74f5" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_21_and_4_b768322c" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_41_and_8_6d13633d" VARCHAR,
  "total_value_of_issues_with_a_maturity_greater_than_80__6aa7f6cf" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_1_and_4__1cada8f9" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_5_and_9__71b8ecb7" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_10_and_2_f10a3e1b" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_21_and_4_0973c780" VARCHAR,
  "total_value_of_issues_with_a_maturity_between_41_and_8_a61b708d" VARCHAR,
  "total_value_of_issues_with_a_maturity_greater_than_80__b3aaa761" VARCHAR,
  "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_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_4_0dfcec7a" VARCHAR,
  "total_value_of_issuers_of_cp_with_a_maturity_greater_t_75bb7c52" VARCHAR
);