PREVIEW / stock_daily / 2016-10-03

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-03.parquet
  size:    218 KB
  rows:    6,522
  symbols: 3,198

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-10-03	AAPL	Stock	28.1775	28.2625	28.07	28.13	86807200.0
2016-10-03	MSFT	Stock	57.41	57.55	57.06	57.42	19189500.0
2016-10-03	NVDA	Stock	1.713	1.7378	1.7082	1.7112	242596000.0
2016-10-03	AMZN	Stock	41.8	41.993	41.5625	41.837	55388000.0
2016-10-03	GOOGL	Stock	40.1275	40.177	39.8115	40.019	29784240.0
2016-10-03	META	Stock	128.38	129.09	127.8	128.77	13156900.0
2016-10-03	TSLA	Stock	14.1533	14.378	13.8833	14.2467	89998500.0
2016-10-03	TLT	Stock	137.68	137.77	136.76	136.81	7588816.0
2016-10-03	ES	Stock	54.0	54.03	53.11	53.54	1677000.0
2016-10-03	CL	Stock	73.93	74.07	73.42	73.62	2691100.0
2016-10-03	A	Stock	46.82	47.23	46.82	47.14	1538800.0
2016-10-03	AA.B-DELISTED	Stock	32.78	33.0399	32.38	32.71	40946.0
2016-10-03	AAAP-DELISTED	Stock	37.8	37.8425	37.5	37.76	29547.0
2016-10-03	AABA-DELISTED	Stock	42.95	43.18	42.82	43.14	7131440.0
2016-10-03	AAC-DELISTED	Stock	17.44	17.66	17.24	17.58	85093.0
2016-10-03	AACG	Stock	4.15	4.15	4.11	4.11	500.0
2016-10-03	AAIC-DELISTED	Stock	14.73	14.75	14.58	14.71	150326.0
2016-10-03	AAL	Stock	36.46	37.75	36.33	37.7	8878900.0
2016-10-03	AAMC-DELISTED	Stock	5.3147	7.1882	5.1942	6.4559	92667.0
2016-10-03	AAME	Stock	3.3	3.31	3.24	3.3	2300.0
2016-10-03	AAMI	Stock	13.8	13.99	13.71	13.77	137100.0
2016-10-03	AAOI	Stock	22.0	22.08	21.13	21.44	282400.0
2016-10-03	AAON	Stock	19.1467	19.48	18.9067	19.4467	196650.0
2016-10-03	AAP	Stock	148.53	149.26	146.56	146.94	627500.0
2016-10-03	AAT	Stock	43.2	43.53	42.45	42.48	263400.0
2016-10-03	AAU-DELISTED	Stock	1.38	1.4	1.315	1.327	269656.0
2016-10-03	AAUAF-DELISTED	Stock	1.38	1.4	1.315	1.327	271849.0
2016-10-03	AAV-DELISTED	Stock	7.05	7.27	6.98	7.25	112729.0
2016-10-03	AAWW-DELISTED	Stock	42.44	42.655	41.985	42.26	283285.0
2016-10-03	AAXJ	Stock	60.42	60.855	60.37	60.84	1464530.0
2016-10-03	AAXN-DELISTED	Stock	26.0	26.0	24.22	24.29	7683355.0
2016-10-03	AB	Stock	22.83	23.24	22.64	22.78	169200.0
2016-10-03	ABAC-DELISTED	Stock	1.96	2.07	1.86	1.99	20800.0
2016-10-03	ABAX-DELISTED	Stock	51.59	52.03	50.83	51.9752	114383.0
2016-10-03	ABB-DELISTED	Stock	22.58	22.66	22.48	22.52	1416475.0
2016-10-03	ABBNY-DELISTED	Stock	22.58	22.66	22.48	22.52	1491453.0
2016-10-03	ABBV	Stock	63.02	63.29	62.25	63.23	4239600.0
2016-10-03	ABC-DELISTED	Stock	80.68	80.945	79.99	80.13	1320230.0
2016-10-03	ABCB	Stock	34.73	35.04	34.61	35.02	174300.0
2016-10-03	ABCD-DELISTED	Stock	5.43	5.46	5.38	5.44	6580.0
2016-10-03	ABCO-DELISTED	Stock	44.61	44.845	43.5	43.51	175714.0
2016-10-03	ABDC-DELISTED	Stock	13.06	13.12	12.93	12.99	24479.0
2016-10-03	ABE-DELISTED	Stock	12.62	12.6428	12.62	12.6428	302.0
2016-10-03	ABEO	Stock	150.0	157.5	150.0	153.75	5448.0
2016-10-03	ABEOW-DELISTED	Stock	3.25	3.6	3.25	3.6	1246.0
2016-10-03	ABEV	Stock	6.09	6.14	6.07	6.13	10128100.0
2016-10-03	ABG	Stock	55.37	55.44	54.42	54.73	210800.0
2016-10-03	ABIL-DELISTED	Stock	3.79	3.81	3.63	3.78	7430.0
2016-10-03	ABM	Stock	39.63	40.15	39.63	40.04	351500.0
2016-10-03	ABMD-DELISTED	Stock	127.94	128.7	126.18	127.81	287697.0

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

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