PREVIEW / stock_daily / 2016-06-07

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-07.parquet
  size:    219 KB
  rows:    6,583
  symbols: 3,297

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-06-07	AAPL	Stock	24.8125	24.9675	24.74	24.7575	89638000.0
2016-06-07	MSFT	Stock	52.24	52.73	52.1	52.1	20866800.0
2016-06-07	NVDA	Stock	1.163	1.1695	1.1578	1.1582	193400000.0
2016-06-07	AMZN	Stock	36.4945	36.5	36.0275	36.187	54650000.0
2016-06-07	GOOGL	Stock	36.6635	36.8355	36.54	36.5545	24314820.0
2016-06-07	META	Stock	119.24	119.3	117.67	117.76	17103000.0
2016-06-07	TSLA	Stock	14.816	15.6293	14.768	15.4893	93204000.0
2016-06-07	TLT	Stock	132.64	132.98	132.54	132.56	4680203.0
2016-06-07	ES	Stock	55.88	56.21	55.6	55.7	1132600.0
2016-06-07	CL	Stock	71.9	72.02	71.47	71.59	2103300.0
2016-06-07	A	Stock	45.81	45.95	45.61	45.75	1500400.0
2016-06-07	AA.B-DELISTED	Stock	34.66	34.66	34.32	34.38	100539.0
2016-06-07	AAAP-DELISTED	Stock	30.25	31.96	30.25	31.69	151158.0
2016-06-07	AABA-DELISTED	Stock	36.9	36.99	36.625	36.745	13664185.0
2016-06-07	AAC-DELISTED	Stock	21.71	22.48	21.6	22.27	118997.0
2016-06-07	AACG	Stock	5.36	5.7	5.17	5.29	45000.0
2016-06-07	AAIC-DELISTED	Stock	14.01	14.035	13.82	13.9	270960.0
2016-06-07	AAL	Stock	31.46	32.87	31.1	32.36	12424200.0
2016-06-07	AAMC-DELISTED	Stock	7.5588	7.7559	6.2118	6.5765	334563.0
2016-06-07	AAME	Stock	3.59	3.59	3.51	3.54	2200.0
2016-06-07	AAMI	Stock	14.84	14.99	14.69	14.83	199100.0
2016-06-07	AAOI	Stock	11.36	11.64	11.25	11.41	258100.0
2016-06-07	AAON	Stock	18.32	18.5067	18.2333	18.32	142950.0
2016-06-07	AAP	Stock	150.32	152.06	149.45	151.71	1136000.0
2016-06-07	AAT	Stock	41.05	41.6	40.18	41.42	175500.0
2016-06-07	AAU-DELISTED	Stock	1.12	1.18	1.12	1.13	542132.0
2016-06-07	AAUAF-DELISTED	Stock	1.12	1.18	1.12	1.14	543461.0
2016-06-07	AAV-DELISTED	Stock	6.16	6.2	6.13	6.15	98280.0
2016-06-07	AAWW-DELISTED	Stock	45.1	46.6	44.71	45.99	344822.0
2016-06-07	AAXJ	Stock	55.01	55.21	55.01	55.11	593320.0
2016-06-07	AAXN-DELISTED	Stock	23.0	23.31	22.88	23.08	582142.0
2016-06-07	AB	Stock	23.73	24.12	23.56	23.61	234000.0
2016-06-07	ABAC-DELISTED	Stock	0.754	0.754	0.68	0.7294	37573.0
2016-06-07	ABAX-DELISTED	Stock	46.29	46.45	45.94	45.99	91888.0
2016-06-07	ABB-DELISTED	Stock	21.5	21.56	21.47	21.47	1355351.0
2016-06-07	ABBNY-DELISTED	Stock	21.5	21.56	21.47	21.47	1773162.0
2016-06-07	ABBV	Stock	62.59	63.59	62.3	63.1	10980100.0
2016-06-07	ABC-DELISTED	Stock	76.39	76.54	75.92	76.235	1490623.0
2016-06-07	ABCB	Stock	32.0	32.01	31.68	31.71	67200.0
2016-06-07	ABCD-DELISTED	Stock	4.65	4.66	4.6	4.6	5708.0
2016-06-07	ABCO-DELISTED	Stock	33.89	34.36	33.51	33.92	332033.0
2016-06-07	ABDC-DELISTED	Stock	12.37	12.38	12.15	12.25	21315.0
2016-06-07	ABE-DELISTED	Stock	12.48	12.73	12.48	12.61	10028.0
2016-06-07	ABEO	Stock	78.25	80.0	75.0	77.0	1492.0
2016-06-07	ABEOW-DELISTED	Stock	1.05	1.05	1.05	1.05	5500.0
2016-06-07	ABEV	Stock	5.49	5.53	5.47	5.5	10215100.0
2016-06-07	ABG	Stock	55.61	57.13	55.61	57.01	251500.0
2016-06-07	ABIL-DELISTED	Stock	3.73	3.89	3.66	3.6625	35985.0
2016-06-07	ABM	Stock	34.11	34.36	34.04	34.24	188300.0
2016-06-07	ABMD-DELISTED	Stock	101.92	104.95	101.63	104.31	498884.0

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

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