PREVIEW / stock_daily / 2016-07-05

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-05.parquet
  size:    217 KB
  rows:    6,516
  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-05	AAPL	Stock	23.8475	23.85	23.615	23.7475	110820800.0
2016-07-05	MSFT	Stock	50.83	51.28	50.74	51.17	24806400.0
2016-07-05	NVDA	Stock	1.16	1.1858	1.1508	1.1838	371084000.0
2016-07-05	AMZN	Stock	36.14	36.478	35.9805	36.405	48628000.0
2016-07-05	GOOGL	Stock	35.2505	35.406	34.9565	35.2445	28440560.0
2016-07-05	META	Stock	113.94	114.2	112.97	114.2	14207000.0
2016-07-05	TSLA	Stock	13.982	14.3027	13.8667	14.2653	77629500.0
2016-07-05	TLT	Stock	141.85	142.91	141.7	142.33	8840774.0
2016-07-05	ES	Stock	59.81	60.43	59.8	60.25	1413400.0
2016-07-05	CL	Stock	72.69	73.69	72.63	73.28	3128000.0
2016-07-05	A	Stock	44.31	44.35	43.63	43.75	1813500.0
2016-07-05	AA.B-DELISTED	Stock	33.44	33.44	32.32	32.7	59170.0
2016-07-05	AAAP-DELISTED	Stock	30.9	31.47	30.7501	31.185	55895.0
2016-07-05	AABA-DELISTED	Stock	37.68	37.77	37.17	37.5	8101097.0
2016-07-05	AAC-DELISTED	Stock	22.84	22.84	21.74	22.51	52070.0
2016-07-05	AACG	Stock	4.76	4.79	4.53	4.53	5400.0
2016-07-05	AAIC-DELISTED	Stock	12.8	12.9599	12.605	12.74	331345.0
2016-07-05	AAL	Stock	29.09	29.16	28.19	28.93	9467000.0
2016-07-05	AAMC-DELISTED	Stock	4.3353	4.3412	3.7265	4.0735	149603.0
2016-07-05	AAME	Stock	3.93	3.93	3.93	3.93	700.0
2016-07-05	AAMI	Stock	13.15	13.19	12.8	13.01	136600.0
2016-07-05	AAOI	Stock	11.07	11.07	10.37	10.6	283700.0
2016-07-05	AAON	Stock	18.1067	18.1067	17.8267	17.9933	155100.0
2016-07-05	AAP	Stock	162.46	163.64	160.32	161.19	754200.0
2016-07-05	AAT	Stock	42.54	43.45	42.54	43.28	209200.0
2016-07-05	AAU-DELISTED	Stock	1.64	1.65	1.51	1.5201	1009543.0
2016-07-05	AAUAF-DELISTED	Stock	1.64	1.65	1.5	1.5	1026815.0
2016-07-05	AAV-DELISTED	Stock	5.45	5.47	5.38	5.4201	52114.0
2016-07-05	AAWW-DELISTED	Stock	40.95	40.95	39.48	39.82	221790.0
2016-07-05	AAXJ	Stock	54.5	54.6	54.25	54.4	1530916.0
2016-07-05	AAXN-DELISTED	Stock	24.67	25.13	24.46	25.1	565697.0
2016-07-05	AB	Stock	22.87	23.16	22.45	22.59	158600.0
2016-07-05	ABAC-DELISTED	Stock	0.85	0.85	0.85	0.85	2450.0
2016-07-05	ABAX-DELISTED	Stock	48.47	48.6	47.935	48.15	83298.0
2016-07-05	ABB-DELISTED	Stock	19.49	19.54	19.2637	19.31	1517952.0
2016-07-05	ABBNY-DELISTED	Stock	19.5	19.54	19.2637	19.31	1575379.0
2016-07-05	ABBV	Stock	62.5	62.71	61.77	61.92	6293600.0
2016-07-05	ABC-DELISTED	Stock	79.86	80.685	79.39	80.37	2153540.0
2016-07-05	ABCB	Stock	29.4	29.4	29.0	29.09	98600.0
2016-07-05	ABCD-DELISTED	Stock	4.46	4.54	4.43	4.44	20808.0
2016-07-05	ABCO-DELISTED	Stock	35.06	36.1199	34.83	35.07	196437.0
2016-07-05	ABDC-DELISTED	Stock	12.15	12.23	12.15	12.2	12777.0
2016-07-05	ABE-DELISTED	Stock	12.19	12.19	12.06	12.1399	2268.0
2016-07-05	ABEO	Stock	60.75	61.25	57.75	60.5	1616.0
2016-07-05	ABEV	Stock	5.78	5.84	5.75	5.81	12730600.0
2016-07-05	ABG	Stock	53.74	53.74	50.13	50.57	295300.0
2016-07-05	ABIL-DELISTED	Stock	4.0	4.07	3.95	4.04	44559.0
2016-07-05	ABM	Stock	36.09	36.73	35.96	36.48	245900.0
2016-07-05	ABMD-DELISTED	Stock	109.91	110.78	108.77	109.81	458506.0
2016-07-05	ABR	Stock	7.1	7.12	7.0	7.11	63100.0

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

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