PREVIEW / stock_daily / 2017-08-08

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-08.parquet
  size:    214 KB
  rows:    6,452
  symbols: 2,963

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-08-08	AAPL	Stock	39.65	40.4575	39.5675	40.02	144823600.0
2017-08-08	MSFT	Stock	72.09	73.13	71.75	72.79	22044600.0
2017-08-08	NVDA	Stock	4.3472	4.364	4.2178	4.2575	755336000.0
2017-08-08	AMZN	Stock	49.7175	49.814	49.2895	49.492	58056000.0
2017-08-08	GOOGL	Stock	47.2145	47.6245	47.124	47.2095	30101280.0
2017-08-08	META	Stock	171.88	173.05	170.62	171.23	14393500.0
2017-08-08	TSLA	Stock	23.8353	24.572	23.8267	24.348	111747000.0
2017-08-08	TLT	Stock	124.87	124.98	124.15	124.62	6197386.0
2017-08-08	ES	Stock	61.95	62.35	61.77	62.31	1030300.0
2017-08-08	CL	Stock	71.72	72.08	71.54	71.7	1909000.0
2017-08-08	A	Stock	60.67	60.98	60.08	60.14	1162300.0
2017-08-08	AA	Stock	38.5	40.362	38.36	39.58	8781800.0
2017-08-08	AAAP-DELISTED	Stock	49.0	49.63	48.255	48.62	41594.0
2017-08-08	AABA-DELISTED	Stock	59.77	60.44	59.62	59.8	3897838.0
2017-08-08	AAC-DELISTED	Stock	8.11	8.55	8.11	8.28	133614.0
2017-08-08	AACG	Stock	4.7	4.79	4.65	4.79	9200.0
2017-08-08	AAIC-DELISTED	Stock	13.12	13.174	13.07	13.12	345577.0
2017-08-08	AAL	Stock	50.68	50.78	49.89	50.0	4274400.0
2017-08-08	AAM.A-DELISTED	Stock	26.08	26.28	26.06	26.2	26527.0
2017-08-08	AAMC-DELISTED	Stock	24.7059	25.4676	23.8235	25.3676	21498.0
2017-08-08	AAME	Stock	3.51	3.55	3.51	3.55	1600.0
2017-08-08	AAMI	Stock	14.2	14.32	14.07	14.26	904400.0
2017-08-08	AAOI	Stock	71.75	74.43	70.1	71.2	6353400.0
2017-08-08	AAON	Stock	23.2333	23.4333	23.0667	23.2667	264000.0
2017-08-08	AAP	Stock	109.51	110.81	108.29	109.39	863600.0
2017-08-08	AAT	Stock	40.19	40.55	39.64	39.92	189000.0
2017-08-08	AAU-DELISTED	Stock	1.09	1.12	1.09	1.1	192019.0
2017-08-08	AAUAF-DELISTED	Stock	1.09	1.12	1.09	1.1	199293.0
2017-08-08	AAV-DELISTED	Stock	6.4	6.65	6.4	6.65	94385.0
2017-08-08	AAWW-DELISTED	Stock	65.55	65.55	63.95	63.95	332341.0
2017-08-08	AAXJ	Stock	71.62	71.96	71.44	71.61	895356.0
2017-08-08	AAXN-DELISTED	Stock	25.77	26.31	25.29	25.31	897767.0
2017-08-08	AB	Stock	24.65	24.85	24.56	24.7	298800.0
2017-08-08	ABAC-DELISTED	Stock	2.36	2.3618	2.18	2.2337	45331.0
2017-08-08	ABAX-DELISTED	Stock	46.4	47.21	46.02	46.67	33749.0
2017-08-08	ABB-DELISTED	Stock	23.47	23.52	23.265	23.3	850254.0
2017-08-08	ABBNY-DELISTED	Stock	23.47	23.52	23.265	23.31	1712657.0
2017-08-08	ABBV	Stock	71.33	71.91	71.01	71.47	4398000.0
2017-08-08	ABC-DELISTED	Stock	80.91	82.3399	80.13	80.33	1441835.0
2017-08-08	ABCB	Stock	45.15	46.3	45.0	45.65	97800.0
2017-08-08	ABCD-DELISTED	Stock	4.77	4.9	4.77	4.86	26557.0
2017-08-08	ABCO-DELISTED	Stock	53.4	53.45	51.8	52.0	677182.0
2017-08-08	ABDC-DELISTED	Stock	11.03	11.03	10.39	10.48	142071.0
2017-08-08	ABE-DELISTED	Stock	13.93	14.24	13.93	14.13	4708.0
2017-08-08	ABEO	Stock	206.25	208.5	190.0	192.5	17784.0
2017-08-08	ABEOW-DELISTED	Stock	4.253	4.253	4.253	4.253	100.0
2017-08-08	ABEV	Stock	6.15	6.22	6.12	6.16	21108300.0
2017-08-08	ABG	Stock	54.25	54.75	52.8	52.95	116900.0
2017-08-08	ABIL-DELISTED	Stock	0.599	0.599	0.5792	0.59	40331.0
2017-08-08	ABM	Stock	44.54	45.12	44.24	44.51	272600.0

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

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