PREVIEW / stock_daily / 2011-05-31

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-31.parquet
  size:    201 KB
  rows:    6,157
  symbols: 3,583

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-31	AAPL	Stock	12.1821	12.4225	12.1786	12.4225	417754400.0
2011-05-31	MSFT	Stock	24.96	25.06	24.7	25.01	60196300.0
2011-05-31	NVDA	Stock	0.497	0.5013	0.485	0.501	1200716000.0
2011-05-31	AMZN	Stock	9.797	9.922	9.7515	9.8345	68180000.0
2011-05-31	TSLA	Stock	1.9793	2.0187	1.97	2.0093	49357500.0
2011-05-31	TLT	Stock	96.18	96.76	96.0899	96.69	7004589.0
2011-05-31	ES	Stock	35.32	35.37	34.95	35.24	1557600.0
2011-05-31	CL	Stock	43.09	43.79	43.0	43.765	6172200.0
2011-05-31	A	Stock	35.5436	35.7868	35.2074	35.6724	3694075.0
2011-05-31	AABA-DELISTED	Stock	16.17	16.59	16.12	16.56	29855319.0
2011-05-31	AACC-DELISTED	Stock	4.07	4.22	4.06	4.1	66393.0
2011-05-31	AACG	Stock	11.11	11.48	11.11	11.36	32800.0
2011-05-31	AAIC-DELISTED	Stock	29.23	29.56	28.83	28.88	145749.0
2011-05-31	AAME	Stock	1.92	2.05	1.92	2.05	6900.0
2011-05-31	AAON	Stock	6.5916	6.6607	6.556	6.6568	345769.0
2011-05-31	AAP	Stock	62.29	62.39	61.39	62.1	1530900.0
2011-05-31	AAT	Stock	22.34	22.58	22.14	22.42	354100.0
2011-05-31	AATI-DELISTED	Stock	6.03	6.03	6.02	6.02	4369689.0
2011-05-31	AAU-DELISTED	Stock	3.88	3.88	3.67	3.69	277229.0
2011-05-31	AAUAF-DELISTED	Stock	3.88	3.88	3.67	3.69	281629.0
2011-05-31	AAV-DELISTED	Stock	8.4	8.44	8.32	8.4	447715.0
2011-05-31	AAWW-DELISTED	Stock	62.08	63.471	61.46	63.29	218767.0
2011-05-31	AAXJ	Stock	63.56	63.89	63.41	63.89	479747.0
2011-05-31	AAXN-DELISTED	Stock	4.59	4.64	4.4	4.51	820447.0
2011-05-31	AB	Stock	20.92	21.24	20.7	20.82	407900.0
2011-05-31	ABAC-DELISTED	Stock	2.84	2.8585	2.78	2.7901	9460.0
2011-05-31	ABAX-DELISTED	Stock	30.67	31.13	30.46	31.12	103946.0
2011-05-31	ABB-DELISTED	Stock	26.95	26.99	26.71	26.88	1866038.0
2011-05-31	ABBC-DELISTED	Stock	11.36	11.53	11.25	11.44	506259.0
2011-05-31	ABBNY-DELISTED	Stock	26.95	26.99	26.71	26.9	1918572.0
2011-05-31	ABC-DELISTED	Stock	41.36	41.5115	40.97	41.24	2144461.0
2011-05-31	ABCB	Stock	9.04	9.35	8.91	9.32	53900.0
2011-05-31	ABCD-DELISTED	Stock	3.28	3.37	3.26	3.33	43142.0
2011-05-31	ABCO-DELISTED	Stock	25.94	26.32	25.76	26.28	171731.0
2011-05-31	ABCW-DELISTED	Stock	0.8	0.81	0.75	0.78	55930.0
2011-05-31	ABD-DELISTED	Stock	8.22	8.3	8.11	8.3	387900.0
2011-05-31	ABE-DELISTED	Stock	18.95	19.05	18.88	18.92	30979.0
2011-05-31	ABEO	Stock	2750.0	2812.5	2587.5	2812.5	4.0
2011-05-31	ABFS-DELISTED	Stock	24.65	24.8	24.13	24.51	401716.0
2011-05-31	ABG	Stock	16.68	16.81	16.64	16.8	314300.0
2011-05-31	ABH-DELISTED	Stock	24.53	25.04	24.41	24.79	5259948.0
2011-05-31	ABM	Stock	22.73	22.87	22.68	22.78	722800.0
2011-05-31	ABMD-DELISTED	Stock	18.64	18.96	18.61	18.78	312859.0
2011-05-31	ABR	Stock	5.07	5.11	4.95	5.04	47500.0
2011-05-31	ABT	Stock	24.9112	25.0839	24.7817	25.0696	23704877.0
2011-05-31	ABTL-DELISTED	Stock	6.0466	6.1941	5.7517	5.85	38176.0
2011-05-31	ABUS	Stock	3.32	3.4	3.25	3.33	11500.0
2011-05-31	ABV-DELISTED	Stock	31.77	31.79	31.19	31.54	2763612.0
2011-05-31	ABVA-DELISTED	Stock	5.57	5.689	5.401	5.46	13408.0
2011-05-31	ABVT-DELISTED	Stock	75.95	78.07	75.013	78.06	858071.0

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

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