PREVIEW / stock_daily / 2017-01-09

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-09.parquet
  size:    216 KB
  rows:    6,491
  symbols: 3,101

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-09	AAPL	Stock	29.4875	29.8575	29.485	29.7475	134247600.0
2017-01-09	MSFT	Stock	62.76	63.08	62.54	62.64	20382700.0
2017-01-09	NVDA	Stock	2.5875	2.7	2.5875	2.682	916248000.0
2017-01-09	AMZN	Stock	39.9	40.0885	39.5885	39.846	68922000.0
2017-01-09	GOOGL	Stock	41.3185	41.5215	41.081	41.359	28178480.0
2017-01-09	META	Stock	123.55	125.43	123.04	124.9	22880400.0
2017-01-09	TSLA	Stock	15.2647	15.4613	15.2	15.4187	59692500.0
2017-01-09	TLT	Stock	121.88	122.0	121.46	121.83	8839108.0
2017-01-09	ES	Stock	55.31	55.51	54.55	54.57	1302800.0
2017-01-09	CL	Stock	67.02	67.1	66.23	66.42	3184000.0
2017-01-09	A	Stock	48.01	48.56	47.91	48.14	2575300.0
2017-01-09	AA	Stock	30.88	30.88	29.215	29.48	4205100.0
2017-01-09	AAAP-DELISTED	Stock	27.14	28.13	27.14	28.02	44772.0
2017-01-09	AABA-DELISTED	Stock	41.17	41.66	41.125	41.35	7481643.0
2017-01-09	AAC-DELISTED	Stock	7.58	7.69	7.5	7.56	113834.0
2017-01-09	AACG	Stock	3.66	3.69	3.66	3.69	1000.0
2017-01-09	AAIC-DELISTED	Stock	14.85	15.04	14.74	15.01	346416.0
2017-01-09	AAL	Stock	46.01	47.34	45.78	47.08	4739100.0
2017-01-09	AAMC-DELISTED	Stock	17.6471	17.6618	16.8661	17.6176	16735.0
2017-01-09	AAME	Stock	4.2	4.35	3.95	3.95	6900.0
2017-01-09	AAMI	Stock	14.52	14.52	14.29	14.32	399700.0
2017-01-09	AAOI	Stock	22.36	22.73	21.88	22.24	346800.0
2017-01-09	AAON	Stock	21.6667	22.1333	21.5	21.8667	391950.0
2017-01-09	AAP	Stock	170.06	170.28	168.32	169.53	560100.0
2017-01-09	AAT	Stock	43.95	43.95	43.08	43.09	95300.0
2017-01-09	AAU-DELISTED	Stock	1.01	1.05	1.0	1.01	289529.0
2017-01-09	AAUAF-DELISTED	Stock	1.01	1.05	1.0	1.01	291166.0
2017-01-09	AAV-DELISTED	Stock	6.5	6.54	6.3	6.4	133773.0
2017-01-09	AAWW-DELISTED	Stock	50.25	51.6	49.95	51.0	136470.0
2017-01-09	AAXJ	Stock	56.51	56.74	56.5	56.58	878002.0
2017-01-09	AAXN-DELISTED	Stock	24.52	24.637	24.26	24.27	332004.0
2017-01-09	AB	Stock	24.55	24.55	23.75	23.85	364700.0
2017-01-09	ABAC-DELISTED	Stock	3.6856	3.6856	3.4819	3.5501	2678.0
2017-01-09	ABAX-DELISTED	Stock	53.6	55.44	53.045	55.05	155412.0
2017-01-09	ABB-DELISTED	Stock	21.41	21.55	21.38	21.51	1331912.0
2017-01-09	ABBNY-DELISTED	Stock	21.41	21.55	21.38	21.5	1359130.0
2017-01-09	ABBV	Stock	63.8	64.38	63.75	64.21	8794500.0
2017-01-09	ABC-DELISTED	Stock	84.6	86.07	84.6	85.49	1819495.0
2017-01-09	ABCB	Stock	43.55	43.55	41.8	42.9	275700.0
2017-01-09	ABCD-DELISTED	Stock	5.04	5.04	4.88	4.98	6673.0
2017-01-09	ABCO-DELISTED	Stock	36.35	36.4037	35.2	35.3	596688.0
2017-01-09	ABDC-DELISTED	Stock	12.18	12.545	12.0391	12.38	17821.0
2017-01-09	ABE-DELISTED	Stock	11.46	11.465	11.43	11.443	13459.0
2017-01-09	ABEO	Stock	152.5	157.5	136.5	151.25	23768.0
2017-01-09	ABEOW-DELISTED	Stock	3.48	3.5	3.48	3.5	326.0
2017-01-09	ABEV	Stock	5.17	5.18	5.12	5.13	14844000.0
2017-01-09	ABG	Stock	61.75	62.7	61.1	62.25	101800.0
2017-01-09	ABIL-DELISTED	Stock	3.3	3.38	3.28	3.33	41838.0
2017-01-09	ABM	Stock	40.08	40.08	39.4	39.41	332600.0
2017-01-09	ABMD-DELISTED	Stock	115.62	117.71	114.67	117.11	289614.0

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

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