Chinese Macroeconomic Data (2005 - 2022)

Macroeconomic data used to perform economic or market analysis on Chinese market

@kaggle.franciscofeng_chinese_macroeconomic_data_20052022

Table List

6 tables(398.91 KB)

Chinese Indices

Chinese Macro Data

Macro Leverage Ratio

National Enterprise Index

Shibor

Tax Income

Chinese Macro Data

@kaggle.franciscofeng_chinese_macroeconomic_data_20052022.chinese_macro_data

57.54 KB
255 rows
33 columns

date Date	cpi Cpi	ppi Ppi	total_index Total Index	agricultural_index Agricultural Index	mineral_index Mineral Index	fuel_electric_index Fuel Electric Index	export Export %	import Import %	pmi Pmi	issuance_of_inv_prod Issuance Of Inv Prod	insurance_income Insurance Income	net_currency_inj Net Currency Inj
Sat Jan 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	2.4	7.1	104.67	106.22	115.83	115.83	32.7	24.6		59	3117246.68	-480
Tue Feb 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	1.9	5.8	104.82	107.92	111.23	118.83	42.1	23.9	54.7	24	5512427.64	-1030
Tue Mar 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	4	5.4	103.48	103.68	110.28	119.47	30	-5	54.5	52	11241544.37	-1900
Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	2.7	5.6	102.81	101.45	109.44	120.57	32.7	18.6	57.9	55	13778977.81	-1820
Sun May 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	1.8	5.8	103.16	100.88	110.27	122.53	31.8	16.2	56.7	28	16248657.71	-1000
Wed Jun 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	1.8	5.9	103.01	100.3	111.59	122.82	30.3	15	52.9	58	20082949.37	-1300
Fri Jul 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	1.6	5.2	102.72	100.23	110.98	123.57	30.5	15.1	51.7	58	22259891.14	-740
Mon Aug 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	1.8	5.2	102.13	99.59	110.84	123.23	28.6	12.4	51.1	71	24604393.59	-930
Thu Sep 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	1.3	5.3	101.43	98.83	109.18	121.32	33.2	23.5	52.6	65	27773271.01	-780
Sat Oct 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	0.9	4.5	100.93	98.32	106.42	120.77	25.8	23.5	55.1	84	30372843.96	-1370


CREATE TABLE chinese_macro_data (
  "date" TIMESTAMP,
  "cpi" DOUBLE,
  "ppi" DOUBLE,
  "fdi" DOUBLE,
  "total_index" DOUBLE,
  "agricultural_index" DOUBLE,
  "mineral_index" DOUBLE,
  "fuel_electric_index" DOUBLE,
  "gdp" DOUBLE,
  "export" DOUBLE,
  "import" DOUBLE,
  "pmi" DOUBLE,
  "lpi_index" DOUBLE,
  "new_financial_credit" DOUBLE,
  "consumer_confidence_index" DOUBLE,
  "total_retail_sales" DOUBLE,
  "foreign_reserve" DOUBLE,
  "money_supply" DOUBLE,
  "issuance_of_inv_prod" DOUBLE,
  "insurance_income" DOUBLE,
  "domestic_phone_sales" DOUBLE,
  "consumption_index_national" DOUBLE,
  "consumption_index_city" DOUBLE,
  "consumption_index_rural" DOUBLE,
  "inv_in_fixed_asset" DOUBLE,
  "total_export" DOUBLE,
  "total_import" DOUBLE,
  "fiscal_revenue" DOUBLE,
  "forex_loan" DOUBLE,
  "deposit_in_currency" DOUBLE,
  "net_currency_inj" DOUBLE,
  "large_bank_reserve_ratio" DOUBLE,
  "small_bank_reserve_ratio" DOUBLE
);