PREVIEW / stock_daily / 2017-01-17

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-17.parquet
  size:    215 KB
  rows:    6,497
  symbols: 3,106

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
2017-01-17	AAPL	Stock	29.585	30.06	29.555	30.0	137759200.0
2017-01-17	MSFT	Stock	62.68	62.7	62.03	62.53	20664000.0
2017-01-17	NVDA	Stock	2.575	2.58	2.5142	2.5278	580612000.0
2017-01-17	AMZN	Stock	40.785	40.8	40.172	40.486	73410000.0
2017-01-17	GOOGL	Stock	41.5	41.509	41.16	41.373	28818100.0
2017-01-17	META	Stock	128.04	128.34	127.4	127.87	15294500.0
2017-01-17	TSLA	Stock	15.78	15.9973	15.6247	15.7053	69262500.0
2017-01-17	TLT	Stock	122.81	122.94	121.99	122.58	7853301.0
2017-01-17	ES	Stock	55.46	55.78	55.29	55.72	1303600.0
2017-01-17	CL	Stock	65.92	67.18	65.87	67.1	5136600.0
2017-01-17	A	Stock	48.37	48.72	48.18	48.32	1938800.0
2017-01-17	AA	Stock	32.97	33.04	32.52	32.64	1381800.0
2017-01-17	AAAP-DELISTED	Stock	29.29	29.45	28.315	28.41	29091.0
2017-01-17	AABA-DELISTED	Stock	42.06	42.18	41.84	42.0	4454960.0
2017-01-17	AAC-DELISTED	Stock	8.06	8.12	7.9	8.01	150493.0
2017-01-17	AACG	Stock	3.45	3.45	3.28	3.3	9100.0
2017-01-17	AAIC-DELISTED	Stock	15.2	15.39	14.98	15.01	234313.0
2017-01-17	AAL	Stock	47.56	47.75	46.67	46.75	5350800.0
2017-01-17	AAMC-DELISTED	Stock	20.0441	20.5882	19.6324	20.5882	37193.0
2017-01-17	AAME	Stock	4.0	4.05	3.95	4.0	13200.0
2017-01-17	AAMI	Stock	14.58	14.58	14.26	14.3	179200.0
2017-01-17	AAOI	Stock	28.89	30.9	28.09	30.44	1412500.0
2017-01-17	AAON	Stock	21.7333	21.7333	21.3067	21.6	174300.0
2017-01-17	AAP	Stock	174.34	177.5	172.94	173.0	1048900.0
2017-01-17	AAT	Stock	43.27	43.48	43.03	43.17	150700.0
2017-01-17	AAU-DELISTED	Stock	1.11	1.11	1.0	1.02	677496.0
2017-01-17	AAUAF-DELISTED	Stock	1.11	1.11	1.0	1.01	698750.0
2017-01-17	AAV-DELISTED	Stock	6.65	6.65	6.475	6.5	54861.0
2017-01-17	AAWW-DELISTED	Stock	51.6	51.85	50.6	50.9	108373.0
2017-01-17	AAXJ	Stock	57.61	57.85	57.61	57.72	1299501.0
2017-01-17	AAXN-DELISTED	Stock	25.17	25.17	24.445	24.82	1142472.0
2017-01-17	AB	Stock	23.7	23.75	23.1	23.15	233100.0
2017-01-17	ABAC-DELISTED	Stock	3.68	3.683	3.55	3.6	4427.0
2017-01-17	ABAX-DELISTED	Stock	48.77	48.77	47.84	48.05	97000.0
2017-01-17	ABB-DELISTED	Stock	22.39	22.49	22.305	22.33	2300324.0
2017-01-17	ABBNY-DELISTED	Stock	22.39	22.49	22.305	22.33	7203826.0
2017-01-17	ABBV	Stock	61.75	62.04	61.1	61.86	8446700.0
2017-01-17	ABC-DELISTED	Stock	84.92	86.47	84.09	85.99	1803401.0
2017-01-17	ABCB	Stock	42.8	42.8	41.65	41.7	136000.0
2017-01-17	ABCD-DELISTED	Stock	5.28	5.31	5.01	5.16	38663.0
2017-01-17	ABCO-DELISTED	Stock	41.9	41.928	40.375	40.55	755721.0
2017-01-17	ABDC-DELISTED	Stock	12.45	12.89	12.26	12.5001	32255.0
2017-01-17	ABE-DELISTED	Stock	11.4	11.47	11.4	11.41	9839.0
2017-01-17	ABEO	Stock	131.25	135.0	128.75	130.0	9892.0
2017-01-17	ABEV	Stock	5.23	5.35	5.19	5.34	17519400.0
2017-01-17	ABG	Stock	63.75	66.9	63.4	64.55	251000.0
2017-01-17	ABIL-DELISTED	Stock	3.47	3.5256	3.3799	3.45	14214.0
2017-01-17	ABM	Stock	40.35	40.42	39.73	39.79	300300.0
2017-01-17	ABMD-DELISTED	Stock	114.69	115.4	113.92	113.97	218241.0
2017-01-17	ABR	Stock	7.58	7.59	7.51	7.53	58200.0

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

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