S&P 500 Quarterly Metrics & Ratios

Quarterly financial metrics for сurrent S&P500 companies from 2009 onwards.

@kaggle.danielbrito99_s_and_p_500_quarterly_financials

Table List

3 tables(8.16 MB)

Fed Funds Rate Historical Chart

Sp500 Macro Quarterly Data

Sp500 Quarterly Data

Sp500 Quarterly Data

@kaggle.danielbrito99_s_and_p_500_quarterly_financials.sp500_quarterly_data

3.94 MB
28579 rows
43 columns

unnamed_0 Unnamed: 0	ticker Ticker	pe_ratio Pe-ratio	price_sales Price-sales	price_book Price-book	price_fcf Price-fcf	current_ratio Current-ratio	quick_ratio Quick-ratio	debt_equity_ratio Debt-equity-ratio	roe Roe	roa Roa	return_on_tangible_equity Return-on-tangible-equity	ebitda_margin Ebitda-margin	total_assets_q Total-assets Q	total_assets_yoy Total-assets YoY	total_liabilities_q Total-liabilities Q	total_liabilities_yoy Total-liabilities YoY	total_share_holder_equity_q Total-share-holder-equity Q	total_share_holder_equity_yoy Total-share-holder-equity YoY	long_term_debt_q Long-term-debt Q	long_term_debt_yoy Long-term-debt YoY	shares_outstanding_q Shares-outstanding Q	shares_outstanding_yoy Shares-outstanding YoY	eps_earnings_per_share_diluted_ttm Eps-earnings-per-share-diluted TTM	eps_earnings_per_share_diluted_q Eps-earnings-per-share-diluted Q	eps_earnings_per_share_diluted_yoy Eps-earnings-per-share-diluted YoY	net_income_ttm Net-income TTM	net_income_q Net-income Q	net_income_yoy Net-income YoY	ebitda_ttm Ebitda TTM	ebitda_q Ebitda Q	ebitda_yoy Ebitda YoY	operating_income_ttm Operating-income TTM	operating_income_q Operating-income Q	operating_income_yoy Operating-income YoY	gross_profit_ttm Gross-profit TTM	gross_profit_q Gross-profit Q	gross_profit_yoy Gross-profit YoY	revenue_ttm Revenue TTM	revenue_q Revenue Q	revenue_yoy Revenue YoY	adj_close Adj Close	yearly_change Yearly Change (%)
Tue Mar 31 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM					1.829	1.266	0.502																																	32.709145	73.0266780131367
Tue Jun 30 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM					1.861	1.372	0.461																																	39.882557	34.97178729036857
Wed Sep 30 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM					1.942	1.485	0.403																																	49.331566	20.536400567539246
Thu Dec 31 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	12.48	1.72	3.01	9.55	2.204	1.666	0.383	26.84	12.13	66.87	25.82	105.316	27.25	57.733	13.948	47.583	13.302	20.561	5.097	2.814	0.707	4.52	1.31		3.193	0.935		5.971	1.64		4.814	1.342		11.014	2.933		23.123	6.122		55.620762	7.068772268887652
Wed Mar 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	11.32	1.67	2.95	8.79	2.352	1.808	0.367	28.11	13.23	63.45	27.19	109	28.022	57.707	14.171	51.293	13.851	20.553	5.08	2.842	0.724	5.07	1.29	74.32	3.605	0.93	79.54	6.629	1.732	61.27	5.456	1.445	79.95	11.807	3.11	34.23	24.382	6.348	24.74	56.595547	14.689242247274317
Wed Jun 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	9.94	1.54	2.72	9.11	2.371	1.823	0.347	29.03	14.16	60.66	27.6	111.401	28.496	57.066	14.233	54.335	14.263	20.33	4.949	2.868	0.726	5.49	1.54	37.5	3.943	1.121	43.17	7.008	1.868	25.45	5.861	1.596	34.01	12.361	3.296	20.2	25.394	6.731	17.7	53.8302	23.042968445222197
Thu Sep 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	10.63	1.67	2.72	11.31	2.604	2.008	0.322	28.59	14.38	56.46	27.21	113.833	30.065	56.584	14.232	57.249	15.833	20.231	5.105	2.882	0.725	5.67	1.53	13.33	4.092	1.106	15.57	7.094	1.854	4.86	5.959	1.576	6.63	12.63	3.291	8.9	26.075	6.874	11	59.462494	-15.12407636316095
Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	10.72	1.64	2.68	10.51	2.006	1.488	0.261	27.25	14	54.04	26.4	116.739	30.156	56.775	14.139	59.964	16.017	19.317	4.183	2.901	0.726	5.63	1.27	-3.05	4.085	0.928	-0.75	7.038	1.584	-3.41	5.918	1.301	-3.06	12.831	3.134	6.85	26.662	6.709	9.59	59.552467	-2.836466875503242
Thu Mar 31 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	11.29	1.73	2.77	12.78	2.143	1.552	0.266	26.9	14.14	54.36	25.97	119.846	31.129	56.846	14.242	63	16.887	18.723	4.486	2.903	0.726	5.83	1.49	15.5	4.236	1.081	16.24	7.173	1.867	7.79	6.051	1.578	9.2	13.23	3.509	12.83	27.625	7.311	15.17	64.909004	-2.039268696835951
Thu Jun 30 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	11.4	1.71	2.69	12.36	2.182	1.583	0.253	25.72	13.83	52.98	25.47	123.632	32.282	57.153	14.54	66.479	17.742	18.258	4.484	2.904	0.727	5.89	1.6	3.9	4.275	1.16	3.48	7.279	1.974	5.67	6.11	1.655	3.7	13.574	3.64	10.44	28.574	7.68	14.1	66.234276	-2.9119077258427306


CREATE TABLE sp500_quarterly_data (
  "unnamed_0" TIMESTAMP,
  "ticker" VARCHAR,
  "pe_ratio" DOUBLE,
  "price_sales" DOUBLE,
  "price_book" DOUBLE,
  "price_fcf" DOUBLE,
  "current_ratio" DOUBLE,
  "quick_ratio" DOUBLE,
  "debt_equity_ratio" DOUBLE,
  "roe" DOUBLE,
  "roa" DOUBLE,
  "return_on_tangible_equity" DOUBLE,
  "ebitda_margin" DOUBLE,
  "total_assets_q" DOUBLE,
  "total_assets_yoy" DOUBLE,
  "total_liabilities_q" DOUBLE,
  "total_liabilities_yoy" DOUBLE,
  "total_share_holder_equity_q" DOUBLE,
  "total_share_holder_equity_yoy" DOUBLE,
  "long_term_debt_q" DOUBLE,
  "long_term_debt_yoy" DOUBLE,
  "shares_outstanding_q" DOUBLE,
  "shares_outstanding_yoy" DOUBLE,
  "eps_earnings_per_share_diluted_ttm" DOUBLE,
  "eps_earnings_per_share_diluted_q" DOUBLE,
  "eps_earnings_per_share_diluted_yoy" DOUBLE,
  "net_income_ttm" DOUBLE,
  "net_income_q" DOUBLE,
  "net_income_yoy" DOUBLE,
  "ebitda_ttm" DOUBLE,
  "ebitda_q" DOUBLE,
  "ebitda_yoy" DOUBLE,
  "operating_income_ttm" DOUBLE,
  "operating_income_q" DOUBLE,
  "operating_income_yoy" DOUBLE,
  "gross_profit_ttm" DOUBLE,
  "gross_profit_q" DOUBLE,
  "gross_profit_yoy" DOUBLE,
  "revenue_ttm" DOUBLE,
  "revenue_q" DOUBLE,
  "revenue_yoy" DOUBLE,
  "adj_close" DOUBLE,
  "yearly_change" DOUBLE
);