PREVIEW / stock_daily / 2017-11-09

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-09.parquet
  size:    215 KB
  rows:    6,444
  symbols: 2,896

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-09	AAPL	Stock	43.7775	44.025	43.285	43.97	117930400.0
2017-11-09	MSFT	Stock	84.11	84.27	82.9	84.09	21178400.0
2017-11-09	NVDA	Stock	5.1318	5.1583	5.0093	5.133	978564000.0
2017-11-09	AMZN	Stock	56.298	56.481	55.7885	56.4565	74654000.0
2017-11-09	GOOGL	Stock	52.4	52.544	51.7925	52.386	35891500.0
2017-11-09	META	Stock	178.31	179.4	177.09	179.3	12610300.0
2017-11-09	TSLA	Stock	20.1667	20.2973	19.7533	20.1993	81706500.0
2017-11-09	TLT	Stock	125.87	126.24	125.55	126.0	6280364.0
2017-11-09	ES	Stock	64.54	64.87	64.36	64.68	1301000.0
2017-11-09	CL	Stock	72.96	73.38	72.52	72.91	4411400.0
2017-11-09	A	Stock	67.92	67.98	66.91	67.47	1665000.0
2017-11-09	AA	Stock	44.71	44.71	43.11	43.33	7673600.0
2017-11-09	AAAP-DELISTED	Stock	80.9	81.0	80.9	81.0	933937.0
2017-11-09	AABA-DELISTED	Stock	70.46	70.68	68.77	70.22	9360343.0
2017-11-09	AAC-DELISTED	Stock	11.02	11.34	10.7203	10.885	128796.0
2017-11-09	AACG	Stock	4.35	4.46	4.31	4.31	2100.0
2017-11-09	AAIC-DELISTED	Stock	11.08	11.2201	11.06	11.16	335413.0
2017-11-09	AAL	Stock	45.85	46.35	45.36	45.77	3561500.0
2017-11-09	AAM.A-DELISTED	Stock	26.44	26.4682	26.32	26.4	11264.0
2017-11-09	AAMC-DELISTED	Stock	24.7206	24.7206	24.7206	24.7206	340.0
2017-11-09	AAME	Stock	3.5	3.5	3.5	3.5	600.0
2017-11-09	AAMI	Stock	15.41	15.57	15.3	15.55	533100.0
2017-11-09	AAOI	Stock	43.0	44.24	41.344	43.2	2868200.0
2017-11-09	AAON	Stock	22.7667	23.0	22.2	22.2333	227100.0
2017-11-09	AAP	Stock	79.56	81.09	79.14	80.45	1898500.0
2017-11-09	AAT	Stock	38.86	39.83	38.86	39.42	431800.0
2017-11-09	AAU-DELISTED	Stock	0.94	0.97	0.9177	0.9455	349334.0
2017-11-09	AAUAF-DELISTED	Stock	0.94	0.97	0.9177	0.9455	362074.0
2017-11-09	AAV-DELISTED	Stock	5.65	5.79	5.605	5.7	135564.0
2017-11-09	AAWW-DELISTED	Stock	56.6	56.85	54.6	54.75	368373.0
2017-11-09	AAXJ	Stock	76.04	76.2	75.58	76.11	1261567.0
2017-11-09	AAXN-DELISTED	Stock	21.31	22.38	20.92	21.54	1067259.0
2017-11-09	AB	Stock	24.75	24.85	24.5	24.8	206400.0
2017-11-09	ABAC-DELISTED	Stock	3.49	3.6952	3.39	3.55	28174.0
2017-11-09	ABAX-DELISTED	Stock	45.49	46.48	45.0	46.12	67670.0
2017-11-09	ABB-DELISTED	Stock	25.62	25.74	25.58	25.74	1612171.0
2017-11-09	ABBNY-DELISTED	Stock	25.62	25.74	25.58	25.74	2542307.0
2017-11-09	ABBV	Stock	95.29	96.37	95.26	95.89	5187000.0
2017-11-09	ABC-DELISTED	Stock	75.07	76.63	74.9	75.27	2270353.0
2017-11-09	ABCB	Stock	46.15	46.55	45.3	45.75	101400.0
2017-11-09	ABCD-DELISTED	Stock	6.07	6.28	6.07	6.23	36204.0
2017-11-09	ABCO-DELISTED	Stock	53.2	53.35	52.8	52.85	1703844.0
2017-11-09	ABDC-DELISTED	Stock	7.65	7.708	7.175	7.27	446073.0
2017-11-09	ABE-DELISTED	Stock	14.33	14.3737	14.28	14.32	18412.0
2017-11-09	ABEO	Stock	372.5	380.75	362.5	370.0	34296.0
2017-11-09	ABEOW-DELISTED	Stock	9.98	9.98	9.98	9.98	100.0
2017-11-09	ABEV	Stock	6.12	6.19	6.09	6.17	15023800.0
2017-11-09	ABG	Stock	60.5	61.5	59.95	60.8	115800.0
2017-11-09	ABIL-DELISTED	Stock	0.6031	0.6107	0.5868	0.597	64299.0
2017-11-09	ABLX-DELISTED	Stock	20.74	20.91	20.5	20.75	166384.0

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

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