PREVIEW / stock_daily / 2011-08-08

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-08.parquet
  size:    198 KB
  rows:    6,214
  symbols: 3,613

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-08-08	AAPL	Stock	12.9175	13.1346	12.6079	12.6146	1143833600.0
2011-08-08	MSFT	Stock	25.02	25.6	24.39	24.48	134257200.0
2011-08-08	NVDA	Stock	0.308	0.319	0.2962	0.2982	1084180000.0
2011-08-08	AMZN	Stock	9.82	10.0195	9.5025	9.685	208550000.0
2011-08-08	TSLA	Stock	1.54	1.6293	1.54	1.576	39127500.0
2011-08-08	TLT	Stock	103.18	105.79	102.95	105.55	38266001.0
2011-08-08	ES	Stock	31.52	32.37	30.39	30.46	3982100.0
2011-08-08	CL	Stock	41.39	42.41	41.255	41.4	12356800.0
2011-08-08	A	Stock	25.3577	25.701	23.1474	23.2904	13254019.0
2011-08-08	AABA-DELISTED	Stock	11.41	11.8	11.09	11.09	58546819.0
2011-08-08	AACC-DELISTED	Stock	4.36	4.43	4.33	4.33	13144.0
2011-08-08	AACG	Stock	8.34	8.62	8.0	8.5	21900.0
2011-08-08	AAIC-DELISTED	Stock	23.0	25.0	22.56	22.8	220708.0
2011-08-08	AAME	Stock	1.81	2.04	1.63	1.95	17100.0
2011-08-08	AAON	Stock	5.6385	5.8281	5.3807	5.6711	784688.0
2011-08-08	AAP	Stock	51.93	52.07	49.82	50.04	2566500.0
2011-08-08	AAT	Stock	19.53	19.66	18.3	18.41	291700.0
2011-08-08	AATI-DELISTED	Stock	5.87	5.97	5.84	5.86	1206971.0
2011-08-08	AAU-DELISTED	Stock	2.93	3.023	2.69	2.78	784178.0
2011-08-08	AAUAF-DELISTED	Stock	2.93	3.023	2.69	2.76	786120.0
2011-08-08	AAV-DELISTED	Stock	5.7	5.9	5.27	5.32	1176025.0
2011-08-08	AAWW-DELISTED	Stock	44.07	46.5	42.27	42.45	540819.0
2011-08-08	AAXJ	Stock	55.27	55.69	52.74	53.15	445451.0
2011-08-08	AAXN-DELISTED	Stock	3.85	4.02	3.61	3.62	918644.0
2011-08-08	AB	Stock	15.1	15.55	13.25	14.16	1402600.0
2011-08-08	ABAC-DELISTED	Stock	2.34	2.34	2.03	2.17	18357.0
2011-08-08	ABAX-DELISTED	Stock	21.12	21.9493	19.86	19.99	305249.0
2011-08-08	ABB-DELISTED	Stock	20.6	20.89	19.59	19.6	7019957.0
2011-08-08	ABBC-DELISTED	Stock	8.67	8.87	7.9	7.9	80724.0
2011-08-08	ABBNY-DELISTED	Stock	20.6	20.89	19.59	19.59	7143072.0
2011-08-08	ABC-DELISTED	Stock	36.32	36.53	34.61	34.63	4268372.0
2011-08-08	ABCB	Stock	9.58	9.98	9.07	9.07	132700.0
2011-08-08	ABCD-DELISTED	Stock	2.84	2.9399	2.68	2.71	37378.0
2011-08-08	ABCO-DELISTED	Stock	28.35	29.5	27.99	27.99	676000.0
2011-08-08	ABCW-DELISTED	Stock	0.62	0.6201	0.6109	0.62	109540.0
2011-08-08	ABD-DELISTED	Stock	7.335	7.555	6.7348	6.7348	924460.0
2011-08-08	ABE-DELISTED	Stock	17.12	17.58	16.41	16.6601	19531.0
2011-08-08	ABEO	Stock	2562.5	2562.5	1887.5	2437.5	59.0
2011-08-08	ABFS-DELISTED	Stock	21.28	21.56	19.72	19.73	754559.0
2011-08-08	ABG	Stock	18.83	19.4	17.5	18.03	654400.0
2011-08-08	ABH-DELISTED	Stock	16.0	16.18	15.58	15.75	1700203.0
2011-08-08	ABM	Stock	19.79	20.72	17.29	17.29	1769300.0
2011-08-08	ABMD-DELISTED	Stock	11.26	11.41	10.62	10.63	570347.0
2011-08-08	ABR	Stock	3.97	3.99	3.73	3.76	248600.0
2011-08-08	ABT	Stock	23.6541	24.0524	22.8193	23.0592	38377866.0
2011-08-08	ABTL-DELISTED	Stock	4.3949	4.6446	4.2501	4.2551	26244.0
2011-08-08	ABUS	Stock	1.97	1.98	1.92	1.92	5500.0
2011-08-08	ABV-DELISTED	Stock	28.84	29.07	27.8507	27.99	5643277.0
2011-08-08	ABVA-DELISTED	Stock	4.9	4.9	4.61	4.61	6065.0
2011-08-08	ABVT-DELISTED	Stock	56.2	58.15	54.87	56.02	579902.0

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

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