PREVIEW / stock_daily / 2011-05-16

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-16.parquet
  size:    199 KB
  rows:    6,131
  symbols: 3,577

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-05-16	AAPL	Stock	12.1143	12.1864	11.8786	11.9036	449775200.0
2011-05-16	MSFT	Stock	24.96	25.07	24.5	24.57	91350900.0
2011-05-16	NVDA	Stock	0.4552	0.4562	0.4422	0.4425	728188000.0
2011-05-16	AMZN	Stock	10.027	10.045	9.5685	9.6255	187728000.0
2011-05-16	TSLA	Stock	1.866	1.866	1.77	1.7733	11335500.0
2011-05-16	TLT	Stock	95.03	95.79	94.76	95.61	6053863.0
2011-05-16	ES	Stock	35.88	36.16	35.76	35.9	982100.0
2011-05-16	CL	Stock	43.29	43.41	42.955	42.975	4838400.0
2011-05-16	A	Stock	37.3319	37.9113	37.2461	37.4249	7251706.0
2011-05-16	AABA-DELISTED	Stock	16.68	16.69	15.63	15.82	60581526.0
2011-05-16	AACC-DELISTED	Stock	4.4	4.43	4.16	4.16	20981.0
2011-05-16	AACG	Stock	9.48	10.13	9.28	10.01	84000.0
2011-05-16	AAIC-DELISTED	Stock	27.94	28.199	27.27	27.31	123889.0
2011-05-16	AAME	Stock	2.06	2.07	2.0	2.06	2600.0
2011-05-16	AAON	Stock	6.3783	6.4652	6.3704	6.4237	266287.0
2011-05-16	AAP	Stock	71.8	71.92	70.18	70.18	1173400.0
2011-05-16	AAT	Stock	21.73	22.0	21.6	21.75	186800.0
2011-05-16	AATI-DELISTED	Stock	3.92	3.99	3.82	3.84	139276.0
2011-05-16	AAU-DELISTED	Stock	4.06	4.06	3.86	3.87	480886.0
2011-05-16	AAUAF-DELISTED	Stock	3.93	3.99	3.86	3.87	482186.0
2011-05-16	AAV-DELISTED	Stock	7.86	8.01	7.7	7.88	627336.0
2011-05-16	AAWW-DELISTED	Stock	64.15	64.77	62.39	62.43	225926.0
2011-05-16	AAXJ	Stock	62.31	62.96	62.2	62.36	519446.0
2011-05-16	AAXN-DELISTED	Stock	4.5	4.59	4.45	4.5	257428.0
2011-05-16	AB	Stock	21.65	21.78	21.5	21.71	434800.0
2011-05-16	ABAC-DELISTED	Stock	3.2	3.2	2.93	2.97	70883.0
2011-05-16	ABAX-DELISTED	Stock	27.73	28.05	27.58	27.61	118060.0
2011-05-16	ABB-DELISTED	Stock	25.85	26.35	25.82	26.19	4212687.0
2011-05-16	ABBC-DELISTED	Stock	11.36	11.41	11.22	11.24	48238.0
2011-05-16	ABBNY-DELISTED	Stock	25.85	26.35	25.82	26.21	4313809.0
2011-05-16	ABC-DELISTED	Stock	41.91	42.45	41.8	42.27	1890044.0
2011-05-16	ABCB	Stock	9.17	9.21	8.9	8.91	33300.0
2011-05-16	ABCD-DELISTED	Stock	3.1	3.12	2.95	3.0	41814.0
2011-05-16	ABCO-DELISTED	Stock	25.4	25.56	25.1	25.11	126934.0
2011-05-16	ABCW-DELISTED	Stock	0.88	0.89	0.85	0.85	9920.0
2011-05-16	ABD-DELISTED	Stock	9.16	9.44	9.13	9.2	257560.0
2011-05-16	ABE-DELISTED	Stock	18.7	18.7391	18.58	18.58	33566.0
2011-05-16	ABEO	Stock	2625.0	2812.5	2625.0	2812.5	14.0
2011-05-16	ABFS-DELISTED	Stock	23.42	24.24	23.37	24.19	409036.0
2011-05-16	ABG	Stock	16.71	16.71	16.26	16.41	517600.0
2011-05-16	ABH-DELISTED	Stock	25.68	26.45	25.64	26.2	763087.0
2011-05-16	ABM	Stock	23.86	23.98	23.5	23.69	267000.0
2011-05-16	ABMD-DELISTED	Stock	17.54	17.8	17.21	17.32	220807.0
2011-05-16	ABR	Stock	5.11	5.15	5.04	5.09	35000.0
2011-05-16	ABT	Stock	25.6597	26.0004	25.6213	25.9092	15205502.0
2011-05-16	ABTL-DELISTED	Stock	6.15	6.7	6.05	6.15	79068.0
2011-05-16	ABUS	Stock	2.82	2.87	2.82	2.84	800.0
2011-05-16	ABV-DELISTED	Stock	31.07	31.47	30.88	30.93	1555695.0
2011-05-16	ABVA-DELISTED	Stock	6.8	6.979	6.65	6.65	19459.0
2011-05-16	ABVT-DELISTED	Stock	63.84	64.55	63.55	63.78	122263.0

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

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