PREVIEW / stock_daily / 2016-11-03

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-03.parquet
  size:    212 KB
  rows:    6,479
  symbols: 3,155

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-11-03	AAPL	Stock	27.745	27.865	27.3875	27.4575	107730400.0
2016-11-03	MSFT	Stock	59.53	59.64	59.11	59.21	21600400.0
2016-11-03	NVDA	Stock	1.727	1.7285	1.666	1.699	309664000.0
2016-11-03	AMZN	Stock	38.2525	38.85	38.2	38.3515	77450000.0
2016-11-03	GOOGL	Stock	39.225	39.5	38.9315	39.1095	43504320.0
2016-11-03	META	Stock	122.0	123.28	119.5	120.0	63766300.0
2016-11-03	TSLA	Stock	12.6	12.7647	12.4693	12.4947	39795000.0
2016-11-03	TLT	Stock	130.75	131.05	130.44	130.57	6085408.0
2016-11-03	ES	Stock	53.26	53.63	53.0	53.38	1749300.0
2016-11-03	CL	Stock	71.32	71.38	70.41	70.57	4144400.0
2016-11-03	A	Stock	43.33	44.0	43.18	43.66	2510100.0
2016-11-03	AA	Stock	22.96	24.349	22.94	24.15	8084200.0
2016-11-03	AAAP-DELISTED	Stock	36.09	36.09	34.34	35.32	45520.0
2016-11-03	AABA-DELISTED	Stock	40.62	40.75	40.175	40.23	7670543.0
2016-11-03	AAC-DELISTED	Stock	11.2	11.2	7.68	7.7967	3649662.0
2016-11-03	AACG	Stock	3.67	3.72	3.4	3.54	39800.0
2016-11-03	AAIC-DELISTED	Stock	14.18	14.39	14.18	14.36	144695.0
2016-11-03	AAL	Stock	39.78	40.24	39.3	39.38	6006500.0
2016-11-03	AAMC-DELISTED	Stock	10.4412	10.9897	10.4412	10.5735	16952.0
2016-11-03	AAME	Stock	3.6	4.3	3.6	4.2	1800.0
2016-11-03	AAMI	Stock	13.21	13.21	12.56	12.67	224700.0
2016-11-03	AAOI	Stock	20.5	21.01	19.717	20.85	505500.0
2016-11-03	AAON	Stock	19.1667	19.1667	18.3	18.3667	281250.0
2016-11-03	AAP	Stock	138.8	140.29	138.23	138.85	1020000.0
2016-11-03	AAT	Stock	37.92	38.43	37.54	38.24	298600.0
2016-11-03	AAU-DELISTED	Stock	1.32	1.405	1.32	1.35	149529.0
2016-11-03	AAUAF-DELISTED	Stock	1.32	1.405	1.32	1.37	152603.0
2016-11-03	AAV-DELISTED	Stock	6.55	6.6	6.4	6.55	192273.0
2016-11-03	AAWW-DELISTED	Stock	41.2	42.85	40.25	42.5	255605.0
2016-11-03	AAXJ	Stock	58.31	58.36	57.95	58.12	657275.0
2016-11-03	AAXN-DELISTED	Stock	22.34	23.25	21.93	21.98	660352.0
2016-11-03	AB	Stock	20.95	21.35	20.75	21.0	245500.0
2016-11-03	ABAC-DELISTED	Stock	2.7199	2.72	2.65	2.65	6382.0
2016-11-03	ABAX-DELISTED	Stock	46.44	46.84	45.88	45.88	87254.0
2016-11-03	ABB-DELISTED	Stock	20.6	20.6001	20.4	20.42	1443530.0
2016-11-03	ABBNY-DELISTED	Stock	20.6	20.6001	20.4	20.43	1491576.0
2016-11-03	ABBV	Stock	57.12	57.29	55.85	55.89	9842600.0
2016-11-03	ABC-DELISTED	Stock	75.87	77.47	71.21	72.33	6735193.0
2016-11-03	ABCB	Stock	35.7	36.17	35.55	36.1	119600.0
2016-11-03	ABCD-DELISTED	Stock	5.11	5.11	4.95	4.9799	6048.0
2016-11-03	ABCO-DELISTED	Stock	36.25	36.8	35.95	36.05	321770.0
2016-11-03	ABDC-DELISTED	Stock	12.89	12.96	12.72	12.89	30065.0
2016-11-03	ABE-DELISTED	Stock	12.185	12.21	12.06	12.06	7455.0
2016-11-03	ABEO	Stock	158.75	160.0	138.75	142.5	28600.0
2016-11-03	ABEOW-DELISTED	Stock	2.5	2.88	2.49	2.4987	13851.0
2016-11-03	ABEV	Stock	5.67	5.68	5.47	5.47	40525200.0
2016-11-03	ABG	Stock	49.95	50.3	48.65	48.85	178100.0
2016-11-03	ABIL-DELISTED	Stock	2.95	3.06	2.68	2.68	31099.0
2016-11-03	ABM	Stock	38.15	38.57	38.04	38.3	155300.0
2016-11-03	ABMD-DELISTED	Stock	104.31	104.68	101.79	102.5	469639.0

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

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