PREVIEW / stock_daily / 2011-07-20

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-20.parquet
  size:    197 KB
  rows:    6,115
  symbols: 3,550

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-07-20	AAPL	Stock	14.1471	14.1525	13.7857	13.8179	941340400.0
2011-07-20	MSFT	Stock	27.28	27.35	26.98	27.06	49795400.0
2011-07-20	NVDA	Stock	0.3568	0.3588	0.35	0.351	662956000.0
2011-07-20	AMZN	Stock	11.0025	11.01	10.7205	10.7775	67458000.0
2011-07-20	TSLA	Stock	1.8667	2.0293	1.8533	1.9127	45724500.0
2011-07-20	TLT	Stock	96.72	96.84	95.866	96.07	9673214.0
2011-07-20	ES	Stock	34.7	34.82	34.55	34.79	982400.0
2011-07-20	CL	Stock	44.235	44.455	44.13	44.28	2769600.0
2011-07-20	A	Stock	33.5837	33.6481	33.0687	33.5622	5347769.0
2011-07-20	AABA-DELISTED	Stock	14.15	14.15	13.45	13.48	61643327.0
2011-07-20	AACC-DELISTED	Stock	4.43	4.51	4.43	4.51	9578.0
2011-07-20	AACG	Stock	11.29	11.5	10.81	10.84	8000.0
2011-07-20	AAIC-DELISTED	Stock	31.5	31.51	31.261	31.47	24662.0
2011-07-20	AAME	Stock	2.04	2.05	1.95	2.05	1500.0
2011-07-20	AAON	Stock	7.0459	7.0637	6.8237	7.0311	77288.0
2011-07-20	AAP	Stock	55.53	55.56	54.6	55.04	1002300.0
2011-07-20	AAT	Stock	22.2	22.45	22.04	22.25	316200.0
2011-07-20	AATI-DELISTED	Stock	6.09	6.1	6.08	6.08	59610.0
2011-07-20	AAU-DELISTED	Stock	3.67	3.89	3.6	3.85	158141.0
2011-07-20	AAUAF-DELISTED	Stock	3.67	3.89	3.6	3.84	159141.0
2011-07-20	AAV-DELISTED	Stock	7.66	7.72	7.62	7.7	154720.0
2011-07-20	AAWW-DELISTED	Stock	55.15	55.23	54.35	54.58	129602.0
2011-07-20	AAXJ	Stock	61.89	62.13	61.78	61.9	167002.0
2011-07-20	AAXN-DELISTED	Stock	4.19	4.28	4.14	4.27	195846.0
2011-07-20	AB	Stock	18.03	18.28	18.0	18.04	213000.0
2011-07-20	ABAC-DELISTED	Stock	2.9	2.95	2.7571	2.95	26524.0
2011-07-20	ABAX-DELISTED	Stock	29.0	29.16	28.7	29.09	78723.0
2011-07-20	ABB-DELISTED	Stock	25.21	25.45	25.1	25.38	3505369.0
2011-07-20	ABBC-DELISTED	Stock	10.16	10.36	9.98	10.28	34336.0
2011-07-20	ABBNY-DELISTED	Stock	25.21	25.45	25.1	25.38	3811894.0
2011-07-20	ABC-DELISTED	Stock	41.92	41.93	41.5802	41.76	1183965.0
2011-07-20	ABCB	Stock	9.75	9.87	9.59	9.85	48900.0
2011-07-20	ABCD-DELISTED	Stock	3.32	3.36	3.32	3.35	3961.0
2011-07-20	ABCO-DELISTED	Stock	27.54	27.54	27.0	27.35	50739.0
2011-07-20	ABCW-DELISTED	Stock	0.73	0.73	0.68	0.7	8540.0
2011-07-20	ABD-DELISTED	Stock	7.65	7.68	7.367	7.47	118600.0
2011-07-20	ABE-DELISTED	Stock	19.23	19.23	19.1	19.17	15979.0
2011-07-20	ABEO	Stock	2750.0	3062.5	2750.0	3000.0	82.0
2011-07-20	ABFS-DELISTED	Stock	26.37	26.53	25.54	25.93	446689.0
2011-07-20	ABG	Stock	20.0	20.0	19.42	19.53	166600.0
2011-07-20	ABH-DELISTED	Stock	19.57	19.57	18.89	19.21	487072.0
2011-07-20	ABM	Stock	23.71	23.72	23.47	23.63	153300.0
2011-07-20	ABMD-DELISTED	Stock	17.09	17.09	16.04	16.68	93061.0
2011-07-20	ABR	Stock	4.49	4.57	4.33	4.52	44500.0
2011-07-20	ABT	Stock	25.5254	25.5446	24.9064	25.1415	18696957.0
2011-07-20	ABTL-DELISTED	Stock	5.65	5.95	5.4	5.4	14181.0
2011-07-20	ABUS	Stock	2.4	2.46	2.35	2.46	1600.0
2011-07-20	ABV-DELISTED	Stock	32.14	32.64	31.88	31.91	2019197.0
2011-07-20	ABVA-DELISTED	Stock	4.6	4.7334	4.568	4.66	3465.0
2011-07-20	ABVT-DELISTED	Stock	64.7	64.7	63.22	63.86	269764.0

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

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