Chinese Income Statement (2006 - 2022)

Income Statement of all publicly traded stocks/companies on Chinese market

@kaggle.wentinglu_chinese_income_statement_2006_2022

Table List

2 tables(19.11 MB)

Chinese Income Statement

@kaggle.wentinglu_chinese_income_statement_2006_2022.chinese_income_statement

19.03 MB
203986 rows
13 columns

date Date	ticker Ticker	net_profit Net Profit	net_profit_growth Net Profit Growth	total_operating_income Total Operating Income	total_operating_income_growth Total Operating Income Growth	n__total_operating_expense_operating_expense (total Operating Expense) Operating Expense	n__total_operating_expense_sales_expense (total Operating Expense) Sales Expense	n__total_operating_expense_management_expense (total Operating Expense) Management Expense	n__total_opearting_expense_financial_expense (total Opearting Expense) Financial Expense	n__total_operating_expense_total_operating_expense (total Operating Expense) Total Operating Expense	net_operating_profit Net Operating Profit	total_profit Total Profit
Sat May 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	sh688235	-2866345000	-965.9	1947858000	-50.4222307856	414999000	1317988000	581908000	-123188000	4720140000	-2752807000	-2752876000
Fri May 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	sh688981	2843451000	175.5	11854010000	62.5627180398	6973532000	57651000	546535000	-185247000	8491615000	3649604000	3650392000
Thu May 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	sh603185	654827052.68	108.15	5674229955.88	252.6175102509	4770776204.47	1356912.96	18296707.3	14129209.2	5105571416.91	718865284.6	719768105.97
Thu May 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	sh600679	24396846.1	14.7	413919659.58	-23.3950795347	346551043.05	11530763.92	26820125.94	235082.36	390084092.47	25907144.99	29531279.27
Tue May 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	sz002765	50330902.47	25.42	765031978.48	-0.2270086721	632770517.9	10002778.43	27342068.47	8326074.18	705896025.15	63597326.63	63738839.26
Tue May 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	sz002291	86689236.13	824	803059472.48	60.035009078	590149648.74	33829958.49	63391982.85	5320302.55	715078886.61	94131465.37	92569674.06
Sat May 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	sz002726	23428412.68	-89.07	3340323108.47	-45.6716510605	3217964526.38	48995518.96	61572369.02	28683024.88	3363164635.31	39999558.88	41217796.46
Fri May 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	sh688270	6916900.56	-27.36	31320850.51	12.7733872633	3437944.19	1902911.72	5516819.1	-778170.77	21892387.3	6916900.56	6916900.56
Fri May 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	sh605555	60074020.42	2.42	570162735.47	-7.4093694561	457919498.03	1881846.81	25773417.73	324039.31	513131145.52	68538713.36	68574199.28
Fri May 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	sh603878	32310534.57	-36.11	566895114.98	-12.098194584	502918740.43	8420614.67	20126928.37	3986354.85	545786576.87	21246439.05	36827440.53


CREATE TABLE chinese_income_statement (
  "date" TIMESTAMP,
  "ticker" VARCHAR,
  "net_profit" DOUBLE,
  "net_profit_growth" DOUBLE,
  "total_operating_income" DOUBLE,
  "total_operating_income_growth" DOUBLE,
  "n__total_operating_expense_operating_expense" DOUBLE,
  "n__total_operating_expense_sales_expense" DOUBLE,
  "n__total_operating_expense_management_expense" DOUBLE,
  "n__total_opearting_expense_financial_expense" DOUBLE,
  "n__total_operating_expense_total_operating_expense" DOUBLE,
  "net_operating_profit" DOUBLE,
  "total_profit" DOUBLE
);