PREVIEW / stock_daily / 2011-08-15

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-15.parquet
  size:    196 KB
  rows:    6,122
  symbols: 3,559

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-15	AAPL	Stock	13.5582	13.7489	13.5032	13.6932	460544000.0
2011-08-15	MSFT	Stock	25.24	25.58	25.15	25.51	56529400.0
2011-08-15	NVDA	Stock	0.3253	0.335	0.3235	0.3342	864152000.0
2011-08-15	AMZN	Stock	10.103	10.264	9.916	10.1475	95718000.0
2011-08-15	TSLA	Stock	1.7747	1.7833	1.7287	1.7487	11079000.0
2011-08-15	TLT	Stock	104.94	105.48	104.47	104.5	10051650.0
2011-08-15	ES	Stock	32.66	33.32	32.59	33.31	1993100.0
2011-08-15	CL	Stock	42.945	43.13	42.545	43.13	5299200.0
2011-08-15	A	Stock	26.2661	26.8741	26.0658	26.824	9078332.0
2011-08-15	AABA-DELISTED	Stock	13.63	13.69	13.27	13.47	24955789.0
2011-08-15	AACC-DELISTED	Stock	4.41	4.42	3.94	4.22	25408.0
2011-08-15	AACG	Stock	9.64	9.78	9.17	9.3	5000.0
2011-08-15	AAIC-DELISTED	Stock	24.57	26.49	24.57	26.31	50663.0
2011-08-15	AAME	Stock	1.88	1.88	1.82	1.84	1500.0
2011-08-15	AAON	Stock	5.6533	5.8015	5.6533	5.7659	229163.0
2011-08-15	AAP	Stock	55.49	56.39	54.71	56.36	1284300.0
2011-08-15	AAT	Stock	18.43	19.73	18.33	19.67	193900.0
2011-08-15	AATI-DELISTED	Stock	5.95	5.96	5.85	5.91	2938392.0
2011-08-15	AAU-DELISTED	Stock	3.27	3.4191	3.24	3.41	225017.0
2011-08-15	AAUAF-DELISTED	Stock	3.28	3.4293	3.25	3.4	224645.0
2011-08-15	AAV-DELISTED	Stock	5.96	6.1	5.82	5.95	430159.0
2011-08-15	AAWW-DELISTED	Stock	43.49	44.72	43.2	44.62	152535.0
2011-08-15	AAXJ	Stock	56.05	56.72	56.05	56.62	201454.0
2011-08-15	AAXN-DELISTED	Stock	3.93	4.0	3.86	3.99	336897.0
2011-08-15	AB	Stock	14.53	14.81	14.41	14.51	299400.0
2011-08-15	ABAC-DELISTED	Stock	2.5	2.56	2.376	2.56	19210.0
2011-08-15	ABAX-DELISTED	Stock	23.44	24.35	23.07	24.31	152118.0
2011-08-15	ABB-DELISTED	Stock	21.85	22.107	21.84	22.06	2235441.0
2011-08-15	ABBC-DELISTED	Stock	8.26	8.49	8.26	8.48	25991.0
2011-08-15	ABBNY-DELISTED	Stock	21.85	22.107	21.84	22.04	2239891.0
2011-08-15	ABC-DELISTED	Stock	38.81	38.9	38.19	38.89	2821266.0
2011-08-15	ABCB	Stock	8.99	9.29	8.99	9.17	93300.0
2011-08-15	ABCD-DELISTED	Stock	3.04	3.04	2.7	2.94	35791.0
2011-08-15	ABCO-DELISTED	Stock	28.24	28.89	27.9	28.79	88377.0
2011-08-15	ABCW-DELISTED	Stock	0.61	0.6133	0.61	0.61	6060.0
2011-08-15	ABD-DELISTED	Stock	6.82	7.01	6.67	6.88	196510.0
2011-08-15	ABE-DELISTED	Stock	18.18	18.46	18.0616	18.096	11974.0
2011-08-15	ABEO	Stock	2575.0	2750.0	2362.5	2687.5	43.0
2011-08-15	ABFS-DELISTED	Stock	20.69	21.57	20.44	21.55	587068.0
2011-08-15	ABG	Stock	18.09	18.27	17.3	18.16	329900.0
2011-08-15	ABH-DELISTED	Stock	16.6	17.05	16.42	16.98	625011.0
2011-08-15	ABM	Stock	19.37	19.61	19.25	19.61	151500.0
2011-08-15	ABMD-DELISTED	Stock	12.26	12.72	12.11	12.35	308867.0
2011-08-15	ABR	Stock	3.94	4.0	3.89	3.97	45100.0
2011-08-15	ABT	Stock	23.9948	24.0524	23.6733	23.9468	14392664.0
2011-08-15	ABTL-DELISTED	Stock	4.4519	4.4524	4.2247	4.25	16170.0
2011-08-15	ABUS	Stock	2.3	2.31	2.12	2.12	2100.0
2011-08-15	ABV-DELISTED	Stock	31.85	32.3	31.73	32.3	3273069.0
2011-08-15	ABVA-DELISTED	Stock	4.6	4.65	4.6	4.65	10235.0
2011-08-15	ABVT-DELISTED	Stock	59.43	61.03	59.09	60.96	105033.0

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

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