PREVIEW / stock_daily / 2016-06-01

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-01.parquet
  size:    219 KB
  rows:    6,563
  symbols: 3,288

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-01	AAPL	Stock	24.755	24.885	24.5825	24.615	116693200.0
2016-06-01	MSFT	Stock	52.44	52.95	52.44	52.85	25324800.0
2016-06-01	NVDA	Stock	1.1625	1.1815	1.159	1.1702	387132000.0
2016-06-01	AMZN	Stock	36.045	36.3215	35.911	35.972	65262000.0
2016-06-01	GOOGL	Stock	37.4235	37.5685	37.217	37.423	20796940.0
2016-06-01	META	Stock	118.5	119.08	117.82	118.78	15029500.0
2016-06-01	TSLA	Stock	14.7653	14.8267	14.4593	14.6373	44740500.0
2016-06-01	TLT	Stock	130.63	131.27	130.11	130.42	9874878.0
2016-06-01	ES	Stock	55.17	55.53	55.07	55.52	2421600.0
2016-06-01	CL	Stock	70.41	71.22	70.17	71.2	3017800.0
2016-06-01	A	Stock	45.75	46.1	45.45	45.95	1733600.0
2016-06-01	AA.B-DELISTED	Stock	33.0	33.01	32.415	33.01	45915.0
2016-06-01	AAAP-DELISTED	Stock	29.8	30.3876	28.811	29.47	62239.0
2016-06-01	AABA-DELISTED	Stock	37.25	37.735	36.56	36.64	21144372.0
2016-06-01	AAC-DELISTED	Stock	21.08	22.21	21.08	22.2089	223309.0
2016-06-01	AACG	Stock	4.93	5.05	4.91	5.05	1800.0
2016-06-01	AAIC-DELISTED	Stock	13.23	13.56	13.2	13.55	289663.0
2016-06-01	AAL	Stock	31.94	32.26	31.73	31.95	6415500.0
2016-06-01	AAMC-DELISTED	Stock	5.5088	5.9971	5.3441	5.7353	90505.0
2016-06-01	AAME	Stock	3.61	3.76	3.44	3.65	4200.0
2016-06-01	AAMI	Stock	15.04	15.21	14.8	15.17	118400.0
2016-06-01	AAOI	Stock	10.5	10.7	10.28	10.47	666300.0
2016-06-01	AAON	Stock	18.2733	18.78	18.1533	18.6933	197550.0
2016-06-01	AAP	Stock	153.84	153.89	151.93	153.34	1373700.0
2016-06-01	AAT	Stock	40.03	40.55	39.78	40.45	106300.0
2016-06-01	AAU-DELISTED	Stock	1.08	1.08	1.01	1.0699	347490.0
2016-06-01	AAUAF-DELISTED	Stock	1.08	1.08	1.01	1.07	348504.0
2016-06-01	AAV-DELISTED	Stock	5.79	5.93	5.78	5.93	32540.0
2016-06-01	AAWW-DELISTED	Stock	43.19	43.59	42.68	43.2	343812.0
2016-06-01	AAXJ	Stock	53.21	53.31	53.04	53.19	392267.0
2016-06-01	AAXN-DELISTED	Stock	22.31	22.4	21.98	22.32	675597.0
2016-06-01	AB	Stock	23.33	23.68	23.25	23.53	152200.0
2016-06-01	ABAC-DELISTED	Stock	0.6789	0.679	0.669	0.679	1450.0
2016-06-01	ABAX-DELISTED	Stock	45.93	46.85	45.19	46.69	111340.0
2016-06-01	ABB-DELISTED	Stock	20.73	20.88	20.67	20.88	1080595.0
2016-06-01	ABBNY-DELISTED	Stock	20.73	20.88	20.67	20.88	1130517.0
2016-06-01	ABBV	Stock	62.93	63.17	62.63	62.83	5284400.0
2016-06-01	ABC-DELISTED	Stock	74.76	75.94	74.59	75.65	2533306.0
2016-06-01	ABCB	Stock	31.73	32.0	31.31	31.77	175500.0
2016-06-01	ABCD-DELISTED	Stock	4.57	4.57	4.51	4.52	19152.0
2016-06-01	ABCO-DELISTED	Stock	32.64	34.3	32.59	33.865	499127.0
2016-06-01	ABDC-DELISTED	Stock	12.22	12.49	12.22	12.4	13153.0
2016-06-01	ABE-DELISTED	Stock	11.81	11.81	11.76	11.768	2475.0
2016-06-01	ABEO	Stock	71.5	76.0	71.5	74.75	2340.0
2016-06-01	ABEV	Stock	5.24	5.38	5.17	5.38	16046800.0
2016-06-01	ABG	Stock	55.63	56.15	54.81	55.9	232200.0
2016-06-01	ABIL-DELISTED	Stock	3.42	3.42	3.18	3.19	26577.0
2016-06-01	ABM	Stock	34.08	34.26	33.91	34.2	217000.0
2016-06-01	ABMD-DELISTED	Stock	98.98	102.03	98.69	101.59	332169.0
2016-06-01	ABR	Stock	7.01	7.04	6.93	7.02	67800.0

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

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