New York Stock Exchange

S&P 500 companies historical prices with fundamental data

@kaggle.dgawlik_nyse

Table List

4 tables(26.49 MB)

Fundamentals

Prices Split Adjusted

Prices

Securities

Fundamentals

@kaggle.dgawlik_nyse.fundamentals

789.72 KB
1781 rows
79 columns

unnamed_0 Unnamed: 0	ticker_symbol Ticker Symbol	period_ending Period Ending	accounts_payable Accounts Payable	accounts_receivable Accounts Receivable	add_l_income_expense_items Add\u0027l Income/expense Items	after_tax_roe After Tax ROE	capital_expenditures Capital Expenditures	capital_surplus Capital Surplus	cash_ratio Cash Ratio	cash_and_cash_equivalents Cash And Cash Equivalents	changes_in_inventories Changes In Inventories	common_stocks Common Stocks	cost_of_revenue Cost Of Revenue	current_ratio Current Ratio	deferred_asset_charges Deferred Asset Charges	deferred_liability_charges Deferred Liability Charges	depreciation Depreciation	earnings_before_interest_and_tax Earnings Before Interest And Tax	earnings_before_tax Earnings Before Tax	effect_of_exchange_rate Effect Of Exchange Rate	fixed_assets Fixed Assets	goodwill Goodwill	gross_margin Gross Margin	gross_profit Gross Profit	income_tax Income Tax	intangible_assets Intangible Assets	interest_expense Interest Expense	inventory Inventory	investments Investments	liabilities Liabilities	long_term_debt Long-Term Debt	long_term_investments Long-Term Investments	net_borrowings Net Borrowings	net_cash_flow Net Cash Flow	net_cash_flow_operating Net Cash Flow-Operating	net_cash_flows_financing Net Cash Flows-Financing	net_cash_flows_investing Net Cash Flows-Investing	net_income Net Income	net_income_adjustments Net Income Adjustments	net_income_applicable_to_common_shareholders Net Income Applicable To Common Shareholders	net_income_cont_operations Net Income-Cont. Operations	net_receivables Net Receivables	non_recurring_items Non-Recurring Items	operating_income Operating Income	operating_margin Operating Margin	other_assets Other Assets	other_current_assets Other Current Assets	other_current_liabilities Other Current Liabilities	other_equity Other Equity	other_financing_activities Other Financing Activities	other_investing_activities Other Investing Activities	other_liabilities Other Liabilities	other_operating_activities Other Operating Activities	other_operating_items Other Operating Items	pre_tax_margin Pre-Tax Margin	pre_tax_roe Pre-Tax ROE	profit_margin Profit Margin	quick_ratio Quick Ratio	research_and_development Research And Development	retained_earnings Retained Earnings	sale_and_purchase_of_stock Sale And Purchase Of Stock	sales_general_and_admin Sales, General And Admin.	short_term_debt_current_portion_of_long_term_debt Short-Term Debt / Current Portion Of Long-Term Debt	short_term_investments Short-Term Investments	total_assets Total Assets	total_current_assets Total Current Assets	total_current_liabilities Total Current Liabilities	total_equity Total Equity	total_liabilities Total Liabilities	total_liabilities_equity Total Liabilities \u0026 Equity	total_revenue Total Revenue	treasury_stock Treasury Stock	for_year For Year	earnings_per_share Earnings Per Share	estimated_shares_outstanding Estimated Shares Outstanding
	AAL	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	3068000000	-222000000	-1961000000	23	-1888000000	4695000000	53	1330000000		127000000	10499000000	78		223000000	1001000000	-1813000000	-2445000000		13402000000		58	14356000000	-569000000	869000000	632000000	580000000	306000000	473000000	7116000000		-1020000000	197000000	1285000000	483000000	-1571000000	-1876000000	2050000000	-1876000000	-4084000000	1124000000	386000000	148000000	1	2167000000	626000000	4524000000	-2980000000	1509000000	11000000	15147000000	-141000000	845000000	10	31	8	72		-9462000000		12977000000	1419000000	3412000000	23510000000	7072000000	9011000000	-7987000000	24891000000	16904000000	24855000000	-367000000	2012	-5.6	335000000
1	AAL	Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	4975000000	-93000000	-2723000000	67	-3114000000	10592000000	75	2175000000		5000000	11019000000	104		935000000	1020000000	-1324000000	-2180000000		19259000000	4086000000	59	15724000000	-346000000	2311000000	856000000	1012000000	-1181000000	-235000000	15353000000		2208000000	660000000	675000000	3799000000	-3814000000	-1834000000	1873000000	-1834000000	-4489000000	1560000000	559000000	1399000000	5	2299000000	1465000000	7385000000	-2032000000	1711000000	481000000	14915000000	-56000000	853000000	8	80	7	96		-11296000000		12913000000	1446000000	8111000000	42278000000	14323000000	13806000000	-2731000000	45009000000	42278000000	26743000000		2013	-11.25	163022222.222
2	AAL	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	4668000000	-160000000	-150000000	143	-5311000000	15135000000	60	1768000000		7000000	15620000000	88		829000000	1342000000	4099000000	3212000000		23084000000	4091000000	63	27030000000	330000000	2240000000	887000000	1004000000	1799000000	-1026000000	16043000000		170000000	-146000000	3080000000	-315000000	-2911000000	2882000000	542000000	2882000000	2882000000	1771000000	800000000	4249000000	10	2060000000	898000000	7059000000	-4559000000	817000000	601000000	10928000000	-500000000	1295000000	8	159	7	80		-8562000000	-1052000000	20686000000	1677000000	6309000000	43225000000	11750000000	13404000000	2021000000	41204000000	43225000000	42650000000		2014	4.02	716915422.886
3	AAL	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	5102000000	352000000	-708000000	135	-6151000000	11591000000	51	1085000000		6000000	11096000000	73	2477000000	667000000	1487000000	5496000000	4616000000		27510000000	4091000000	73	29894000000	-2994000000	2249000000	880000000	863000000	443000000	-633000000	18330000000		2856000000	-604000000	6249000000	-1259000000	-5594000000	7610000000	-2662000000	7610000000	7610000000	1425000000	1051000000	6204000000	15	2103000000	748000000	6272000000	-4732000000	96000000	114000000	10178000000	95000000	1364000000	11	82	19	67		-1230000000	-3846000000	21275000000	2231000000	5864000000	48415000000	9985000000	13605000000	5635000000	42780000000	48415000000	40990000000		2015	11.39	668129938.543
4	AAP	Sat Dec 29 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2409453000	-89482000	600000	32	-271182000	520215000	23	598111000	-260298000	7000	3106967000	124			189544000	657915000	624074000		1292547000	76389000	50	3098036000	236404000	28845000	33841000	2308609000		426323000	604461000		177445000	540210000	685281000	127907000	-272978000	387670000	23311000	387670000	387670000	229866000		657315000	11	31833000	47614000	149558000	2667000	-33499000	-1796000	239021000	8213000		10	52	6	34		714900000	-18600000	2440721000	627000		4613814000	3184200000	2559638000	1210694000	3403120000	4613814000	6205003000	-27095000	2012	5.29	73283553.8752
5	AAP	Sat Dec 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	2609239000	-32428000	2698000	26	-195757000	531293000	40	1112471000	-203513000	7000	3241668000	144			207795000	663016000	626398000		1286034000	199835000	50	3252146000	234640000	49872000	36618000	2556557000		172715000	1052668000		445679000	514360000	545250000	331217000	-362107000	391758000	-2088000	391758000	391758000	277595000		660318000	10	39649000	42761000	154630000	3683000	-27209000	-166350000	231116000	11011000		10	41	6	52		1089112000	-77184000	2591828000	916000		5564774000	3989384000	2764785000	1516205000	4048569000	5564774000	6493814000	-107890000	2013	5.36	73089179.1045
6	AAP	Sat Jan 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	3616038000	-48209000	3092000	25	-228446000	562945000	3	104671000	-227657000	7000	5390248000	130		446351000	284693000	854802000	781394000	-4465000	1432030000	995426000	45	4453613000	287569000	748125000	73408000	3936955000		194223000	1636311000		599619000	-1007800000	708991000	575911000	-2288237000	493825000	75598000	493825000	493825000	579825000		851710000	9	45737000	119589000	37796000	-12337000	-18039000	-2059791000	222368000	-63482000		8	39	5	22		1565341000	1424000	3601903000	582000		7962358000	4741040000	3654416000	2002912000	5959446000	7962358000	9843861000	-113044000	2014	6.75	73159259.2593
7	AAP	Sat Jan 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	3757085000	-21476000	-7484000	19	-234747000	603332000	2	90782000	-244096000	7000	5314246000	130		433925000	269476000	818296000	752888000	-4213000	1434577000	989484000	45	4422772000	279490000	687125000	65408000	4174768000		174667000	1213161000		-426322000	-13889000	689642000	-445952000	-253366000	473398000	30250000	473398000	473398000	597788000		825780000	8	82633000	77408000	39794000	-44059000	-13492000	-18619000	229354000	7423000		8	31	5	20		2021077000	-1491000	3596992000	598000		8134565000	4940746000	3797477000	2460648000	5673917000	8134565000	9737018000	-119709000	2015	6.45	73395038.7597
8	AAPL	Sat Sep 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	36223000000	-1949000000	1156000000	30	-8165000000		93	14259000000	-973000000	19764000000	106606000000	168		2625000000	6757000000	50155000000	50155000000		16597000000	1577000000	38	64304000000	13118000000	4179000000		1764000000	-24042000000	8320000000	16960000000	106215000000	16896000000	3513000000	53666000000	-16379000000	-33774000000	37037000000	3394000000	37037000000	37037000000	24094000000		48999000000	29	5146000000	6882000000	7435000000	-471000000	-1082000000	-1567000000	20208000000	1080000000		29	41	22	164	4475000000	104256000000	-22330000000	10830000000		26287000000	207000000000	73286000000	43658000000	123549000000	83451000000	207000000000	170910000000		2013	40.03	925231076.692
9	AAPL	Sat Sep 27 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	48649000000	-6452000000	980000000	35	-9571000000		40	13844000000	-76000000	23313000000	112258000000	108		3031000000	7946000000	53483000000	53483000000		20624000000	4616000000	39	70537000000	13973000000	4142000000		2111000000	-9027000000	13408000000	28987000000	130162000000	18266000000	-415000000	59713000000	-37549000000	-22579000000	39510000000	5210000000	39510000000	39510000000	31537000000		52503000000	29	3764000000	9806000000	8491000000	1082000000	-1158000000	-3981000000	24826000000	167000000		29	48	22	105	6041000000	87152000000	-44270000000	11993000000	6308000000	11233000000	231839000000	68531000000	63448000000	111547000000	120292000000	231839000000	182795000000		2014	6.49	6087827426.81


CREATE TABLE fundamentals (
  "unnamed_0" BIGINT,
  "ticker_symbol" VARCHAR,
  "period_ending" TIMESTAMP,
  "accounts_payable" DOUBLE,
  "accounts_receivable" DOUBLE,
  "add_l_income_expense_items" DOUBLE,
  "after_tax_roe" DOUBLE,
  "capital_expenditures" DOUBLE,
  "capital_surplus" DOUBLE,
  "cash_ratio" DOUBLE,
  "cash_and_cash_equivalents" DOUBLE,
  "changes_in_inventories" DOUBLE,
  "common_stocks" DOUBLE,
  "cost_of_revenue" DOUBLE,
  "current_ratio" DOUBLE,
  "deferred_asset_charges" DOUBLE,
  "deferred_liability_charges" DOUBLE,
  "depreciation" DOUBLE,
  "earnings_before_interest_and_tax" DOUBLE,
  "earnings_before_tax" DOUBLE,
  "effect_of_exchange_rate" DOUBLE,
  "equity_earnings_loss_unconsolidated_subsidiary" DOUBLE,
  "fixed_assets" DOUBLE,
  "goodwill" DOUBLE,
  "gross_margin" DOUBLE,
  "gross_profit" DOUBLE,
  "income_tax" DOUBLE,
  "intangible_assets" DOUBLE,
  "interest_expense" DOUBLE,
  "inventory" DOUBLE,
  "investments" DOUBLE,
  "liabilities" DOUBLE,
  "long_term_debt" DOUBLE,
  "long_term_investments" DOUBLE,
  "minority_interest" DOUBLE,
  "misc_stocks" DOUBLE,
  "net_borrowings" DOUBLE,
  "net_cash_flow" DOUBLE,
  "net_cash_flow_operating" DOUBLE,
  "net_cash_flows_financing" DOUBLE,
  "net_cash_flows_investing" DOUBLE,
  "net_income" DOUBLE,
  "net_income_adjustments" DOUBLE,
  "net_income_applicable_to_common_shareholders" DOUBLE,
  "net_income_cont_operations" DOUBLE,
  "net_receivables" DOUBLE,
  "non_recurring_items" DOUBLE,
  "operating_income" DOUBLE,
  "operating_margin" DOUBLE,
  "other_assets" DOUBLE,
  "other_current_assets" DOUBLE,
  "other_current_liabilities" DOUBLE,
  "other_equity" DOUBLE,
  "other_financing_activities" DOUBLE,
  "other_investing_activities" DOUBLE,
  "other_liabilities" DOUBLE,
  "other_operating_activities" DOUBLE,
  "other_operating_items" DOUBLE,
  "pre_tax_margin" DOUBLE,
  "pre_tax_roe" DOUBLE,
  "profit_margin" DOUBLE,
  "quick_ratio" DOUBLE,
  "research_and_development" DOUBLE,
  "retained_earnings" DOUBLE,
  "sale_and_purchase_of_stock" DOUBLE,
  "sales_general_and_admin" DOUBLE,
  "short_term_debt_current_portion_of_long_term_debt" DOUBLE,
  "short_term_investments" DOUBLE,
  "total_assets" DOUBLE,
  "total_current_assets" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "total_equity" DOUBLE,
  "total_liabilities" DOUBLE,
  "total_liabilities_equity" DOUBLE,
  "total_revenue" DOUBLE,
  "treasury_stock" DOUBLE,
  "for_year" DOUBLE,
  "earnings_per_share" DOUBLE,
  "estimated_shares_outstanding" DOUBLE
);