PREVIEW / stock_daily / 2011-07-19

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-19.parquet
  size:    198 KB
  rows:    6,114
  symbols: 3,545

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-19	AAPL	Stock	13.5	13.5232	13.3329	13.4589	819145600.0
2011-07-19	MSFT	Stock	26.81	27.64	26.78	27.54	86730600.0
2011-07-19	NVDA	Stock	0.346	0.3562	0.346	0.3555	602224000.0
2011-07-19	AMZN	Stock	10.6885	10.92	10.6885	10.903	88744000.0
2011-07-19	TSLA	Stock	1.8387	1.874	1.836	1.8593	15391500.0
2011-07-19	TLT	Stock	95.32	97.27	95.17	97.22	15249365.0
2011-07-19	ES	Stock	34.35	34.62	34.08	34.55	1487900.0
2011-07-19	CL	Stock	44.115	44.4	43.94	44.26	3779800.0
2011-07-19	A	Stock	32.7325	33.6767	32.6967	33.5765	4987365.0
2011-07-19	AABA-DELISTED	Stock	14.57	14.69	14.45	14.59	28949033.0
2011-07-19	AACC-DELISTED	Stock	4.53	4.53	4.41	4.47	12826.0
2011-07-19	AACG	Stock	11.2	11.2	10.93	11.2	47000.0
2011-07-19	AAIC-DELISTED	Stock	30.29	31.55	29.6	31.43	82671.0
2011-07-19	AAME	Stock	2.02	2.05	2.02	2.05	6100.0
2011-07-19	AAON	Stock	6.9333	7.0578	6.8	7.0341	140738.0
2011-07-19	AAP	Stock	55.0	55.99	55.0	55.49	1161100.0
2011-07-19	AAT	Stock	22.43	22.45	21.69	22.2	199200.0
2011-07-19	AATI-DELISTED	Stock	6.09	6.09	6.08	6.08	168554.0
2011-07-19	AAU-DELISTED	Stock	3.79	3.91	3.62	3.7	409336.0
2011-07-19	AAUAF-DELISTED	Stock	3.79	3.91	3.62	3.7	409536.0
2011-07-19	AAV-DELISTED	Stock	7.55	7.71	7.46	7.62	375116.0
2011-07-19	AAWW-DELISTED	Stock	54.72	55.38	54.33	55.07	165794.0
2011-07-19	AAXJ	Stock	61.27	61.7	61.25	61.6	232035.0
2011-07-19	AAXN-DELISTED	Stock	4.22	4.29	4.17	4.26	204768.0
2011-07-19	AB	Stock	18.01	18.12	17.91	18.03	297600.0
2011-07-19	ABAC-DELISTED	Stock	2.6999	2.81	2.6999	2.81	15103.0
2011-07-19	ABAX-DELISTED	Stock	28.59	29.0	28.0	28.97	86800.0
2011-07-19	ABB-DELISTED	Stock	24.83	25.07	24.8129	25.01	2978330.0
2011-07-19	ABBC-DELISTED	Stock	10.1	10.18	10.01	10.14	29873.0
2011-07-19	ABBNY-DELISTED	Stock	24.83	25.07	24.8129	25.0	2979359.0
2011-07-19	ABC-DELISTED	Stock	41.39	41.875	41.22	41.83	1506248.0
2011-07-19	ABCB	Stock	9.44	9.75	9.44	9.73	75200.0
2011-07-19	ABCD-DELISTED	Stock	3.37	3.38	3.3	3.36	26744.0
2011-07-19	ABCO-DELISTED	Stock	27.0	27.67	26.66	27.62	83345.0
2011-07-19	ABCW-DELISTED	Stock	0.68	0.7	0.68	0.68	27270.0
2011-07-19	ABD-DELISTED	Stock	7.59	7.75	7.48	7.65	156610.0
2011-07-19	ABE-DELISTED	Stock	18.95	19.06	18.95	19.06	3836.0
2011-07-19	ABEO	Stock	2437.5	2800.0	2437.5	2800.0	62.0
2011-07-19	ABFS-DELISTED	Stock	26.05	26.38	25.8264	26.25	314674.0
2011-07-19	ABG	Stock	19.7	20.0	19.6	19.95	481400.0
2011-07-19	ABH-DELISTED	Stock	19.36	19.64	19.26	19.54	329612.0
2011-07-19	ABM	Stock	23.33	23.72	23.32	23.71	200400.0
2011-07-19	ABMD-DELISTED	Stock	16.52	17.13	16.31	17.09	93485.0
2011-07-19	ABR	Stock	4.48	4.56	4.45	4.48	38000.0
2011-07-19	ABT	Stock	25.2423	25.391	25.0887	25.3766	12320967.0
2011-07-19	ABTL-DELISTED	Stock	5.2054	5.5491	5.2054	5.5	13428.0
2011-07-19	ABUS	Stock	2.4	2.4	2.27	2.27	600.0
2011-07-19	ABV-DELISTED	Stock	31.65	32.22	31.52	32.13	2208875.0
2011-07-19	ABVA-DELISTED	Stock	4.75	4.75	4.5	4.55	4250.0
2011-07-19	ABVT-DELISTED	Stock	64.98	65.73	64.48	64.89	190562.0

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

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