PREVIEW / stock_daily / 2011-10-04

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-04.parquet
  size:    193 KB
  rows:    6,104
  symbols: 3,534

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-04	AAPL	Stock	13.3775	13.6357	12.6514	13.3036	1233677200.0
2011-10-04	MSFT	Stock	24.3	25.39	24.26	25.34	83485400.0
2011-10-04	NVDA	Stock	0.288	0.3225	0.2868	0.3225	1361548000.0
2011-10-04	AMZN	Stock	10.481	10.75	10.0215	10.625	174232000.0
2011-10-04	TSLA	Stock	1.5527	1.6213	1.5287	1.5773	18004500.0
2011-10-04	TLT	Stock	124.37	125.03	122.18	122.24	17301564.0
2011-10-04	ES	Stock	31.69	31.88	30.8	31.27	5400000.0
2011-10-04	CL	Stock	43.72	44.285	43.195	44.21	6600000.0
2011-10-04	A	Stock	20.6509	22.196	20.5079	22.1817	7549200.0
2011-10-04	AABA-DELISTED	Stock	14.02	14.48	13.87	14.46	43666626.0
2011-10-04	AACC-DELISTED	Stock	3.02	3.2	3.02	3.07	32294.0
2011-10-04	AACG	Stock	8.56	8.81	8.0	8.5	12800.0
2011-10-04	AAIC-DELISTED	Stock	21.76	26.12	21.05	24.66	108847.0
2011-10-04	AAME	Stock	1.87	1.87	1.26	1.86	10700.0
2011-10-04	AAON	Stock	4.4415	4.9926	4.3378	4.9719	270675.0
2011-10-04	AAP	Stock	55.89	58.59	55.61	58.56	1102900.0
2011-10-04	AAT	Stock	16.76	18.25	16.5	18.12	325600.0
2011-10-04	AATI-DELISTED	Stock	4.19	4.335	4.16	4.31	435035.0
2011-10-04	AAU-DELISTED	Stock	2.31	2.31	2.11	2.31	581715.0
2011-10-04	AAUAF-DELISTED	Stock	2.31	2.31	2.11	2.31	586875.0
2011-10-04	AAV-DELISTED	Stock	3.67	3.99	3.56	3.99	731023.0
2011-10-04	AAWW-DELISTED	Stock	30.5	31.71	29.5	31.69	575616.0
2011-10-04	AAXJ	Stock	44.84	46.27	44.27	46.2	517188.0
2011-10-04	AAXN-DELISTED	Stock	4.17	4.28	4.04	4.27	723849.0
2011-10-04	AB	Stock	12.63	13.62	12.56	13.58	482900.0
2011-10-04	ABAC-DELISTED	Stock	1.4	1.52	1.4	1.5	24494.0
2011-10-04	ABAX-DELISTED	Stock	21.92	23.08	21.67	22.89	239043.0
2011-10-04	ABB-DELISTED	Stock	16.08	16.72	15.89	16.72	5229643.0
2011-10-04	ABBNY-DELISTED	Stock	16.08	16.72	15.89	16.71	5298463.0
2011-10-04	ABC-DELISTED	Stock	35.25	36.26	34.78	35.92	5084624.0
2011-10-04	ABCB	Stock	8.51	9.49	8.51	9.38	146600.0
2011-10-04	ABCD-DELISTED	Stock	2.86	2.97	2.83	2.94	86694.0
2011-10-04	ABCO-DELISTED	Stock	29.26	30.94	28.72	30.94	277488.0
2011-10-04	ABCW-DELISTED	Stock	0.49	0.52	0.48	0.49	11760.0
2011-10-04	ABD-DELISTED	Stock	4.3363	4.9699	4.2868	4.96	538760.0
2011-10-04	ABE-DELISTED	Stock	16.47	16.5	16.12	16.48	11585.0
2011-10-04	ABEO	Stock	2200.0	2362.5	2200.0	2350.0	7.0
2011-10-04	ABFS-DELISTED	Stock	14.95	16.26	14.22	16.15	1019803.0
2011-10-04	ABG	Stock	15.32	17.64	15.01	17.56	637900.0
2011-10-04	ABH-DELISTED	Stock	13.91	14.24	13.7	14.2	487221.0
2011-10-04	ABM	Stock	17.54	19.0	17.51	18.91	485700.0
2011-10-04	ABMD-DELISTED	Stock	9.98	11.19	9.98	11.18	209500.0
2011-10-04	ABR	Stock	3.51	3.52	3.31	3.42	146700.0
2011-10-04	ABT	Stock	23.8461	24.2779	23.491	24.2299	22509379.0
2011-10-04	ABTL-DELISTED	Stock	3.8503	4.0003	3.5502	3.7997	13679.0
2011-10-04	ABUS	Stock	1.76	1.8	1.55	1.67	2700.0
2011-10-04	ABV-DELISTED	Stock	29.55	30.62	29.54	30.47	5499554.0
2011-10-04	ABVA-DELISTED	Stock	4.81	4.95	4.66	4.95	4400.0
2011-10-04	ABVT-DELISTED	Stock	51.32	55.48	51.31	55.18	233507.0
2011-10-04	ABX-DELISTED	Stock	45.13	45.52	42.89	44.64	11883015.0

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

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