PREVIEW / stock_daily / 2016-06-30

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-30.parquet
  size:    220 KB
  rows:    6,610
  symbols: 3,292

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-30	AAPL	Stock	23.61	23.9425	23.575	23.9	143345600.0
2016-06-30	MSFT	Stock	50.72	51.3	50.5	51.17	28527800.0
2016-06-30	NVDA	Stock	1.1682	1.1825	1.1588	1.1752	430940000.0
2016-06-30	AMZN	Stock	35.86	35.9685	35.627	35.781	57102000.0
2016-06-30	GOOGL	Stock	34.8825	35.1885	34.7451	35.1765	42250260.0
2016-06-30	META	Stock	114.67	115.18	113.67	114.28	23192700.0
2016-06-30	TSLA	Stock	14.198	14.2333	13.9347	14.152	72646500.0
2016-06-30	TLT	Stock	138.81	139.94	138.085	138.9	14698513.0
2016-06-30	ES	Stock	58.66	59.95	58.55	59.9	2567100.0
2016-06-30	CL	Stock	71.9	73.2	71.86	73.2	3798800.0
2016-06-30	A	Stock	43.68	44.4	43.59	44.36	2181100.0
2016-06-30	AA.B-DELISTED	Stock	32.59	32.86	32.01	32.85	104970.0
2016-06-30	AAAP-DELISTED	Stock	30.02	30.32	29.51	30.16	18625.0
2016-06-30	AABA-DELISTED	Stock	36.89	37.58	36.89	37.56	13885313.0
2016-06-30	AAC-DELISTED	Stock	22.03	22.91	21.86	22.84	107496.0
2016-06-30	AACG	Stock	5.0	5.0	4.57	4.63	2000.0
2016-06-30	AAIC-DELISTED	Stock	12.9	13.01	12.78	13.01	229264.0
2016-06-30	AAL	Stock	27.86	28.31	27.49	28.31	11148300.0
2016-06-30	AAMC-DELISTED	Stock	4.2794	4.3733	4.1176	4.2853	50915.0
2016-06-30	AAME	Stock	4.0	4.08	3.96	3.96	5500.0
2016-06-30	AAMI	Stock	13.18	13.35	12.995	13.35	317000.0
2016-06-30	AAOI	Stock	10.44	11.17	10.44	11.15	399500.0
2016-06-30	AAON	Stock	17.7	18.3467	17.6467	18.34	263700.0
2016-06-30	AAP	Stock	161.02	161.7	159.5	161.63	791600.0
2016-06-30	AAT	Stock	42.1	42.45	41.79	42.44	150500.0
2016-06-30	AAU-DELISTED	Stock	1.56	1.67	1.431	1.63	1035168.0
2016-06-30	AAUAF-DELISTED	Stock	1.56	1.67	1.431	1.63	1044250.0
2016-06-30	AAV-DELISTED	Stock	5.66	5.72	5.5399	5.59	51292.0
2016-06-30	AAWW-DELISTED	Stock	39.92	41.42	39.92	41.42	226534.0
2016-06-30	AAXJ	Stock	54.41	54.79	54.225	54.68	666658.0
2016-06-30	AAXN-DELISTED	Stock	24.38	24.94	24.09	24.89	1105994.0
2016-06-30	AB	Stock	22.98	23.37	22.98	23.3	213400.0
2016-06-30	ABAC-DELISTED	Stock	0.8048	0.83	0.8048	0.83	665.0
2016-06-30	ABAX-DELISTED	Stock	46.26	47.38	45.77	47.26	159280.0
2016-06-30	ABB-DELISTED	Stock	19.45	19.84	19.45	19.83	2389319.0
2016-06-30	ABBNY-DELISTED	Stock	19.47	19.84	19.45	19.83	2444406.0
2016-06-30	ABBV	Stock	61.79	62.02	61.14	61.91	7920600.0
2016-06-30	ABC-DELISTED	Stock	77.61	79.33	77.43	79.33	2899331.0
2016-06-30	ABCB	Stock	29.26	29.73	28.7	29.7	236200.0
2016-06-30	ABCD-DELISTED	Stock	4.4	4.55	4.4	4.52	28303.0
2016-06-30	ABCO-DELISTED	Stock	34.59	35.43	34.29	35.39	344302.0
2016-06-30	ABDC-DELISTED	Stock	12.1	12.18	11.91	12.15	43590.0
2016-06-30	ABE-DELISTED	Stock	12.0863	12.1205	12.06	12.06	1830.0
2016-06-30	ABEO	Stock	59.75	60.5	58.0	59.0	2660.0
2016-06-30	ABEOW-DELISTED	Stock	0.95	0.95	0.95	0.95	1100.0
2016-06-30	ABEV	Stock	5.86	5.95	5.83	5.91	9669200.0
2016-06-30	ABG	Stock	53.89	53.89	51.59	52.74	292200.0
2016-06-30	ABIL-DELISTED	Stock	4.2	4.2	4.03	4.18	12525.0
2016-06-30	ABM	Stock	35.67	36.49	35.67	36.48	380800.0
2016-06-30	ABMD-DELISTED	Stock	109.21	109.66	108.11	109.26	565281.0

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

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