PREVIEW / stock_daily / 2016-11-02

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-02.parquet
  size:    213 KB
  rows:    6,498
  symbols: 3,165

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-02	AAPL	Stock	27.85	28.0875	27.8075	27.8975	113326800.0
2016-11-02	MSFT	Stock	59.82	59.93	59.3	59.43	22147000.0
2016-11-02	NVDA	Stock	1.7395	1.763	1.716	1.719	295848000.0
2016-11-02	AMZN	Stock	39.1965	39.2375	38.1775	38.278	100530000.0
2016-11-02	GOOGL	Stock	40.338	40.338	39.25	39.421	47014720.0
2016-11-02	META	Stock	130.23	130.23	126.28	127.17	39640900.0
2016-11-02	TSLA	Stock	12.67	12.8467	12.5007	12.5347	63801000.0
2016-11-02	TLT	Stock	131.3	132.11	131.03	131.58	8666228.0
2016-11-02	ES	Stock	53.89	54.46	52.76	53.44	2505000.0
2016-11-02	CL	Stock	70.94	71.42	70.84	71.18	3437000.0
2016-11-02	A	Stock	43.47	43.73	43.24	43.26	2240300.0
2016-11-02	AA	Stock	22.67	23.265	22.636	22.91	10755300.0
2016-11-02	AAAP-DELISTED	Stock	36.98	36.99	35.28	35.9701	45334.0
2016-11-02	AABA-DELISTED	Stock	41.82	42.16	40.36	40.69	12333879.0
2016-11-02	AAC-DELISTED	Stock	16.28	16.5	15.36	15.895	227184.0
2016-11-02	AACG	Stock	3.52	3.92	3.43	3.52	13300.0
2016-11-02	AAIC-DELISTED	Stock	14.24	14.36	14.17	14.17	164045.0
2016-11-02	AAL	Stock	39.72	40.25	39.62	39.71	5274500.0
2016-11-02	AAMC-DELISTED	Stock	10.3382	10.4412	10.0294	10.4412	25660.0
2016-11-02	AAMI	Stock	14.0	14.06	13.06	13.12	160900.0
2016-11-02	AAOI	Stock	19.51	21.1	19.205	20.1	612200.0
2016-11-02	AAON	Stock	19.3667	19.52	19.0333	19.0333	171900.0
2016-11-02	AAP	Stock	139.66	140.0	137.12	138.14	731700.0
2016-11-02	AAT	Stock	38.72	39.17	38.11	38.2	288200.0
2016-11-02	AAU-DELISTED	Stock	1.54	1.54	1.35	1.36	505950.0
2016-11-02	AAUAF-DELISTED	Stock	1.54	1.54	1.35	1.35	518656.0
2016-11-02	AAV-DELISTED	Stock	6.75	6.825	6.5	6.5	119972.0
2016-11-02	AAWW-DELISTED	Stock	41.7	42.15	41.0	41.3	229558.0
2016-11-02	AAXJ	Stock	58.73	58.73	58.05	58.28	2284507.0
2016-11-02	AAXN-DELISTED	Stock	22.55	22.9499	22.285	22.33	836137.0
2016-11-02	AB	Stock	21.45	21.55	21.2	21.3	209700.0
2016-11-02	ABAC-DELISTED	Stock	2.7349	2.7349	2.62	2.62	4900.0
2016-11-02	ABAX-DELISTED	Stock	46.35	46.89	46.15	46.16	87788.0
2016-11-02	ABB-DELISTED	Stock	20.46	20.58	20.44	20.46	1384237.0
2016-11-02	ABBNY-DELISTED	Stock	20.46	20.58	20.44	20.45	1426690.0
2016-11-02	ABBV	Stock	56.46	57.19	56.4	56.79	9746200.0
2016-11-02	ABC-DELISTED	Stock	70.27	76.69	70.18	75.98	5643440.0
2016-11-02	ABCB	Stock	36.3	36.3	35.5	35.65	87800.0
2016-11-02	ABCD-DELISTED	Stock	5.06	5.13	4.94	5.07	6672.0
2016-11-02	ABCO-DELISTED	Stock	25.6	36.85	24.85	36.55	1241393.0
2016-11-02	ABDC-DELISTED	Stock	12.95	13.02	12.6935	12.76	31122.0
2016-11-02	ABE-DELISTED	Stock	12.25	12.25	12.1401	12.21	8133.0
2016-11-02	ABEO	Stock	161.25	163.25	153.75	158.75	24160.0
2016-11-02	ABEOW-DELISTED	Stock	2.82	2.97	2.72	2.97	900.0
2016-11-02	ABEV	Stock	5.62	5.65	5.51	5.55	15147900.0
2016-11-02	ABG	Stock	49.8	50.8	49.15	49.55	189500.0
2016-11-02	ABIL-DELISTED	Stock	2.92	2.939	2.73	2.939	76074.0
2016-11-02	ABM	Stock	38.47	38.82	38.2	38.22	192800.0
2016-11-02	ABMD-DELISTED	Stock	104.97	104.97	103.01	104.21	705157.0
2016-11-02	ABR	Stock	7.33	7.33	7.21	7.26	54300.0

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

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