PREVIEW / stock_daily / 2011-10-28

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-28.parquet
  size:    196 KB
  rows:    6,098
  symbols: 3,529

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
2011-10-28	AAPL	Stock	14.3929	14.5125	14.3754	14.4625	322842800.0
2011-10-28	MSFT	Stock	27.14	27.19	26.79	26.98	57712100.0
2011-10-28	NVDA	Stock	0.378	0.3935	0.377	0.39	490156000.0
2011-10-28	AMZN	Stock	10.3265	10.92	10.2875	10.866	197608000.0
2011-10-28	TSLA	Stock	1.9	2.0	1.8673	1.9913	18960000.0
2011-10-28	TLT	Stock	110.9	111.96	110.76	111.46	10127838.0
2011-10-28	ES	Stock	34.87	34.87	34.32	34.58	1664700.0
2011-10-28	CL	Stock	45.205	45.87	44.93	45.61	4726800.0
2011-10-28	A	Stock	28.4979	29.3634	28.3977	29.2489	8831725.0
2011-10-28	AABA-DELISTED	Stock	16.4099	16.7	16.25	16.55	19801255.0
2011-10-28	AACC-DELISTED	Stock	3.01	3.09	3.0	3.0325	6517.0
2011-10-28	AACG	Stock	9.25	9.3	9.23	9.3	2200.0
2011-10-28	AAIC-DELISTED	Stock	24.28	24.54	24.02	24.06	57064.0
2011-10-28	AAME	Stock	1.9	1.9	1.73	1.85	2200.0
2011-10-28	AAON	Stock	6.717	6.7941	6.4178	6.477	292613.0
2011-10-28	AAP	Stock	65.89	66.93	65.26	65.67	484200.0
2011-10-28	AAT	Stock	20.73	21.21	20.73	20.88	140200.0
2011-10-28	AATI-DELISTED	Stock	4.5	4.5	4.45	4.46	176744.0
2011-10-28	AAU-DELISTED	Stock	2.89	2.95	2.8201	2.93	89504.0
2011-10-28	AAUAF-DELISTED	Stock	2.89	2.95	2.8201	2.93	90204.0
2011-10-28	AAV-DELISTED	Stock	5.36	5.52	5.33	5.48	290613.0
2011-10-28	AAWW-DELISTED	Stock	42.55	43.13	41.36	42.26	151783.0
2011-10-28	AAXJ	Stock	55.09	55.99	54.99	55.64	655917.0
2011-10-28	AAXN-DELISTED	Stock	4.99	5.0	4.83	4.84	471580.0
2011-10-28	AB	Stock	14.36	14.56	14.07	14.39	428000.0
2011-10-28	ABAC-DELISTED	Stock	1.85	1.85	1.588	1.81	73340.0
2011-10-28	ABAX-DELISTED	Stock	28.19	29.28	28.19	28.58	156902.0
2011-10-28	ABB-DELISTED	Stock	20.23	20.28	19.81	19.94	4274625.0
2011-10-28	ABBNY-DELISTED	Stock	20.23	20.28	19.81	19.95	4302225.0
2011-10-28	ABC-DELISTED	Stock	42.32	42.32	41.31	42.09	1873718.0
2011-10-28	ABCB	Stock	10.55	10.98	10.46	10.51	93600.0
2011-10-28	ABCD-DELISTED	Stock	3.57	3.66	3.455	3.47	47232.0
2011-10-28	ABCO-DELISTED	Stock	31.26	31.5	30.81	30.89	264439.0
2011-10-28	ABCW-DELISTED	Stock	0.5195	0.5195	0.4946	0.5105	43700.0
2011-10-28	ABD-DELISTED	Stock	7.05	7.25	6.961	7.16	274080.0
2011-10-28	ABE-DELISTED	Stock	18.37	18.56	18.14	18.43	8185.0
2011-10-28	ABEO	Stock	2187.5	2187.5	2075.0	2175.0	11.0
2011-10-28	ABFS-DELISTED	Stock	21.84	21.89	20.5	20.59	1037383.0
2011-10-28	ABG	Stock	19.55	19.67	18.86	19.32	553300.0
2011-10-28	ABH-DELISTED	Stock	16.89	17.22	16.73	17.01	416317.0
2011-10-28	ABM	Stock	21.36	21.46	20.82	20.91	300200.0
2011-10-28	ABMD-DELISTED	Stock	14.3	15.86	14.3	15.27	374187.0
2011-10-28	ABR	Stock	3.55	3.73	3.52	3.7	48100.0
2011-10-28	ABT	Stock	26.01	26.1059	25.7653	26.0148	15620884.0
2011-10-28	ABTL-DELISTED	Stock	4.5	4.6005	4.35	4.5	5830.0
2011-10-28	ABUS	Stock	1.6	1.7	1.6	1.7	1200.0
2011-10-28	ABV-DELISTED	Stock	33.93	34.56	33.86	34.51	2738351.0
2011-10-28	ABVA-DELISTED	Stock	5.6	5.6	5.5	5.5	9253.0
2011-10-28	ABVT-DELISTED	Stock	59.5	60.4	59.14	59.9	111034.0
2011-10-28	ABX-DELISTED	Stock	49.05	50.95	48.76	50.89	8956220.0

> showing 50 of 6,098 rows — these rows as CSV

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