PREVIEW / stock_daily / 2011-09-27

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-27.parquet
  size:    196 KB
  rows:    6,152
  symbols: 3,569

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-27	AAPL	Stock	14.5975	14.6161	14.2164	14.2593	632497600.0
2011-09-27	MSFT	Stock	25.66	25.92	25.45	25.67	55620700.0
2011-09-27	NVDA	Stock	0.3542	0.3572	0.3433	0.346	781388000.0
2011-09-27	AMZN	Stock	11.711	11.7375	11.12	11.2105	156750000.0
2011-09-27	TSLA	Stock	1.7333	1.7993	1.7047	1.746	10117500.0
2011-09-27	TLT	Stock	116.75	117.3	116.26	117.07	13589514.0
2011-09-27	ES	Stock	34.61	34.95	34.4	34.5	1556800.0
2011-09-27	CL	Stock	46.03	46.43	45.38	45.535	5937400.0
2011-09-27	A	Stock	23.8984	24.721	23.7124	24.0057	6660491.0
2011-09-27	AABA-DELISTED	Stock	14.93	15.0	14.44	14.54	24975910.0
2011-09-27	AACC-DELISTED	Stock	3.75	3.77	3.7	3.75	8225.0
2011-09-27	AACG	Stock	9.0	9.0	8.8	9.0	7500.0
2011-09-27	AAIC-DELISTED	Stock	26.16	26.57	25.78	26.11	152305.0
2011-09-27	AAME	Stock	1.9	1.9	1.72	1.89	6300.0
2011-09-27	AAON	Stock	5.037	5.2948	4.8296	5.0637	209925.0
2011-09-27	AAP	Stock	61.51	61.65	60.09	60.29	743600.0
2011-09-27	AAT	Stock	18.27	18.87	18.14	18.46	329800.0
2011-09-27	AATI-DELISTED	Stock	4.39	4.5	4.32	4.47	595011.0
2011-09-27	AAU-DELISTED	Stock	2.92	3.1434	2.92	2.97	306171.0
2011-09-27	AAUAF-DELISTED	Stock	2.94	3.1699	2.94	2.97	306806.0
2011-09-27	AAV-DELISTED	Stock	4.63	4.722	4.45	4.49	470251.0
2011-09-27	AAWW-DELISTED	Stock	37.26	39.29	36.95	38.12	470332.0
2011-09-27	AAXJ	Stock	49.72	50.42	49.34	49.56	434095.0
2011-09-27	AAXN-DELISTED	Stock	4.53	4.56	4.45	4.51	540625.0
2011-09-27	AB	Stock	14.53	15.06	14.43	14.81	264800.0
2011-09-27	ABAC-DELISTED	Stock	1.62	1.7	1.61	1.62	18921.0
2011-09-27	ABAX-DELISTED	Stock	25.41	25.69	24.22	25.34	142512.0
2011-09-27	ABB-DELISTED	Stock	17.79	18.1	17.53	17.62	3634232.0
2011-09-27	ABBC-DELISTED	Stock	7.55	7.87	7.52	7.67	51353.0
2011-09-27	ABBNY-DELISTED	Stock	17.79	18.1	17.53	17.62	4444396.0
2011-09-27	ABC-DELISTED	Stock	39.89	40.03	39.01	39.17	2741128.0
2011-09-27	ABCB	Stock	8.93	9.03	8.76	8.87	63000.0
2011-09-27	ABCD-DELISTED	Stock	3.13	3.16	3.05	3.1	42204.0
2011-09-27	ABCO-DELISTED	Stock	32.1	34.1	31.77	33.31	260842.0
2011-09-27	ABCW-DELISTED	Stock	0.4995	0.5095	0.4895	0.4905	25850.0
2011-09-27	ABD-DELISTED	Stock	5.28	5.34	5.12	5.21	440590.0
2011-09-27	ABE-DELISTED	Stock	17.37	17.37	16.95	17.31	15172.0
2011-09-27	ABEO	Stock	2437.5	2550.0	2375.0	2550.0	37.0
2011-09-27	ABFS-DELISTED	Stock	17.95	18.52	17.84	18.05	437614.0
2011-09-27	ABG	Stock	17.5	18.5	17.33	17.82	512100.0
2011-09-27	ABH-DELISTED	Stock	15.74	16.37	15.74	16.07	304998.0
2011-09-27	ABM	Stock	19.58	20.37	19.38	19.91	413600.0
2011-09-27	ABMD-DELISTED	Stock	11.15	11.77	10.98	11.61	177105.0
2011-09-27	ABR	Stock	3.86	3.87	3.75	3.77	25400.0
2011-09-27	ABT	Stock	24.2731	24.7913	24.1963	24.5658	16555857.0
2011-09-27	ABTL-DELISTED	Stock	4.25	4.4245	4.059	4.35	8774.0
2011-09-27	ABUS	Stock	2.1	2.1	1.86	1.86	1200.0
2011-09-27	ABV-DELISTED	Stock	31.66	31.74	31.12	31.26	3368738.0
2011-09-27	ABVA-DELISTED	Stock	4.8	4.94	4.8	4.82	9700.0
2011-09-27	ABVT-DELISTED	Stock	55.74	56.28	54.33	54.75	161375.0

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

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