Chinese Macroeconomic Data (2005 - 2022)
Macroeconomic data used to perform economic or market analysis on Chinese market
@kaggle.franciscofeng_chinese_macroeconomic_data_20052022
Macroeconomic data used to perform economic or market analysis on Chinese market
@kaggle.franciscofeng_chinese_macroeconomic_data_20052022
CREATE TABLE chinese_indices (
"date" TIMESTAMP,
"wholesale_vegetable_basket" DOUBLE,
"wholesale_agriculture" DOUBLE,
"subsidiary_agricultural_products" DOUBLE,
"energy" DOUBLE,
"commodity_price" DOUBLE,
"yiwu_electronic" DOUBLE,
"construction" DOUBLE,
"construction_price" DOUBLE,
"bdti" DOUBLE,
"bsi" DOUBLE
);
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
);
CREATE TABLE macro_leverage_ratio (
"date" TIMESTAMP,
"resident" DOUBLE,
"non_financial_enterprise" DOUBLE,
"government" DOUBLE,
"central_gov" DOUBLE,
"state_gov" DOUBLE,
"real_econ" DOUBLE,
"finance_asset" DOUBLE,
"finance_liabiity" DOUBLE
);
CREATE TABLE national_enterprise_index (
"date" TIMESTAMP,
"enterprise_boom_index" DOUBLE,
"entrepreneur_confidence_index" DOUBLE
);
CREATE TABLE shibor (
"date" TIMESTAMP,
"overnight" DOUBLE,
"n_1_week" DOUBLE,
"n_2_week" DOUBLE,
"n_1_month" DOUBLE,
"n_3_month" DOUBLE,
"n_6_month" DOUBLE,
"n_1_year" DOUBLE
);
CREATE TABLE tax_income (
"date" TIMESTAMP,
"tax_income" DOUBLE
);
Anyone who has the link will be able to view this.