PREVIEW / stock_daily / 2016-05-02

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-02.parquet
  size:    220 KB
  rows:    6,591
  symbols: 3,312

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
2016-05-02	AAPL	Stock	23.4925	23.52	23.1	23.41	192640400.0
2016-05-02	MSFT	Stock	50.0	50.75	49.78	50.61	33114500.0
2016-05-02	NVDA	Stock	0.8968	0.9055	0.8925	0.9	256076000.0
2016-05-02	AMZN	Stock	33.196	34.275	33.1015	34.1925	131570000.0
2016-05-02	GOOGL	Stock	35.596	35.7705	35.318	35.7205	33476400.0
2016-05-02	META	Stock	117.83	118.73	116.57	118.57	28095200.0
2016-05-02	TSLA	Stock	16.1	16.2127	15.6547	16.12	57658500.0
2016-05-02	TLT	Stock	128.66	128.895	127.8	127.82	11035175.0
2016-05-02	ES	Stock	56.6	57.32	56.49	57.07	1329800.0
2016-05-02	CL	Stock	71.47	72.39	71.42	72.37	4687500.0
2016-05-02	A	Stock	41.2	41.75	41.13	41.71	1285300.0
2016-05-02	AA.B-DELISTED	Stock	38.02	38.12	37.4	37.565	33338.0
2016-05-02	AAAP-DELISTED	Stock	34.5101	34.95	33.77	33.78	6404.0
2016-05-02	AABA-DELISTED	Stock	36.65	36.735	36.32	36.53	6081775.0
2016-05-02	AAC-DELISTED	Stock	20.53	20.53	19.58	20.0601	139239.0
2016-05-02	AACG	Stock	5.58	5.7	5.5	5.5	41700.0
2016-05-02	AAIC-DELISTED	Stock	12.95	13.04	12.78	12.83	153140.0
2016-05-02	AAL	Stock	34.99	35.17	34.4	34.43	8829800.0
2016-05-02	AAMC-DELISTED	Stock	4.9265	4.9265	4.4147	4.5176	37101.0
2016-05-02	AAMI	Stock	13.43	13.93	13.32	13.79	213900.0
2016-05-02	AAOI	Stock	11.21	11.37	10.76	11.12	509000.0
2016-05-02	AAON	Stock	17.76	17.9733	17.58	17.88	242250.0
2016-05-02	AAP	Stock	156.34	156.76	152.69	155.46	861600.0
2016-05-02	AAT	Stock	40.0	40.81	39.74	40.68	288000.0
2016-05-02	AAU-DELISTED	Stock	1.14	1.17	1.1	1.1	445495.0
2016-05-02	AAUAF-DELISTED	Stock	1.14	1.17	1.1	1.1	446967.0
2016-05-02	AAV-DELISTED	Stock	5.68	5.7	5.56	5.63	107947.0
2016-05-02	AAVL-DELISTED	Stock	5.67	5.76	5.49	5.69	206056.0
2016-05-02	AAWW-DELISTED	Stock	39.96	41.17	39.5	40.82	174932.0
2016-05-02	AAXJ	Stock	54.04	54.1561	53.77	54.07	563069.0
2016-05-02	AAXN-DELISTED	Stock	18.25	18.6	18.13	18.53	445672.0
2016-05-02	AB	Stock	23.5	23.99	23.29	23.84	285400.0
2016-05-02	ABAC-DELISTED	Stock	0.65	0.72	0.61	0.72	22268.0
2016-05-02	ABAX-DELISTED	Stock	45.31	45.73	43.83	44.5301	194182.0
2016-05-02	ABB-DELISTED	Stock	21.18	21.25	21.09	21.22	1860265.0
2016-05-02	ABBNY-DELISTED	Stock	21.18	21.25	21.09	21.23	2071225.0
2016-05-02	ABBV	Stock	60.79	62.0	60.7	61.44	9512000.0
2016-05-02	ABC-DELISTED	Stock	85.19	85.37	84.51	85.22	1481929.0
2016-05-02	ABCB	Stock	31.57	31.69	31.23	31.4	301200.0
2016-05-02	ABCD-DELISTED	Stock	4.55	4.69	4.505	4.67	23114.0
2016-05-02	ABCO-DELISTED	Stock	31.62	32.06	31.12	31.61	467727.0
2016-05-02	ABDC-DELISTED	Stock	11.73	11.89	11.45	11.53	20344.0
2016-05-02	ABE-DELISTED	Stock	12.04	12.1096	12.03	12.1	2030.0
2016-05-02	ABEO	Stock	68.0	68.0	62.75	67.25	2348.0
2016-05-02	ABEV	Stock	5.54	5.57	5.5	5.55	10950900.0
2016-05-02	ABG	Stock	61.14	61.14	58.92	59.48	266100.0
2016-05-02	ABIL-DELISTED	Stock	5.65	5.92	4.89	4.9	228703.0
2016-05-02	ABM	Stock	32.22	32.51	32.08	32.51	244200.0
2016-05-02	ABMD-DELISTED	Stock	97.61	100.77	97.61	99.25	773690.0
2016-05-02	ABR	Stock	6.71	6.76	6.71	6.74	55200.0

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

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