PREVIEW / stock_daily / 2016-10-04

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-04.parquet
  size:    218 KB
  rows:    6,511
  symbols: 3,190

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-10-04	AAPL	Stock	28.265	28.5775	28.1575	28.25	118947200.0
2016-10-04	MSFT	Stock	57.27	57.6	56.97	57.24	20085900.0
2016-10-04	NVDA	Stock	1.7138	1.7425	1.6948	1.7075	281624000.0
2016-10-04	AMZN	Stock	42.0455	42.1185	41.513	41.7015	59006000.0
2016-10-04	GOOGL	Stock	40.25	40.325	39.9835	40.1395	25174120.0
2016-10-04	META	Stock	129.17	129.28	127.55	128.19	14307500.0
2016-10-04	TSLA	Stock	14.2067	14.2213	13.9213	14.094	53122500.0
2016-10-04	TLT	Stock	136.62	136.84	135.16	135.21	12048727.0
2016-10-04	ES	Stock	53.28	53.4	52.32	52.61	2520200.0
2016-10-04	CL	Stock	73.64	73.73	72.58	72.8	3267300.0
2016-10-04	A	Stock	47.07	47.3	46.67	46.83	1764000.0
2016-10-04	AA.B-DELISTED	Stock	33.0	33.02	32.5	32.93	2485087.0
2016-10-04	AAAP-DELISTED	Stock	37.4	37.91	37.25	37.55	29458.0
2016-10-04	AABA-DELISTED	Stock	43.2	43.5	42.9638	43.18	8152143.0
2016-10-04	AAC-DELISTED	Stock	17.45	17.544	16.88	17.35	191989.0
2016-10-04	AACG	Stock	4.07	4.5	4.07	4.19	7500.0
2016-10-04	AAIC-DELISTED	Stock	14.74	14.78	14.34	14.41	334375.0
2016-10-04	AAL	Stock	38.39	38.78	37.55	37.63	9065600.0
2016-10-04	AAMC-DELISTED	Stock	6.6206	6.6206	5.9147	6.2294	66956.0
2016-10-04	AAME	Stock	3.35	3.45	3.21	3.44	10100.0
2016-10-04	AAMI	Stock	13.83	13.953	13.69	13.85	157600.0
2016-10-04	AAOI	Stock	21.58	22.03	21.265	21.63	262200.0
2016-10-04	AAON	Stock	19.4067	19.9867	19.4067	19.9333	316350.0
2016-10-04	AAP	Stock	147.32	148.09	146.11	146.54	592300.0
2016-10-04	AAT	Stock	42.47	42.47	41.5	41.72	142300.0
2016-10-04	AAU-DELISTED	Stock	1.3	1.3088	1.19	1.19	1274451.0
2016-10-04	AAUAF-DELISTED	Stock	1.3	1.3088	1.19	1.19	1287103.0
2016-10-04	AAV-DELISTED	Stock	7.09	7.23	6.96	6.97	81105.0
2016-10-04	AAWW-DELISTED	Stock	42.49	42.88	41.92	41.95	117921.0
2016-10-04	AAXJ	Stock	60.83	60.945	60.09	60.19	1349876.0
2016-10-04	AAXN-DELISTED	Stock	24.65	24.7	23.62	23.71	2584718.0
2016-10-04	AB	Stock	22.72	22.84	22.09	22.26	147300.0
2016-10-04	ABAC-DELISTED	Stock	2.14	2.14	2.01	2.14	8319.0
2016-10-04	ABAX-DELISTED	Stock	51.94	52.7	51.81	52.19	104488.0
2016-10-04	ABB-DELISTED	Stock	22.62	22.74	22.5	22.57	1876269.0
2016-10-04	ABBNY-DELISTED	Stock	22.62	22.74	22.5	22.57	1926776.0
2016-10-04	ABBV	Stock	63.31	63.53	62.55	63.0	4719400.0
2016-10-04	ABC-DELISTED	Stock	81.26	81.72	80.25	80.56	1428128.0
2016-10-04	ABCB	Stock	35.08	35.9	35.0	35.19	143300.0
2016-10-04	ABCD-DELISTED	Stock	5.46	5.46	5.28	5.33	6937.0
2016-10-04	ABCO-DELISTED	Stock	43.5	43.73	43.13	43.47	103097.0
2016-10-04	ABDC-DELISTED	Stock	12.98	13.08	12.58	12.58	72705.0
2016-10-04	ABE-DELISTED	Stock	12.7	12.712	12.63	12.6337	3070.0
2016-10-04	ABEO	Stock	155.0	155.25	148.25	150.25	7716.0
2016-10-04	ABEV	Stock	6.08	6.12	5.96	5.96	12849400.0
2016-10-04	ABG	Stock	54.97	55.49	53.52	54.12	161800.0
2016-10-04	ABIL-DELISTED	Stock	3.79	3.8	3.63	3.77	11724.0
2016-10-04	ABM	Stock	39.83	40.08	39.1	39.23	205700.0
2016-10-04	ABMD-DELISTED	Stock	128.48	129.1	126.36	127.41	292201.0
2016-10-04	ABR	Stock	7.36	7.36	7.27	7.3	146600.0

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

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