PREVIEW / stock_daily / 2011-11-11

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-11.parquet
  size:    196 KB
  rows:    6,096
  symbols: 3,514

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-11-11	AAPL	Stock	13.8075	13.8821	13.5807	13.7364	653786000.0
2011-11-11	MSFT	Stock	26.58	27.08	26.57	26.91	37903000.0
2011-11-11	NVDA	Stock	0.372	0.3775	0.3518	0.3745	1751560000.0
2011-11-11	AMZN	Stock	10.626	10.894	10.5155	10.8695	103262000.0
2011-11-11	TSLA	Stock	2.1267	2.3	2.038	2.2427	58024500.0
2011-11-11	TLT	Stock	115.83	116.1652	115.5	115.65	2483889.0
2011-11-11	ES	Stock	35.09	35.37	34.78	35.08	2163600.0
2011-11-11	CL	Stock	44.265	44.7	44.265	44.585	2960800.0
2011-11-11	A	Stock	26.8956	27.3247	26.6166	26.7954	5475267.0
2011-11-11	AABA-DELISTED	Stock	15.96	16.31	15.91	16.26	14439158.0
2011-11-11	AACC-DELISTED	Stock	3.17	3.3	2.93	3.03	11901.0
2011-11-11	AACG	Stock	9.87	9.87	9.75	9.75	1400.0
2011-11-11	AAIC-DELISTED	Stock	22.1	22.3	21.94	22.25	22309.0
2011-11-11	AAME	Stock	1.8	1.8	1.74	1.8	4600.0
2011-11-11	AAON	Stock	6.4978	6.6163	6.0652	6.5126	376313.0
2011-11-11	AAP	Stock	70.18	70.81	69.67	70.28	1184100.0
2011-11-11	AAT	Stock	20.02	20.67	19.92	20.28	257100.0
2011-11-11	AATI-DELISTED	Stock	3.97	4.18	3.97	4.17	829499.0
2011-11-11	AAU-DELISTED	Stock	2.82	2.835	2.75	2.7551	103554.0
2011-11-11	AAUAF-DELISTED	Stock	2.83	2.84	2.75	2.75	103518.0
2011-11-11	AAV-DELISTED	Stock	5.26	5.4	5.18	5.23	174059.0
2011-11-11	AAWW-DELISTED	Stock	37.06	38.67	36.656	38.22	194251.0
2011-11-11	AAXJ	Stock	52.78	53.63	52.78	53.38	294615.0
2011-11-11	AAXN-DELISTED	Stock	5.51	5.56	5.41	5.55	400353.0
2011-11-11	AB	Stock	13.28	13.39	13.01	13.25	346600.0
2011-11-11	ABAC-DELISTED	Stock	2.36	2.39	2.15	2.29	17750.0
2011-11-11	ABAX-DELISTED	Stock	26.95	27.16	26.6	27.03	122623.0
2011-11-11	ABB-DELISTED	Stock	18.57	18.82	18.55	18.66	1627966.0
2011-11-11	ABBNY-DELISTED	Stock	18.57	18.82	18.55	18.64	1630516.0
2011-11-11	ABC-DELISTED	Stock	39.2	40.07	39.18	39.68	1867244.0
2011-11-11	ABCB	Stock	10.22	10.4	10.13	10.34	50000.0
2011-11-11	ABCD-DELISTED	Stock	3.31	3.38	3.26	3.34	39262.0
2011-11-11	ABCO-DELISTED	Stock	34.66	35.72	34.15	35.62	209328.0
2011-11-11	ABCW-DELISTED	Stock	0.47	0.51	0.47	0.48	155430.0
2011-11-11	ABD-DELISTED	Stock	7.21	7.45	7.17	7.3	222690.0
2011-11-11	ABE-DELISTED	Stock	17.83	18.25	17.83	18.2	9753.0
2011-11-11	ABEO	Stock	1625.0	1675.0	1587.5	1650.0	13.0
2011-11-11	ABFS-DELISTED	Stock	20.41	21.4	20.29	21.37	398208.0
2011-11-11	ABG	Stock	18.73	19.0	18.61	18.94	305400.0
2011-11-11	ABH-DELISTED	Stock	16.09	16.36	15.89	15.96	183628.0
2011-11-11	ABM	Stock	20.24	20.64	20.18	20.52	203700.0
2011-11-11	ABMD-DELISTED	Stock	18.86	19.48	18.62	19.38	380666.0
2011-11-11	ABR	Stock	3.69	3.7	3.63	3.67	37700.0
2011-11-11	ABT	Stock	26.0771	26.1971	26.01	26.1635	10284702.0
2011-11-11	ABTL-DELISTED	Stock	4.5	4.5	4.2995	4.3	15147.0
2011-11-11	ABUS	Stock	1.68	1.68	1.68	1.68	100.0
2011-11-11	ABV-DELISTED	Stock	33.65	34.09	33.5	33.87	1806094.0
2011-11-11	ABVA-DELISTED	Stock	5.24	5.36	5.12	5.2	25862.0
2011-11-11	ABVT-DELISTED	Stock	60.5	61.09	60.35	60.75	205232.0
2011-11-11	ABX-DELISTED	Stock	51.81	53.21	51.62	53.16	5213556.0

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

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