PREVIEW / stock_daily / 2016-07-01

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-01.parquet
  size:    218 KB
  rows:    6,509
  symbols: 3,239

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
2016-07-01	AAPL	Stock	23.8725	24.1175	23.8325	23.9725	104106000.0
2016-07-01	MSFT	Stock	51.13	51.72	51.07	51.16	21400400.0
2016-07-01	NVDA	Stock	1.1688	1.184	1.1625	1.1665	218488000.0
2016-07-01	AMZN	Stock	35.866	36.4	35.827	36.284	58408000.0
2016-07-01	GOOGL	Stock	35.255	35.6265	35.1865	35.5125	30983200.0
2016-07-01	META	Stock	114.2	115.13	113.81	114.19	14980000.0
2016-07-01	TSLA	Stock	13.7427	14.5493	13.7333	14.4333	81000000.0
2016-07-01	TLT	Stock	140.81	140.82	139.19	140.57	15430178.0
2016-07-01	ES	Stock	60.08	60.08	59.12	59.71	1631600.0
2016-07-01	CL	Stock	73.2	73.42	72.86	72.95	2652600.0
2016-07-01	A	Stock	44.36	44.8	44.31	44.6	1591500.0
2016-07-01	AA.B-DELISTED	Stock	33.4	33.74	32.53	33.6001	45837.0
2016-07-01	AAAP-DELISTED	Stock	30.0	30.89	29.69	30.89	33792.0
2016-07-01	AABA-DELISTED	Stock	37.56	38.08	37.43	37.99	10328701.0
2016-07-01	AAC-DELISTED	Stock	22.32	23.31	22.32	22.71	157200.0
2016-07-01	AACG	Stock	4.61	4.61	4.61	4.61	500.0
2016-07-01	AAIC-DELISTED	Stock	13.0	13.1156	12.82	12.93	293882.0
2016-07-01	AAL	Stock	28.26	29.52	28.2	29.33	13250000.0
2016-07-01	AAMC-DELISTED	Stock	4.2941	4.4971	4.2941	4.3506	31501.0
2016-07-01	AAME	Stock	3.87	4.0	3.87	3.93	3700.0
2016-07-01	AAMI	Stock	13.33	13.59	13.16	13.19	193600.0
2016-07-01	AAOI	Stock	11.1	11.5	10.96	11.22	196300.0
2016-07-01	AAON	Stock	18.4	18.56	18.1067	18.16	168750.0
2016-07-01	AAP	Stock	162.16	164.7	161.78	164.33	876500.0
2016-07-01	AAT	Stock	42.67	42.67	42.3	42.53	104400.0
2016-07-01	AAU-DELISTED	Stock	1.78	1.83	1.61	1.65	1024038.0
2016-07-01	AAUAF-DELISTED	Stock	1.78	1.83	1.61	1.66	1082068.0
2016-07-01	AAV-DELISTED	Stock	5.57	5.68	5.57	5.66	14748.0
2016-07-01	AAWW-DELISTED	Stock	41.64	42.07	40.85	41.26	123230.0
2016-07-01	AAXJ	Stock	55.2	55.29	55.02	55.12	489962.0
2016-07-01	AAXN-DELISTED	Stock	25.0	25.0	24.65	24.89	570483.0
2016-07-01	AB	Stock	23.3	23.51	23.08	23.17	101900.0
2016-07-01	ABAC-DELISTED	Stock	0.79	0.85	0.79	0.85	6954.0
2016-07-01	ABAX-DELISTED	Stock	47.18	48.39	47.18	48.38	92918.0
2016-07-01	ABB-DELISTED	Stock	19.86	19.95	19.84	19.915	1469653.0
2016-07-01	ABBNY-DELISTED	Stock	19.86	19.95	19.84	19.91	1714576.0
2016-07-01	ABBV	Stock	61.98	63.22	61.83	62.71	6533700.0
2016-07-01	ABC-DELISTED	Stock	79.29	80.4299	79.1095	80.12	2451029.0
2016-07-01	ABCB	Stock	29.55	29.75	29.25	29.45	180200.0
2016-07-01	ABCD-DELISTED	Stock	4.48	4.55	4.48	4.5	11896.0
2016-07-01	ABCO-DELISTED	Stock	35.28	35.7	34.65	35.05	311948.0
2016-07-01	ABDC-DELISTED	Stock	12.16	12.25	12.1	12.19	54975.0
2016-07-01	ABE-DELISTED	Stock	12.14	12.2302	12.14	12.22	1042.0
2016-07-01	ABEO	Stock	59.0	61.25	59.0	60.75	1980.0
2016-07-01	ABEV	Stock	5.94	5.95	5.87	5.91	10219100.0
2016-07-01	ABG	Stock	52.9	55.34	52.9	54.1	198000.0
2016-07-01	ABIL-DELISTED	Stock	4.06	4.21	3.98	4.19	41574.0
2016-07-01	ABM	Stock	36.49	36.68	36.26	36.33	185200.0
2016-07-01	ABMD-DELISTED	Stock	109.71	110.2	108.89	110.17	304904.0
2016-07-01	ABR	Stock	7.17	7.2	7.06	7.09	64700.0

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

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