PREVIEW / stock_daily / 2010-09-01

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-01.parquet
  size:    190 KB
  rows:    5,957
  symbols: 3,501

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2010-09-01	AAPL	Stock	8.8382	8.9807	8.7957	8.9404	697037600.0
2010-09-01	MSFT	Stock	23.67	23.95	23.54	23.9	65235900.0
2010-09-01	NVDA	Stock	0.2368	0.2398	0.2338	0.235	851440000.0
2010-09-01	AMZN	Stock	6.318	6.63	6.3085	6.6245	142766000.0
2010-09-01	TSLA	Stock	1.308	1.3793	1.3067	1.3633	7423500.0
2010-09-01	TLT	Stock	107.02	107.05	105.09	106.0	12480911.0
2010-09-01	ES	Stock	29.28	29.86	29.2	29.64	1950700.0
2010-09-01	CL	Stock	37.37	37.655	37.2	37.46	5829800.0
2010-09-01	A	Stock	19.6352	20.3505	19.6209	20.2361	5088580.0
2010-09-01	AABA-DELISTED	Stock	13.2	13.41	13.13	13.36	24415796.0
2010-09-01	AACC-DELISTED	Stock	3.9	3.94	3.83	3.92	33684.0
2010-09-01	AACG	Stock	2.95	2.95	2.86	2.94	48300.0
2010-09-01	AAI-DELISTED	Stock	4.59	4.65	4.5301	4.65	1331913.0
2010-09-01	AAIC-DELISTED	Stock	19.91	20.8	19.91	20.8	75048.0
2010-09-01	AAME	Stock	1.29	1.36	1.29	1.36	15800.0
2010-09-01	AAON	Stock	4.4583	4.5175	4.3931	4.4484	609525.0
2010-09-01	AAP	Stock	55.08	55.98	55.08	55.48	666800.0
2010-09-01	AATI-DELISTED	Stock	3.3	3.47	3.29	3.47	193829.0
2010-09-01	AAU-DELISTED	Stock	2.28	2.28	2.09	2.1401	403846.0
2010-09-01	AAUAF-DELISTED	Stock	2.28	2.28	2.09	2.1401	408946.0
2010-09-01	AAV-DELISTED	Stock	6.06	6.18	5.9701	6.09	406365.0
2010-09-01	AAWW-DELISTED	Stock	44.58	45.5	43.61	45.37	281897.0
2010-09-01	AAXJ	Stock	55.23	56.0	55.23	55.95	582534.0
2010-09-01	AAXN-DELISTED	Stock	3.75	3.91	3.73	3.9	650527.0
2010-09-01	AB	Stock	23.88	24.47	23.88	24.42	331000.0
2010-09-01	ABAC-DELISTED	Stock	3.78	3.95	3.65	3.8	18980.0
2010-09-01	ABAX-DELISTED	Stock	18.36	19.03	18.2001	19.01	76696.0
2010-09-01	ABB-DELISTED	Stock	19.72	19.97	19.7	19.84	1732007.0
2010-09-01	ABBC-DELISTED	Stock	10.15	10.15	10.0	10.15	60973.0
2010-09-01	ABBNY-DELISTED	Stock	19.72	19.97	19.7	19.84	1754790.0
2010-09-01	ABC-DELISTED	Stock	27.46	28.28	27.46	27.97	2822241.0
2010-09-01	ABCB	Stock	7.98	8.32	7.85	8.29	63200.0
2010-09-01	ABCD-DELISTED	Stock	2.89	3.15	2.84	3.04	94538.0
2010-09-01	ABCO-DELISTED	Stock	20.52	20.92	20.52	20.92	79998.0
2010-09-01	ABCW-DELISTED	Stock	0.5922	0.64	0.5827	0.64	56470.0
2010-09-01	ABD-DELISTED	Stock	5.9049	6.0851	5.7648	6.0751	276840.0
2010-09-01	ABE-DELISTED	Stock	17.08	17.3875	17.08	17.27	12273.0
2010-09-01	ABEO	Stock	2500.0	2500.0	2437.5	2475.0	18.0
2010-09-01	ABFS-DELISTED	Stock	20.94	21.26	20.55	21.23	380777.0
2010-09-01	ABG	Stock	12.18	12.92	12.06	12.91	135800.0
2010-09-01	ABII-DELISTED	Stock	73.8	74.25	73.26	74.06	71923.0
2010-09-01	ABK-DELISTED	Stock	0.5521	0.615	0.5432	0.585	11823426.0
2010-09-01	ABM	Stock	19.99	20.86	19.79	20.8	337200.0
2010-09-01	ABMD-DELISTED	Stock	9.21	9.4	9.03	9.22	126369.0
2010-09-01	ABR	Stock	4.59	4.96	4.49	4.8	68900.0
2010-09-01	ABT	Stock	23.8557	24.2827	23.8557	24.1195	14708420.0
2010-09-01	ABTL-DELISTED	Stock	4.2737	4.4212	4.1373	4.35	3516.0
2010-09-01	ABV-DELISTED	Stock	112.0	114.23	111.38	112.84	700565.0
2010-09-01	ABVA-DELISTED	Stock	2.99	2.99	2.99	2.99	300.0
2010-09-01	ABVT-DELISTED	Stock	52.02	54.14	52.02	53.97	141867.0

> showing 50 of 5,957 rows — these rows as CSV

> unlock the full archive -- $79 one-time