PREVIEW / stock_daily / 2017-01-10

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-10.parquet
  size:    215 KB
  rows:    6,493
  symbols: 3,098

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-10	AAPL	Stock	29.6925	29.845	29.575	29.7775	97848400.0
2017-01-10	MSFT	Stock	62.73	63.07	62.28	62.62	18593000.0
2017-01-10	NVDA	Stock	2.6952	2.7298	2.6408	2.6618	880920000.0
2017-01-10	AMZN	Stock	39.83	39.9	39.477	39.795	51168000.0
2017-01-10	GOOGL	Stock	41.3535	41.4705	41.157	41.3005	23948840.0
2017-01-10	META	Stock	124.82	125.5	124.28	124.35	17324600.0
2017-01-10	TSLA	Stock	15.4667	15.4667	15.126	15.3247	54900000.0
2017-01-10	TLT	Stock	121.55	121.91	121.28	121.75	8417941.0
2017-01-10	ES	Stock	54.49	54.52	54.08	54.28	1608800.0
2017-01-10	CL	Stock	66.42	66.43	65.35	65.39	3492400.0
2017-01-10	A	Stock	48.34	48.54	47.82	48.1	1560500.0
2017-01-10	AA	Stock	29.83	31.1	29.73	30.98	3823600.0
2017-01-10	AAAP-DELISTED	Stock	28.01	28.5	27.89	28.39	20307.0
2017-01-10	AABA-DELISTED	Stock	41.78	42.37	41.54	42.3	7670926.0
2017-01-10	AAC-DELISTED	Stock	7.6	7.96	7.6	7.91	118556.0
2017-01-10	AACG	Stock	3.69	3.69	3.63	3.65	2600.0
2017-01-10	AAIC-DELISTED	Stock	15.04	15.32	14.96	15.32	304924.0
2017-01-10	AAL	Stock	47.0	48.51	46.97	48.48	7483800.0
2017-01-10	AAMC-DELISTED	Stock	17.7206	17.9412	17.3603	17.6324	24759.0
2017-01-10	AAME	Stock	4.05	4.05	3.95	4.05	4900.0
2017-01-10	AAMI	Stock	14.34	14.41	14.16	14.34	338800.0
2017-01-10	AAOI	Stock	22.36	23.32	22.31	22.87	197900.0
2017-01-10	AAON	Stock	21.9667	22.3	21.7333	22.2667	276600.0
2017-01-10	AAP	Stock	168.7	171.92	168.63	169.92	621200.0
2017-01-10	AAT	Stock	43.1	43.23	42.82	43.17	133700.0
2017-01-10	AAU-DELISTED	Stock	1.01	1.04	1.01	1.025	227692.0
2017-01-10	AAUAF-DELISTED	Stock	1.01	1.04	1.01	1.025	230331.0
2017-01-10	AAV-DELISTED	Stock	6.4	6.5	6.3	6.35	88098.0
2017-01-10	AAWW-DELISTED	Stock	51.05	52.4	50.6	52.15	101065.0
2017-01-10	AAXJ	Stock	57.01	57.47	56.99	57.13	1329268.0
2017-01-10	AAXN-DELISTED	Stock	24.38	25.0	24.27	24.64	730408.0
2017-01-10	AB	Stock	23.95	24.1	22.6	22.85	1044600.0
2017-01-10	ABAC-DELISTED	Stock	3.5699	3.5699	3.47	3.5299	7186.0
2017-01-10	ABAX-DELISTED	Stock	48.0	52.9	45.0	48.59	684007.0
2017-01-10	ABB-DELISTED	Stock	21.68	22.13	21.68	22.095	2985595.0
2017-01-10	ABBNY-DELISTED	Stock	21.68	22.13	21.68	22.1	3257116.0
2017-01-10	ABBV	Stock	64.05	64.5	63.77	64.07	6523500.0
2017-01-10	ABC-DELISTED	Stock	85.1	86.14	84.3	84.83	1577193.0
2017-01-10	ABCB	Stock	43.0	43.98	42.75	43.7	225800.0
2017-01-10	ABCD-DELISTED	Stock	5.01	5.26	4.88	5.09	45722.0
2017-01-10	ABCO-DELISTED	Stock	35.25	35.6	34.5	35.35	475690.0
2017-01-10	ABDC-DELISTED	Stock	12.3	12.47	12.21	12.43	24347.0
2017-01-10	ABE-DELISTED	Stock	11.48	11.48	11.4	11.4081	15925.0
2017-01-10	ABEO	Stock	153.75	153.75	141.25	145.0	13576.0
2017-01-10	ABEV	Stock	5.16	5.17	5.06	5.06	13985600.0
2017-01-10	ABG	Stock	62.2	63.95	62.1	63.45	234100.0
2017-01-10	ABIL-DELISTED	Stock	3.36	3.42	3.34	3.4	17968.0
2017-01-10	ABM	Stock	39.46	39.96	39.33	39.57	320600.0
2017-01-10	ABMD-DELISTED	Stock	112.48	114.71	110.0	112.24	710108.0
2017-01-10	ABR	Stock	7.6	7.65	7.58	7.65	61000.0

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

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