PREVIEW / stock_daily / 2014-05-16

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-16.parquet
  size:    218 KB
  rows:    6,525
  symbols: 3,537

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
2014-05-16	AAPL	Stock	21.0225	21.3404	20.9071	21.3396	276256400.0
2014-05-16	MSFT	Stock	39.67	39.84	39.27	39.83	29867100.0
2014-05-16	NVDA	Stock	0.4465	0.4522	0.4465	0.449	283960000.0
2014-05-16	AMZN	Stock	14.64	14.944	14.5775	14.885	72736000.0
2014-05-16	GOOGL	Stock	26.48	26.542	26.1785	26.415	38154660.0
2014-05-16	META	Stock	58.31	58.45	57.31	58.02	47933000.0
2014-05-16	TSLA	Stock	12.5967	12.8027	12.5147	12.7707	67315500.0
2014-05-16	TLT	Stock	113.61	114.0	113.42	113.54	5019196.0
2014-05-16	ES	Stock	45.49	46.02	45.35	45.98	2385800.0
2014-05-16	CL	Stock	66.3	66.97	66.3	66.92	2840300.0
2014-05-16	A	Stock	38.9056	39.4349	38.5694	39.3634	3363308.0
2014-05-16	AABA-DELISTED	Stock	33.66	33.66	33.1	33.4	18239338.0
2014-05-16	AACG	Stock	4.39	4.56	4.38	4.52	15800.0
2014-05-16	AAIC-DELISTED	Stock	26.53	26.71	26.3	26.71	144680.0
2014-05-16	AAL	Stock	38.01	38.68	37.76	38.53	7062500.0
2014-05-16	AAMC-DELISTED	Stock	234.0588	250.8529	234.0588	247.3529	54886.0
2014-05-16	AAME	Stock	3.57	3.67	3.35	3.37	6200.0
2014-05-16	AAOI	Stock	18.04	18.294	17.67	18.15	135500.0
2014-05-16	AAON	Stock	13.2578	13.5511	13.1689	13.4578	226575.0
2014-05-16	AAP	Stock	123.86	123.99	120.21	121.67	1900300.0
2014-05-16	AAT	Stock	33.77	34.36	33.54	34.33	203400.0
2014-05-16	AAU-DELISTED	Stock	1.3	1.31	1.27	1.3	55289.0
2014-05-16	AAUAF-DELISTED	Stock	1.3	1.31	1.27	1.3	55923.0
2014-05-16	AAV-DELISTED	Stock	5.84	5.84	5.67	5.76	168162.0
2014-05-16	AAWW-DELISTED	Stock	36.38	37.14	36.318	36.76	187636.0
2014-05-16	AAXJ	Stock	61.21	61.79	61.21	61.77	303375.0
2014-05-16	AAXN-DELISTED	Stock	13.03	13.33	12.82	13.33	995619.0
2014-05-16	AB	Stock	23.04	23.9	22.75	23.87	373700.0
2014-05-16	ABAC-DELISTED	Stock	2.12	2.12	2.05	2.06	38360.0
2014-05-16	ABAX-DELISTED	Stock	43.29	43.86	42.99	43.58	89426.0
2014-05-16	ABB-DELISTED	Stock	23.57	23.615	23.47	23.59	1322801.0
2014-05-16	ABBNY-DELISTED	Stock	23.57	23.615	23.47	23.58	1411652.0
2014-05-16	ABBV	Stock	52.65	52.97	52.41	52.93	5826200.0
2014-05-16	ABC-DELISTED	Stock	67.36	68.34	67.31	68.3	2386874.0
2014-05-16	ABCB	Stock	19.84	19.9	19.61	19.73	88100.0
2014-05-16	ABCD-DELISTED	Stock	2.35	2.35	2.3	2.35	16716.0
2014-05-16	ABCO-DELISTED	Stock	49.88	50.86	49.8	50.42	331348.0
2014-05-16	ABDC-DELISTED	Stock	15.05	15.05	14.85	14.99	21365.0
2014-05-16	ABE-DELISTED	Stock	13.85	13.99	13.8499	13.929	17913.0
2014-05-16	ABEO	Stock	600.0	600.0	550.0	550.0	1.0
2014-05-16	ABEV	Stock	7.46	7.47	7.34	7.4	8364900.0
2014-05-16	ABG	Stock	62.32	62.99	62.11	62.77	386400.0
2014-05-16	ABGB-DELISTED	Stock	19.82	19.89	19.58	19.845	263980.0
2014-05-16	ABIL-DELISTED	Stock	9.74	9.74	9.74	9.74	100.0
2014-05-16	ABM	Stock	26.2	26.53	26.07	26.51	161300.0
2014-05-16	ABMD-DELISTED	Stock	21.16	21.5	21.01	21.5	220855.0
2014-05-16	ABR	Stock	7.02	7.08	6.96	7.01	103600.0
2014-05-16	ABR.A-DELISTED	Stock	24.77	24.84	24.48	24.72	11815.0
2014-05-16	ABR.B-DELISTED	Stock	23.78	23.78	23.51	23.52	12496.0
2014-05-16	ABR.C-DELISTED	Stock	24.821	24.8399	24.8	24.8	3350.0

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

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