PREVIEW / stock_daily / 2011-09-09

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-09.parquet
  size:    193 KB
  rows:    6,046
  symbols: 3,506

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-09-09	AAPL	Stock	13.7118	13.7857	13.3936	13.4814	564813200.0
2011-09-09	MSFT	Stock	26.0	26.18	25.5	25.74	64529200.0
2011-09-09	NVDA	Stock	0.3515	0.361	0.344	0.347	869828000.0
2011-09-09	AMZN	Stock	10.7525	10.848	10.4875	10.5695	91486000.0
2011-09-09	TSLA	Stock	1.558	1.5713	1.5033	1.5313	10039500.0
2011-09-09	TLT	Stock	112.54	114.18	112.21	113.71	11492630.0
2011-09-09	ES	Stock	33.48	33.55	32.89	33.1	1562000.0
2011-09-09	CL	Stock	44.99	45.07	44.315	44.48	5230600.0
2011-09-09	A	Stock	24.0701	24.6996	23.6338	23.8627	6258566.0
2011-09-09	AABA-DELISTED	Stock	14.36	14.57	14.07	14.48	59901293.0
2011-09-09	AACC-DELISTED	Stock	4.0	4.06	3.91	3.99	11000.0
2011-09-09	AACG	Stock	9.61	9.61	9.24	9.25	7100.0
2011-09-09	AAIC-DELISTED	Stock	24.69	24.9094	24.23	24.33	43431.0
2011-09-09	AAME	Stock	2.01	2.03	1.96	2.02	600.0
2011-09-09	AAON	Stock	4.883	5.0874	4.5985	4.6756	233550.0
2011-09-09	AAP	Stock	60.3	61.38	59.92	60.44	851500.0
2011-09-09	AAT	Stock	19.27	19.28	18.53	18.69	157300.0
2011-09-09	AATI-DELISTED	Stock	5.93	5.97	3.9	4.62	10235623.0
2011-09-09	AAU-DELISTED	Stock	3.42	3.5	3.34	3.42	264132.0
2011-09-09	AAUAF-DELISTED	Stock	3.42	3.5	3.34	3.42	264832.0
2011-09-09	AAV-DELISTED	Stock	5.25	5.25	5.07	5.11	381420.0
2011-09-09	AAWW-DELISTED	Stock	44.62	44.94	42.91	43.89	309529.0
2011-09-09	AAXJ	Stock	54.31	54.35	53.17	53.41	368551.0
2011-09-09	AAXN-DELISTED	Stock	4.33	4.38	4.18	4.24	367367.0
2011-09-09	AB	Stock	16.75	16.84	16.3	16.43	284100.0
2011-09-09	ABAC-DELISTED	Stock	2.14	2.16	2.05	2.1	22698.0
2011-09-09	ABAX-DELISTED	Stock	24.64	24.8365	23.99	24.38	139645.0
2011-09-09	ABB-DELISTED	Stock	18.26	18.47	18.0	18.1	4801805.0
2011-09-09	ABBC-DELISTED	Stock	8.12	8.3	7.77	7.86	53324.0
2011-09-09	ABBNY-DELISTED	Stock	18.27	18.47	18.0	18.09	4804105.0
2011-09-09	ABC-DELISTED	Stock	39.36	39.36	38.25	38.42	2756955.0
2011-09-09	ABCB	Stock	8.57	8.64	8.4	8.49	67300.0
2011-09-09	ABCD-DELISTED	Stock	2.95	3.01	2.84	2.93	42363.0
2011-09-09	ABCO-DELISTED	Stock	29.8	29.89	28.54	29.22	166556.0
2011-09-09	ABCW-DELISTED	Stock	0.62	0.6299	0.55	0.55	25010.0
2011-09-09	ABD-DELISTED	Stock	5.85	5.98	5.6418	5.73	329800.0
2011-09-09	ABE-DELISTED	Stock	18.21	18.21	17.82	17.95	12140.0
2011-09-09	ABEO	Stock	2500.0	2625.0	2475.0	2625.0	3.0
2011-09-09	ABFS-DELISTED	Stock	18.8	19.26	18.43	18.95	447791.0
2011-09-09	ABG	Stock	18.25	18.76	17.73	18.02	681300.0
2011-09-09	ABH-DELISTED	Stock	15.74	16.0	15.555	15.94	151844.0
2011-09-09	ABM	Stock	17.75	19.48	17.73	18.92	903600.0
2011-09-09	ABMD-DELISTED	Stock	11.09	11.14	10.42	10.78	390493.0
2011-09-09	ABR	Stock	4.17	4.23	4.04	4.19	44100.0
2011-09-09	ABT	Stock	24.5226	24.5322	24.1004	24.1963	18438308.0
2011-09-09	ABTL-DELISTED	Stock	4.55	4.694	4.325	4.4	11365.0
2011-09-09	ABUS	Stock	1.91	2.01	1.86	2.01	4400.0
2011-09-09	ABV-DELISTED	Stock	32.79	32.9	32.191	32.39	3240358.0
2011-09-09	ABVA-DELISTED	Stock	4.75	4.75	4.68	4.7	9470.0
2011-09-09	ABVT-DELISTED	Stock	55.21	56.32	54.36	54.99	147385.0

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

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