PREVIEW / stock_daily / 2011-09-01

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-01.parquet
  size:    194 KB
  rows:    6,054
  symbols: 3,507

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-09-01	AAPL	Stock	13.7793	13.8336	13.5971	13.6082	343725200.0
2011-09-01	MSFT	Stock	26.46	26.86	26.21	26.21	60510800.0
2011-09-01	NVDA	Stock	0.3373	0.3445	0.3318	0.332	762312000.0
2011-09-01	AMZN	Stock	10.764	10.882	10.581	10.627	105506000.0
2011-09-01	TSLA	Stock	1.644	1.658	1.5893	1.6	12721500.0
2011-09-01	TLT	Stock	107.47	108.98	106.08	108.97	10686617.0
2011-09-01	ES	Stock	34.9	34.9	34.31	34.35	1858200.0
2011-09-01	CL	Stock	45.0	45.405	44.805	44.95	4504600.0
2011-09-01	A	Stock	26.3233	26.7167	25.515	25.6366	6791204.0
2011-09-01	AABA-DELISTED	Stock	13.64	13.78	13.32	13.345	17798411.0
2011-09-01	AACC-DELISTED	Stock	3.97	4.11	3.58	4.0	173511.0
2011-09-01	AACG	Stock	9.16	9.57	9.16	9.46	19000.0
2011-09-01	AAIC-DELISTED	Stock	25.84	26.19	24.77	24.81	31760.0
2011-09-01	AAME	Stock	1.97	1.97	1.89	1.93	2500.0
2011-09-01	AAON	Stock	5.1733	5.2563	4.9837	5.0637	295650.0
2011-09-01	AAP	Stock	60.8	61.32	60.17	60.33	909000.0
2011-09-01	AAT	Stock	20.09	20.37	19.67	19.78	188600.0
2011-09-01	AATI-DELISTED	Stock	6.02	6.02	5.97	5.98	284997.0
2011-09-01	AAU-DELISTED	Stock	3.23	3.25	3.12	3.17	97911.0
2011-09-01	AAUAF-DELISTED	Stock	3.23	3.25	3.12	3.17	100611.0
2011-09-01	AAV-DELISTED	Stock	5.83	5.91	5.705	5.77	394785.0
2011-09-01	AAWW-DELISTED	Stock	49.35	50.96	48.702	49.48	460241.0
2011-09-01	AAXJ	Stock	56.36	56.73	55.75	55.75	153991.0
2011-09-01	AAXN-DELISTED	Stock	4.44	4.53	4.31	4.32	368300.0
2011-09-01	AB	Stock	17.0	17.0	16.65	16.93	193100.0
2011-09-01	ABAC-DELISTED	Stock	2.3	2.38	2.2	2.35	55682.0
2011-09-01	ABAX-DELISTED	Stock	24.92	25.73	24.78	25.12	161711.0
2011-09-01	ABB-DELISTED	Stock	21.31	21.4	21.11	21.18	5896040.0
2011-09-01	ABBC-DELISTED	Stock	8.72	9.04	8.41	8.44	52001.0
2011-09-01	ABBNY-DELISTED	Stock	21.31	21.4	21.11	21.19	6546540.0
2011-09-01	ABC-DELISTED	Stock	39.48	40.37	39.27	39.49	2722125.0
2011-09-01	ABCB	Stock	9.23	9.3	8.75	8.75	54400.0
2011-09-01	ABCD-DELISTED	Stock	3.0	3.04	2.97	3.01	70328.0
2011-09-01	ABCO-DELISTED	Stock	31.13	31.81	29.39	30.02	190809.0
2011-09-01	ABCW-DELISTED	Stock	0.62	0.63	0.61	0.63	33310.0
2011-09-01	ABD-DELISTED	Stock	6.8	7.07	6.62	6.66	325840.0
2011-09-01	ABE-DELISTED	Stock	18.41	18.61	18.41	18.6	19491.0
2011-09-01	ABEO	Stock	2312.5	2562.5	2312.5	2462.5	8.0
2011-09-01	ABFS-DELISTED	Stock	20.7	20.86	19.61	19.84	301957.0
2011-09-01	ABG	Stock	18.86	19.25	18.0	18.02	403100.0
2011-09-01	ABH-DELISTED	Stock	17.06	17.06	16.06	16.1	250440.0
2011-09-01	ABM	Stock	20.37	20.73	19.83	20.08	332800.0
2011-09-01	ABMD-DELISTED	Stock	12.42	12.61	12.0844	12.32	160165.0
2011-09-01	ABR	Stock	4.06	4.06	4.0	4.0	14600.0
2011-09-01	ABT	Stock	25.1415	25.3862	24.8632	24.9208	14314923.0
2011-09-01	ABTL-DELISTED	Stock	4.7003	4.7013	4.6017	4.6997	11669.0
2011-09-01	ABUS	Stock	1.94	2.03	1.92	2.01	4000.0
2011-09-01	ABV-DELISTED	Stock	36.2	36.3	34.94	34.99	5827482.0
2011-09-01	ABVA-DELISTED	Stock	4.5	4.55	4.5	4.55	1000.0
2011-09-01	ABVT-DELISTED	Stock	61.42	62.2	59.01	59.71	233495.0

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

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