PREVIEW / stock_daily / 2011-10-20

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-20.parquet
  size:    192 KB
  rows:    6,040
  symbols: 3,491

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-20	AAPL	Stock	14.2857	14.2982	14.0789	14.1182	549270400.0
2011-10-20	MSFT	Stock	27.26	27.34	26.4	27.04	76300200.0
2011-10-20	NVDA	Stock	0.369	0.3705	0.346	0.3602	990308000.0
2011-10-20	AMZN	Stock	11.6065	11.737	11.49	11.6805	90498000.0
2011-10-20	TSLA	Stock	1.8293	1.8313	1.8	1.8227	14995500.0
2011-10-20	TLT	Stock	114.46	115.67	114.07	114.34	7832019.0
2011-10-20	ES	Stock	33.48	33.61	33.05	33.37	1536300.0
2011-10-20	CL	Stock	46.09	46.495	45.71	45.81	3796400.0
2011-10-20	A	Stock	23.6981	24.2132	23.2332	24.1273	6738500.0
2011-10-20	AABA-DELISTED	Stock	16.16	16.41	15.97	16.17	38660488.0
2011-10-20	AACC-DELISTED	Stock	3.09	3.1	2.97	3.05	92338.0
2011-10-20	AAIC-DELISTED	Stock	24.31	24.63	23.57	24.18	56790.0
2011-10-20	AAME	Stock	1.62	1.84	1.43	1.84	13100.0
2011-10-20	AAON	Stock	5.6267	5.6356	5.4519	5.5822	241313.0
2011-10-20	AAP	Stock	61.76	62.67	61.61	62.38	1043200.0
2011-10-20	AAT	Stock	18.53	19.05	18.11	18.64	99800.0
2011-10-20	AATI-DELISTED	Stock	4.41	4.45	4.28	4.42	107354.0
2011-10-20	AAU-DELISTED	Stock	2.34	2.36	2.185	2.35	244524.0
2011-10-20	AAUAF-DELISTED	Stock	2.34	2.36	2.185	2.35	245124.0
2011-10-20	AAV-DELISTED	Stock	4.72	4.8	4.6	4.72	395178.0
2011-10-20	AAWW-DELISTED	Stock	34.01	34.27	32.01	34.13	356932.0
2011-10-20	AAXJ	Stock	50.38	50.4	49.32	50.02	1180231.0
2011-10-20	AAXN-DELISTED	Stock	4.61	4.696	4.52	4.66	166838.0
2011-10-20	AB	Stock	14.46	14.5	13.98	14.24	351400.0
2011-10-20	ABAC-DELISTED	Stock	1.38	1.45	1.36	1.36	28675.0
2011-10-20	ABAX-DELISTED	Stock	23.68	24.07	22.82	23.62	66458.0
2011-10-20	ABB-DELISTED	Stock	18.46	18.58	18.13	18.48	3223251.0
2011-10-20	ABBNY-DELISTED	Stock	18.46	18.58	18.13	18.49	3253271.0
2011-10-20	ABC-DELISTED	Stock	38.39	38.81	38.03	38.72	2542161.0
2011-10-20	ABCB	Stock	9.47	9.49	9.26	9.47	70300.0
2011-10-20	ABCD-DELISTED	Stock	2.89	2.97	2.87	2.96	60474.0
2011-10-20	ABCO-DELISTED	Stock	32.01	32.16	31.21	31.43	89931.0
2011-10-20	ABCW-DELISTED	Stock	0.485	0.5199	0.481	0.49	11380.0
2011-10-20	ABD-DELISTED	Stock	5.55	5.55	5.25	5.44	180860.0
2011-10-20	ABE-DELISTED	Stock	17.54	17.69	17.1	17.45	10263.0
2011-10-20	ABEO	Stock	2175.0	2175.0	2062.5	2150.0	12.0
2011-10-20	ABFS-DELISTED	Stock	17.45	18.32	17.09	18.29	366267.0
2011-10-20	ABG	Stock	19.36	19.6	18.78	19.4	293900.0
2011-10-20	ABH-DELISTED	Stock	15.18	15.39	14.98	15.27	212018.0
2011-10-20	ABM	Stock	19.89	20.03	18.9	19.37	175800.0
2011-10-20	ABMD-DELISTED	Stock	11.82	11.85	11.38	11.68	112827.0
2011-10-20	ABR	Stock	3.33	3.38	3.31	3.35	43800.0
2011-10-20	ABT	Stock	25.6693	26.0915	25.5733	25.9332	36511046.0
2011-10-20	ABTL-DELISTED	Stock	4.2034	4.35	4.0958	4.35	9109.0
2011-10-20	ABUS	Stock	1.89	1.92	1.65	1.74	9900.0
2011-10-20	ABV-DELISTED	Stock	33.65	33.835	33.02	33.31	2713520.0
2011-10-20	ABVA-DELISTED	Stock	5.06	5.06	5.06	5.06	200.0
2011-10-20	ABVT-DELISTED	Stock	57.11	57.11	54.74	56.01	108261.0
2011-10-20	ABX-DELISTED	Stock	44.59	44.63	43.12	44.33	10983123.0
2011-10-20	ACAD	Stock	1.11	1.15	1.1	1.13	63800.0

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

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