PREVIEW / stock_daily / 2017-10-02

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-02.parquet
  size:    214 KB
  rows:    6,459
  symbols: 2,928

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-10-02	AAPL	Stock	38.565	38.6125	38.18	38.4525	74795200.0
2017-10-02	MSFT	Stock	74.71	75.01	74.3	74.61	15304800.0
2017-10-02	NVDA	Stock	4.52	4.5495	4.425	4.475	503480000.0
2017-10-02	AMZN	Stock	48.2	48.3655	47.606	47.9595	48858000.0
2017-10-02	GOOGL	Stock	48.7825	48.887	48.0975	48.3735	30782440.0
2017-10-02	META	Stock	171.39	171.87	168.75	169.47	13392300.0
2017-10-02	TSLA	Stock	22.8347	22.9133	22.3673	22.7687	79302000.0
2017-10-02	TLT	Stock	124.81	125.0	124.24	124.28	7860723.0
2017-10-02	ES	Stock	60.51	60.72	60.28	60.38	1300900.0
2017-10-02	CL	Stock	73.02	73.43	72.9	72.95	2554400.0
2017-10-02	A	Stock	64.29	65.07	64.21	64.87	1693900.0
2017-10-02	AA	Stock	46.43	48.03	46.41	47.65	4043100.0
2017-10-02	AAAP-DELISTED	Stock	68.0	68.0	64.87	65.11	257137.0
2017-10-02	AABA-DELISTED	Stock	66.6	66.98	66.29	66.54	3389515.0
2017-10-02	AAC-DELISTED	Stock	9.95	10.05	9.58	10.0	74738.0
2017-10-02	AACG	Stock	4.74	4.74	4.74	4.74	1100.0
2017-10-02	AAIC-DELISTED	Stock	12.74	12.79	12.67	12.78	457124.0
2017-10-02	AAL	Stock	47.52	47.93	47.22	47.73	4911700.0
2017-10-02	AAM.A-DELISTED	Stock	26.31	26.31	26.14	26.16	11150.0
2017-10-02	AAMC-DELISTED	Stock	23.7059	24.4118	23.7059	24.1176	8361.0
2017-10-02	AAME	Stock	3.25	3.35	3.25	3.3	11100.0
2017-10-02	AAMI	Stock	14.86	14.86	14.64	14.8	582600.0
2017-10-02	AAOI	Stock	64.36	65.75	63.0	64.52	1226700.0
2017-10-02	AAON	Stock	23.0	23.4333	22.8667	23.4333	255300.0
2017-10-02	AAP	Stock	99.58	99.74	98.39	99.36	1517300.0
2017-10-02	AAT	Stock	39.82	40.38	39.66	40.32	180500.0
2017-10-02	AAU-DELISTED	Stock	1.13	1.16	1.1132	1.1301	139453.0
2017-10-02	AAUAF-DELISTED	Stock	1.13	1.16	1.1132	1.1301	146043.0
2017-10-02	AAV-DELISTED	Stock	6.2	6.25	6.15	6.2	115345.0
2017-10-02	AAWW-DELISTED	Stock	65.85	67.35	65.75	67.3	173144.0
2017-10-02	AAXJ	Stock	72.4	72.76	72.38	72.48	1554550.0
2017-10-02	AAXN-DELISTED	Stock	22.77	23.04	22.66	22.905	404839.0
2017-10-02	AB	Stock	24.4	24.4	24.05	24.1	204800.0
2017-10-02	ABAC-DELISTED	Stock	2.33	2.3653	2.2255	2.25	3832.0
2017-10-02	ABAX-DELISTED	Stock	44.95	45.89	44.7	45.85	129450.0
2017-10-02	ABB-DELISTED	Stock	24.84	24.97	24.79	24.96	1324576.0
2017-10-02	ABBNY-DELISTED	Stock	24.84	24.97	24.79	24.96	1367702.0
2017-10-02	ABBV	Stock	89.74	90.41	88.91	90.39	6600100.0
2017-10-02	ABC-DELISTED	Stock	82.97	83.63	82.38	83.3	1623865.0
2017-10-02	ABCB	Stock	48.0	48.8	47.4	48.75	265200.0
2017-10-02	ABCD-DELISTED	Stock	6.59	6.64	6.3	6.49	74319.0
2017-10-02	ABCO-DELISTED	Stock	53.6	53.85	53.6	53.825	733283.0
2017-10-02	ABDC-DELISTED	Stock	10.71	10.778	10.41	10.52	118010.0
2017-10-02	ABE-DELISTED	Stock	13.793	14.11	13.793	13.94	9817.0
2017-10-02	ABEO	Stock	418.75	447.25	415.0	443.75	25260.0
2017-10-02	ABEOW-DELISTED	Stock	13.1274	13.1274	12.65	12.734	3600.0
2017-10-02	ABEV	Stock	6.51	6.54	6.45	6.51	33704300.0
2017-10-02	ABG	Stock	61.15	62.0	60.65	61.9	248900.0
2017-10-02	ABIL-DELISTED	Stock	0.8258	0.8299	0.754	0.7715	164720.0
2017-10-02	ABM	Stock	41.72	42.41	41.62	42.38	351000.0

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

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