PREVIEW / stock_daily / 2012-09-13

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-13.parquet
  size:    200 KB
  rows:    6,180
  symbols: 3,505

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
2012-09-13	AAPL	Stock	24.1918	24.4821	24.0989	24.3921	598360000.0
2012-09-13	MSFT	Stock	30.89	31.18	30.4	30.94	45047300.0
2012-09-13	NVDA	Stock	0.3428	0.344	0.3355	0.342	433836000.0
2012-09-13	AMZN	Stock	12.747	13.1	12.69	13.012	70512000.0
2012-09-13	META	Stock	20.96	21.48	20.61	20.71	65041600.0
2012-09-13	TSLA	Stock	1.9047	1.9667	1.8987	1.9653	22270500.0
2012-09-13	TLT	Stock	122.39	123.09	120.27	121.53	12280179.0
2012-09-13	ES	Stock	37.57	38.32	37.54	38.32	1324000.0
2012-09-13	CL	Stock	51.515	52.35	51.345	52.27	5306800.0
2012-09-13	A	Stock	26.7954	27.525	26.5951	27.4535	7529908.0
2012-09-13	AABA-DELISTED	Stock	15.38	15.69	15.37	15.61	12019105.0
2012-09-13	AACC-DELISTED	Stock	6.86	7.64	6.82	7.44	55361.0
2012-09-13	AACG	Stock	4.36	4.41	4.36	4.38	1700.0
2012-09-13	AAIC-DELISTED	Stock	23.58	24.21	23.4	23.98	180181.0
2012-09-13	AAME	Stock	2.7	2.7	2.63	2.63	3400.0
2012-09-13	AAMRQ-DELISTED	Stock	0.45	0.46	0.448	0.4512	1287734.0
2012-09-13	AAON	Stock	5.5526	5.7748	5.4607	5.7452	257513.0
2012-09-13	AAP	Stock	70.7	70.7	69.0	69.47	980700.0
2012-09-13	AAT	Stock	27.52	27.64	27.46	27.58	384300.0
2012-09-13	AAU-DELISTED	Stock	2.77	2.98	2.72	2.91	270821.0
2012-09-13	AAUAF-DELISTED	Stock	2.77	2.98	2.72	2.9	276521.0
2012-09-13	AAV-DELISTED	Stock	3.7	3.74	3.66	3.68	529381.0
2012-09-13	AAWW-DELISTED	Stock	57.0	57.0	55.33	56.97	294118.0
2012-09-13	AAXJ	Stock	54.6	56.23	54.6	56.03	463125.0
2012-09-13	AAXN-DELISTED	Stock	5.43	5.48	5.319	5.41	448103.0
2012-09-13	AB	Stock	14.72	14.9	14.52	14.9	471300.0
2012-09-13	ABAC-DELISTED	Stock	1.08	1.08	1.0401	1.0401	500.0
2012-09-13	ABAX-DELISTED	Stock	35.4	36.36	34.854	35.675	181622.0
2012-09-13	ABB-DELISTED	Stock	19.21	19.565	19.11	19.47	3121917.0
2012-09-13	ABBNY-DELISTED	Stock	19.21	19.565	19.11	19.47	4038671.0
2012-09-13	ABC-DELISTED	Stock	37.83	38.14	37.475	38.08	3151619.0
2012-09-13	ABCB	Stock	12.23	12.8	12.23	12.74	44800.0
2012-09-13	ABCD-DELISTED	Stock	1.03	1.05	1.02	1.03	12986.0
2012-09-13	ABCO-DELISTED	Stock	46.38	47.53	46.32	47.07	153033.0
2012-09-13	ABCW-DELISTED	Stock	0.44	0.45	0.36	0.43	12031.0
2012-09-13	ABE-DELISTED	Stock	19.87	20.3499	19.87	20.3499	13181.0
2012-09-13	ABEO	Stock	825.0	825.0	650.0	750.0	7.0
2012-09-13	ABFS-DELISTED	Stock	8.32	8.53	8.25	8.42	406790.0
2012-09-13	ABG	Stock	28.86	29.22	28.38	29.19	406500.0
2012-09-13	ABM	Stock	18.78	19.01	18.65	18.94	371600.0
2012-09-13	ABMD-DELISTED	Stock	20.8	21.19	20.61	21.1	471635.0
2012-09-13	ABR	Stock	5.65	5.68	5.59	5.63	259600.0
2012-09-13	ABT	Stock	32.4681	33.2357	32.4681	33.2357	16552105.0
2012-09-13	ABTL-DELISTED	Stock	3.6875	3.71	3.5874	3.653	27494.0
2012-09-13	ABUS	Stock	3.25	3.3	3.23	3.26	9200.0
2012-09-13	ABV-DELISTED	Stock	37.2	38.24	37.03	38.22	2192166.0
2012-09-13	ABVA-DELISTED	Stock	4.78	4.8	4.75	4.7792	3252.0
2012-09-13	ABX-DELISTED	Stock	39.69	41.65	38.96	41.64	14570113.0
2012-09-13	ACAD	Stock	2.1	2.1	2.02	2.09	719700.0
2012-09-13	ACAS-DELISTED	Stock	11.66	11.88	11.6	11.83	2964247.0

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

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