PREVIEW / stock_daily / 2017-11-21

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-21.parquet
  size:    217 KB
  rows:    6,524
  symbols: 2,937

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-11-21	AAPL	Stock	42.695	43.425	42.695	43.285	100525200.0
2017-11-21	MSFT	Stock	82.74	83.84	82.74	83.72	21237500.0
2017-11-21	NVDA	Stock	5.3923	5.413	5.36	5.4013	399176000.0
2017-11-21	AMZN	Stock	56.643	57.0	56.41	56.9745	49588000.0
2017-11-21	GOOGL	Stock	52.002	52.5195	51.957	52.515	22206820.0
2017-11-21	META	Stock	179.15	181.89	178.99	181.86	14504000.0
2017-11-21	TSLA	Stock	20.724	21.2153	20.5807	21.1873	108919500.0
2017-11-21	TLT	Stock	127.09	127.29	126.31	126.74	5818422.0
2017-11-21	ES	Stock	63.87	64.19	63.82	63.93	1302300.0
2017-11-21	CL	Stock	72.23	72.72	72.09	72.22	2831900.0
2017-11-21	A	Stock	70.05	70.81	67.7	69.91	5330000.0
2017-11-21	AA	Stock	42.73	42.73	40.22	41.39	6260000.0
2017-11-21	AAAP-DELISTED	Stock	81.12	81.25	81.12	81.18	511440.0
2017-11-21	AABA-DELISTED	Stock	72.66	73.14	72.31	72.86	7918846.0
2017-11-21	AAC-DELISTED	Stock	8.99	9.49	8.99	9.1	140617.0
2017-11-21	AACG	Stock	4.5	4.5	4.41	4.41	3200.0
2017-11-21	AAIC-DELISTED	Stock	11.65	11.7701	11.64	11.72	364268.0
2017-11-21	AAL	Stock	47.89	48.92	47.54	48.65	2796200.0
2017-11-21	AAM.A-DELISTED	Stock	26.36	26.42	26.28	26.31	43523.0
2017-11-21	AAME	Stock	3.75	3.8	3.6	3.6	1400.0
2017-11-21	AAMI	Stock	15.93	16.11	15.85	16.0	430600.0
2017-11-21	AAOI	Stock	43.15	43.87	42.31	42.9	1619400.0
2017-11-21	AAON	Stock	23.3667	23.9333	23.3333	23.8667	343800.0
2017-11-21	AAP	Stock	90.94	90.95	88.9	88.93	1610700.0
2017-11-21	AAT	Stock	39.46	39.55	39.18	39.3	360400.0
2017-11-21	AAU-DELISTED	Stock	0.8951	0.92	0.8947	0.8964	180733.0
2017-11-21	AAUAF-DELISTED	Stock	0.8951	0.92	0.89	0.89	184956.0
2017-11-21	AAV-DELISTED	Stock	5.0	5.1	4.9	4.9	120806.0
2017-11-21	AAWW-DELISTED	Stock	53.35	55.3	53.25	55.15	197954.0
2017-11-21	AAXJ	Stock	78.1	78.44	78.0	78.28	1380993.0
2017-11-21	AAXN-DELISTED	Stock	23.74	23.88	23.265	23.85	991828.0
2017-11-21	AB	Stock	25.85	25.95	25.5	25.65	173100.0
2017-11-21	ABAC-DELISTED	Stock	3.22	3.22	3.14	3.14	3440.0
2017-11-21	ABAX-DELISTED	Stock	49.76	50.55	48.12	50.32	86580.0
2017-11-21	ABB-DELISTED	Stock	25.59	25.7399	25.465	25.55	1350503.0
2017-11-21	ABBNY-DELISTED	Stock	25.59	25.7399	25.465	25.55	1408020.0
2017-11-21	ABBV	Stock	93.7	95.4	93.6	94.68	4346200.0
2017-11-21	ABC-DELISTED	Stock	77.83	79.57	77.5677	79.46	1363835.0
2017-11-21	ABCB	Stock	47.9	48.95	47.7	48.95	481300.0
2017-11-21	ABCD-DELISTED	Stock	5.97	6.05	5.85	5.88	55902.0
2017-11-21	ABDC-DELISTED	Stock	7.73	7.9	7.7028	7.76	93523.0
2017-11-21	ABE-DELISTED	Stock	14.21	14.3999	14.21	14.35	2981.0
2017-11-21	ABEO	Stock	373.75	410.0	373.75	403.75	37404.0
2017-11-21	ABEOW-DELISTED	Stock	11.21	11.21	11.21	11.21	100.0
2017-11-21	ABEV	Stock	6.29	6.39	6.29	6.35	38503000.0
2017-11-21	ABG	Stock	61.75	63.8	61.35	63.75	206100.0
2017-11-21	ABIL-DELISTED	Stock	0.5251	0.53	0.51	0.517	74900.0
2017-11-21	ABLX-DELISTED	Stock	22.79	23.56	22.75	23.5	572221.0
2017-11-21	ABM	Stock	40.0	40.74	39.55	40.68	338900.0
2017-11-21	ABMD-DELISTED	Stock	197.22	199.61	196.31	199.54	279460.0

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

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