PREVIEW / stock_daily / 2011-07-27

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-27.parquet
  size:    199 KB
  rows:    6,138
  symbols: 3,559

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-07-27	AAPL	Stock	14.3068	14.38	14.0054	14.0211	659324400.0
2011-07-27	MSFT	Stock	27.88	27.99	27.2	27.33	71488700.0
2011-07-27	NVDA	Stock	0.355	0.3568	0.3455	0.3465	652212000.0
2011-07-27	AMZN	Stock	11.2195	11.36	10.981	11.126	259112000.0
2011-07-27	TSLA	Stock	1.9	1.9	1.834	1.8427	14377500.0
2011-07-27	TLT	Stock	95.34	95.84	95.1	95.66	11229120.0
2011-07-27	ES	Stock	34.85	35.05	34.69	34.85	1583600.0
2011-07-27	CL	Stock	43.195	43.41	42.71	42.745	5197000.0
2011-07-27	A	Stock	31.7883	31.7883	30.2504	30.372	9148232.0
2011-07-27	AABA-DELISTED	Stock	13.88	13.9	13.57	13.59	19837373.0
2011-07-27	AACC-DELISTED	Stock	4.6	4.6	4.4	4.46	5065.0
2011-07-27	AACG	Stock	9.63	9.7	9.08	9.32	12400.0
2011-07-27	AAIC-DELISTED	Stock	30.78	30.89	29.58	29.77	88983.0
2011-07-27	AAME	Stock	2.01	2.05	1.94	2.04	5200.0
2011-07-27	AAON	Stock	6.6104	6.7733	6.5067	6.5274	194063.0
2011-07-27	AAP	Stock	57.43	57.43	56.1	56.2	1535300.0
2011-07-27	AAT	Stock	22.5	22.5	21.4	21.81	287600.0
2011-07-27	AATI-DELISTED	Stock	6.09	6.09	6.06	6.06	1743017.0
2011-07-27	AAU-DELISTED	Stock	3.61	3.65	3.45	3.45	213121.0
2011-07-27	AAUAF-DELISTED	Stock	3.61	3.65	3.45	3.45	213221.0
2011-07-27	AAV-DELISTED	Stock	7.33	7.37	7.22	7.25	328246.0
2011-07-27	AAWW-DELISTED	Stock	55.54	55.88	54.77	54.98	184019.0
2011-07-27	AAXJ	Stock	62.88	62.88	62.02	62.16	359778.0
2011-07-27	AAXN-DELISTED	Stock	4.18	4.18	4.08	4.11	369378.0
2011-07-27	AB	Stock	18.5	18.51	17.78	17.82	441900.0
2011-07-27	ABAC-DELISTED	Stock	2.75	2.84	2.5	2.52	33066.0
2011-07-27	ABAX-DELISTED	Stock	28.45	28.48	27.49	27.55	161807.0
2011-07-27	ABB-DELISTED	Stock	24.58	24.59	23.97	24.12	3445259.0
2011-07-27	ABBC-DELISTED	Stock	9.95	9.95	9.611	9.66	73548.0
2011-07-27	ABBNY-DELISTED	Stock	24.58	24.59	23.97	24.13	3451422.0
2011-07-27	ABC-DELISTED	Stock	39.77	40.11	38.95	39.01	3352355.0
2011-07-27	ABCB	Stock	10.1	10.14	10.01	10.05	84800.0
2011-07-27	ABCD-DELISTED	Stock	3.26	3.26	3.16	3.18	29405.0
2011-07-27	ABCO-DELISTED	Stock	27.75	27.75	26.43	26.47	160242.0
2011-07-27	ABCW-DELISTED	Stock	0.6797	0.6811	0.6493	0.6503	58550.0
2011-07-27	ABD-DELISTED	Stock	8.38	8.47	7.49	8.29	1284320.0
2011-07-27	ABE-DELISTED	Stock	19.24	19.3	18.948	18.948	50269.0
2011-07-27	ABEO	Stock	3000.0	3000.0	2587.5	2812.5	21.0
2011-07-27	ABFS-DELISTED	Stock	24.53	24.53	23.82	23.89	272723.0
2011-07-27	ABG	Stock	21.15	21.82	20.52	20.61	516200.0
2011-07-27	ABH-DELISTED	Stock	19.36	19.4	18.67	18.83	927382.0
2011-07-27	ABM	Stock	22.8	22.85	22.32	22.5	294100.0
2011-07-27	ABMD-DELISTED	Stock	16.23	16.26	16.01	16.07	195292.0
2011-07-27	ABR	Stock	4.34	4.41	4.16	4.25	114200.0
2011-07-27	ABT	Stock	24.9304	25.036	24.8296	24.868	14421426.0
2011-07-27	ABTL-DELISTED	Stock	5.353	5.353	4.949	5.05	29199.0
2011-07-27	ABUS	Stock	2.42	2.42	2.4	2.4	600.0
2011-07-27	ABV-DELISTED	Stock	30.72	30.72	30.02	30.21	4977035.0
2011-07-27	ABVA-DELISTED	Stock	4.3701	4.6492	4.3701	4.55	2346.0
2011-07-27	ABVT-DELISTED	Stock	63.15	63.26	61.45	61.77	169937.0

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

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