PREVIEW / stock_daily / 2016-07-06

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-06.parquet
  size:    217 KB
  rows:    6,530
  symbols: 3,240

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-06	AAPL	Stock	23.65	23.915	23.5925	23.8825	123796400.0
2016-07-06	MSFT	Stock	50.78	51.54	50.39	51.38	28167500.0
2016-07-06	NVDA	Stock	1.1755	1.1982	1.1695	1.1912	273104000.0
2016-07-06	AMZN	Stock	36.2855	36.8885	36.129	36.8805	78764000.0
2016-07-06	GOOGL	Stock	34.992	35.65	34.95	35.4485	28902520.0
2016-07-06	META	Stock	113.36	116.79	112.97	116.7	24337600.0
2016-07-06	TSLA	Stock	14.0	14.3487	13.9333	14.296	73798500.0
2016-07-06	TLT	Stock	142.79	143.0	141.96	142.56	14352847.0
2016-07-06	ES	Stock	60.3	60.44	59.68	60.24	1425900.0
2016-07-06	CL	Stock	73.32	73.45	72.78	73.28	2568600.0
2016-07-06	A	Stock	43.65	44.55	43.36	44.47	2312100.0
2016-07-06	AA.B-DELISTED	Stock	33.04	33.04	32.3	32.66	32606.0
2016-07-06	AAAP-DELISTED	Stock	31.0	31.0	29.99	30.2	19026.0
2016-07-06	AABA-DELISTED	Stock	37.43	37.56	37.13	37.505	7700914.0
2016-07-06	AAC-DELISTED	Stock	22.24	22.4	21.5412	22.29	124710.0
2016-07-06	AACG	Stock	4.53	4.55	4.1	4.4	9100.0
2016-07-06	AAIC-DELISTED	Stock	12.68	12.92	12.63	12.81	230666.0
2016-07-06	AAL	Stock	27.76	28.4	27.12	28.35	18757500.0
2016-07-06	AAMC-DELISTED	Stock	4.0235	4.1676	3.8265	4.0324	29944.0
2016-07-06	AAME	Stock	3.8	4.09	3.8	4.09	1300.0
2016-07-06	AAMI	Stock	12.9	12.99	12.75	12.87	162800.0
2016-07-06	AAOI	Stock	10.44	11.005	10.34	10.77	294000.0
2016-07-06	AAON	Stock	17.9733	18.06	17.6667	18.04	138750.0
2016-07-06	AAP	Stock	161.06	161.94	160.4	161.45	1162000.0
2016-07-06	AAT	Stock	43.14	43.71	42.89	42.94	169500.0
2016-07-06	AAU-DELISTED	Stock	1.62	1.65	1.48	1.54	1225255.0
2016-07-06	AAUAF-DELISTED	Stock	1.62	1.65	1.48	1.54	1272694.0
2016-07-06	AAV-DELISTED	Stock	5.38	5.74	5.38	5.72	87794.0
2016-07-06	AAWW-DELISTED	Stock	39.43	40.1	39.13	39.69	214904.0
2016-07-06	AAXJ	Stock	53.65	54.23	53.42	54.23	660368.0
2016-07-06	AAXN-DELISTED	Stock	25.57	25.59	24.952	25.04	1233494.0
2016-07-06	AB	Stock	22.53	23.0	22.45	22.83	196600.0
2016-07-06	ABAC-DELISTED	Stock	0.8255	0.8255	0.8019	0.8019	1410.0
2016-07-06	ABAX-DELISTED	Stock	47.8	48.71	47.42	48.65	103166.0
2016-07-06	ABB-DELISTED	Stock	19.14	19.36	19.02	19.34	1707070.0
2016-07-06	ABBNY-DELISTED	Stock	19.16	19.36	19.02	19.34	2143819.0
2016-07-06	ABBV	Stock	61.84	63.76	61.8	63.37	9202200.0
2016-07-06	ABC-DELISTED	Stock	79.94	81.55	79.595	81.21	2069537.0
2016-07-06	ABCB	Stock	28.95	29.28	28.9	29.12	114400.0
2016-07-06	ABCD-DELISTED	Stock	4.43	4.54	4.43	4.54	45467.0
2016-07-06	ABCO-DELISTED	Stock	34.86	35.855	34.48	35.72	210526.0
2016-07-06	ABDC-DELISTED	Stock	12.2	12.26	12.15	12.2	78000.0
2016-07-06	ABE-DELISTED	Stock	12.39	12.39	12.07	12.1552	2519.0
2016-07-06	ABEO	Stock	60.5	61.0	58.0	58.5	956.0
2016-07-06	ABEOW-DELISTED	Stock	0.9	1.06	0.9	1.05	2300.0
2016-07-06	ABEV	Stock	5.77	5.78	5.67	5.75	8244000.0
2016-07-06	ABG	Stock	50.37	51.69	49.71	51.45	196200.0
2016-07-06	ABIL-DELISTED	Stock	4.01	4.01	3.8	3.8799	64596.0
2016-07-06	ABM	Stock	36.34	36.6	36.2	36.42	176800.0
2016-07-06	ABMD-DELISTED	Stock	109.46	111.55	109.46	111.54	725321.0

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

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