PREVIEW / stock_daily / 2017-09-28

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-28.parquet
  size:    214 KB
  rows:    6,428
  symbols: 2,919

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-09-28	AAPL	Stock	38.4725	38.57	38.175	38.32	88022000.0
2017-09-28	MSFT	Stock	73.54	73.97	73.31	73.87	10883800.0
2017-09-28	NVDA	Stock	4.4005	4.4045	4.344	4.392	435244000.0
2017-09-28	AMZN	Stock	47.593	47.985	47.505	47.82	50452000.0
2017-09-28	GOOGL	Stock	47.8125	48.309	47.7775	48.2405	28018620.0
2017-09-28	META	Stock	167.94	169.07	167.16	168.73	12178700.0
2017-09-28	TSLA	Stock	22.6587	22.85	22.36	22.64	79794000.0
2017-09-28	TLT	Stock	124.21	124.65	123.97	124.48	8883733.0
2017-09-28	ES	Stock	60.48	60.94	60.01	60.57	2710200.0
2017-09-28	CL	Stock	72.97	73.41	72.85	73.15	2956800.0
2017-09-28	A	Stock	64.25	64.62	63.97	63.98	1126200.0
2017-09-28	AA	Stock	45.07	46.46	44.81	46.08	5282200.0
2017-09-28	AAAP-DELISTED	Stock	65.5	67.37	63.61	65.11	2717634.0
2017-09-28	AABA-DELISTED	Stock	65.9	66.19	65.54	65.5803	6354554.0
2017-09-28	AAC-DELISTED	Stock	10.23	10.35	10.12	10.25	72790.0
2017-09-28	AACG	Stock	4.83	4.83	4.75	4.75	2400.0
2017-09-28	AAIC-DELISTED	Stock	12.74	12.78	12.4282	12.74	759149.0
2017-09-28	AAL	Stock	46.78	48.6	46.78	47.49	8367800.0
2017-09-28	AAM.A-DELISTED	Stock	26.01	26.15	26.01	26.09	18609.0
2017-09-28	AAMC-DELISTED	Stock	25.2353	25.2353	24.9853	24.9853	4325.0
2017-09-28	AAME	Stock	3.2	3.2	3.2	3.2	1400.0
2017-09-28	AAMI	Stock	14.52	14.765	14.41	14.64	523400.0
2017-09-28	AAOI	Stock	64.36	65.34	63.45	64.21	1216600.0
2017-09-28	AAON	Stock	23.3	23.3533	22.9667	23.2333	167250.0
2017-09-28	AAP	Stock	99.26	99.92	98.91	99.5	1132800.0
2017-09-28	AAT	Stock	39.76	40.14	39.43	40.08	184800.0
2017-09-28	AAU-DELISTED	Stock	1.18	1.1901	1.13	1.17	222801.0
2017-09-28	AAUAF-DELISTED	Stock	1.18	1.1901	1.13	1.17	268791.0
2017-09-28	AAV-DELISTED	Stock	6.45	6.525	6.35	6.4	30806.0
2017-09-28	AAWW-DELISTED	Stock	66.2	67.3	65.4	67.25	151899.0
2017-09-28	AAXJ	Stock	71.18	71.52	71.04	71.44	2466489.0
2017-09-28	AAXN-DELISTED	Stock	23.1	23.49	22.89	23.08	475272.0
2017-09-28	AB	Stock	24.35	24.5	24.3	24.35	152800.0
2017-09-28	ABAC-DELISTED	Stock	2.19	2.3	2.19	2.28	3992.0
2017-09-28	ABAX-DELISTED	Stock	44.77	45.0	44.105	44.29	62139.0
2017-09-28	ABB-DELISTED	Stock	24.52	24.71	24.51	24.68	969703.0
2017-09-28	ABBNY-DELISTED	Stock	24.52	24.71	24.51	24.68	1115717.0
2017-09-28	ABBV	Stock	86.67	90.95	86.38	88.96	14809300.0
2017-09-28	ABC-DELISTED	Stock	81.85	81.88	80.27	80.99	945088.0
2017-09-28	ABCB	Stock	47.5	48.55	47.15	47.9	425600.0
2017-09-28	ABCD-DELISTED	Stock	6.6	6.65	6.54	6.61	41277.0
2017-09-28	ABCO-DELISTED	Stock	53.65	53.875	53.65	53.75	623835.0
2017-09-28	ABDC-DELISTED	Stock	10.78	10.79	10.44	10.59	121257.0
2017-09-28	ABE-DELISTED	Stock	13.771	13.771	13.771	13.771	400.0
2017-09-28	ABEO	Stock	385.0	435.0	385.0	423.75	65356.0
2017-09-28	ABEOW-DELISTED	Stock	11.0	12.21	11.0	11.91	10400.0
2017-09-28	ABEV	Stock	6.57	6.61	6.54	6.56	13502500.0
2017-09-28	ABG	Stock	61.35	61.75	60.25	61.45	136000.0
2017-09-28	ABIL-DELISTED	Stock	0.7715	0.795	0.7118	0.7145	223654.0
2017-09-28	ABM	Stock	41.01	41.65	40.75	41.54	233400.0

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

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