PREVIEW / stock_daily / 2011-10-10

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-10.parquet
  size:    192 KB
  rows:    6,048
  symbols: 3,489

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-10-10	AAPL	Stock	13.5389	13.8861	13.5075	13.8861	442514800.0
2011-10-10	MSFT	Stock	26.58	26.97	26.47	26.94	41815300.0
2011-10-10	NVDA	Stock	0.3598	0.3695	0.359	0.3695	534376000.0
2011-10-10	AMZN	Stock	11.3115	11.64	11.205	11.566	102862000.0
2011-10-10	TSLA	Stock	1.8207	1.8787	1.8	1.8587	13852500.0
2011-10-10	TLT	Stock	116.82	116.91	115.8	116.57	3567730.0
2011-10-10	ES	Stock	32.43	32.96	32.41	32.96	1911900.0
2011-10-10	CL	Stock	45.605	45.955	45.25	45.87	3497000.0
2011-10-10	A	Stock	22.99	23.927	22.9041	23.8269	5389290.0
2011-10-10	AABA-DELISTED	Stock	15.86	16.04	15.62	15.83	27689653.0
2011-10-10	AACC-DELISTED	Stock	3.06	3.075	3.05	3.06	8303.0
2011-10-10	AACG	Stock	8.5	8.8	8.47	8.61	21800.0
2011-10-10	AAIC-DELISTED	Stock	24.41	24.98	24.214	24.73	30543.0
2011-10-10	AAME	Stock	1.95	1.95	1.82	1.83	3100.0
2011-10-10	AAON	Stock	5.203	5.4163	5.0904	5.4074	421538.0
2011-10-10	AAP	Stock	59.92	61.06	59.52	60.94	481700.0
2011-10-10	AAT	Stock	17.75	17.78	17.55	17.76	151900.0
2011-10-10	AATI-DELISTED	Stock	4.43	4.48	4.38	4.48	262295.0
2011-10-10	AAU-DELISTED	Stock	2.63	2.761	2.55	2.74	125087.0
2011-10-10	AAUAF-DELISTED	Stock	2.66	2.791	2.58	2.74	125937.0
2011-10-10	AAV-DELISTED	Stock	4.12	4.27	4.12	4.25	368382.0
2011-10-10	AAWW-DELISTED	Stock	34.11	35.22	34.01	34.98	266885.0
2011-10-10	AAXJ	Stock	48.88	50.09	48.88	50.09	230329.0
2011-10-10	AAXN-DELISTED	Stock	4.52	4.57	4.44	4.55	314082.0
2011-10-10	AB	Stock	13.84	14.02	13.61	13.92	436000.0
2011-10-10	ABAC-DELISTED	Stock	1.86	1.8899	1.81	1.85	12226.0
2011-10-10	ABAX-DELISTED	Stock	23.52	23.585	23.12	23.45	154636.0
2011-10-10	ABB-DELISTED	Stock	18.48	18.92	18.46	18.91	3031015.0
2011-10-10	ABBNY-DELISTED	Stock	18.48	18.92	18.46	18.9	3033415.0
2011-10-10	ABC-DELISTED	Stock	36.32	37.19	36.28	37.06	1909612.0
2011-10-10	ABCB	Stock	9.13	9.37	9.04	9.36	73500.0
2011-10-10	ABCD-DELISTED	Stock	3.05	3.07	2.98	3.05	51332.0
2011-10-10	ABCO-DELISTED	Stock	30.53	31.95	30.43	31.83	187396.0
2011-10-10	ABCW-DELISTED	Stock	0.4917	0.5017	0.4867	0.4983	11160.0
2011-10-10	ABD-DELISTED	Stock	5.0949	5.3351	5.0148	5.3151	290430.0
2011-10-10	ABE-DELISTED	Stock	17.13	17.33	17.08	17.24	4605.0
2011-10-10	ABEO	Stock	2062.5	2250.0	2062.5	2187.5	3.0
2011-10-10	ABFS-DELISTED	Stock	16.47	16.94	16.45	16.72	348545.0
2011-10-10	ABG	Stock	18.32	19.15	18.16	18.92	323200.0
2011-10-10	ABH-DELISTED	Stock	15.59	15.95	15.5	15.94	218363.0
2011-10-10	ABM	Stock	19.51	20.04	19.5	20.04	251700.0
2011-10-10	ABMD-DELISTED	Stock	11.68	12.26	11.66	12.18	167467.0
2011-10-10	ABR	Stock	3.25	3.29	3.19	3.27	93000.0
2011-10-10	ABT	Stock	25.0456	25.2471	24.9352	25.2471	22854940.0
2011-10-10	ABTL-DELISTED	Stock	4.0	4.65	4.0	4.25	4867.0
2011-10-10	ABUS	Stock	1.86	1.86	1.86	1.86	100.0
2011-10-10	ABV-DELISTED	Stock	33.06	33.07	32.44	32.54	2400076.0
2011-10-10	ABVA-DELISTED	Stock	4.83	4.88	4.83	4.88	1192.0
2011-10-10	ABVT-DELISTED	Stock	55.9	58.47	55.5	57.38	222646.0
2011-10-10	ABX-DELISTED	Stock	47.62	48.0	47.0	47.96	4087206.0

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

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