Russell 3000 Stock History

When in doubt, use more data!

@kaggle.williecosta_russell_3000_stock_history

Table List

1 table(324.08 MB)

Prices

@kaggle.williecosta_russell_3000_stock_history.prices

324.08 MB
12995445 rows
9 columns

unnamed_0 Unnamed: 0	symbol Symbol	date Date	open Open	high High	low Low	close Close	volume Volume	adjusted Adjusted
1	FLWS	Tue Aug 03 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	21.75	22.25	17.875	18.1875	9543400	18.1875
2	FLWS	Wed Aug 04 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	18.9375	20.5	16.875	17	4731800	17
3	FLWS	Thu Aug 05 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	17.0625	17.125	13.5	16	2851900	16
4	FLWS	Fri Aug 06 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	16	17.75	16	17	1411800	17
5	FLWS	Mon Aug 09 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	17.9375	17.9375	15.875	16	583000	16
6	FLWS	Tue Aug 10 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	15.875	15.875	14	14.875	585300	14.875
7	FLWS	Wed Aug 11 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	15.4375	15.875	14	14.3125	681500	14.3125
8	FLWS	Thu Aug 12 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	14.4375	14.75	13.8125	14.3125	540400	14.3125
9	FLWS	Fri Aug 13 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	14.5625	15.75	14.375	14.75	778600	14.75
10	FLWS	Mon Aug 16 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	14.625	17.6875	14.5	16.75	1628700	16.75


CREATE TABLE prices (
  "unnamed_0" BIGINT,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adjusted" DOUBLE
);