PREVIEW / stock_daily / 2016-12-02

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-02.parquet
  size:    214 KB
  rows:    6,493
  symbols: 3,131

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-12-02	AAPL	Stock	27.2925	27.5225	27.2125	27.475	106112000.0
2016-12-02	MSFT	Stock	59.08	59.47	58.8	59.25	25515700.0
2016-12-02	NVDA	Stock	2.1562	2.22	2.128	2.2112	478292000.0
2016-12-02	AMZN	Stock	37.17	37.4245	36.835	37.017	71226000.0
2016-12-02	GOOGL	Stock	38.095	38.525	37.95	38.223	34376920.0
2016-12-02	META	Stock	115.11	116.48	114.3	115.4	25070400.0
2016-12-02	TSLA	Stock	12.192	12.3253	12.0	12.098	60634500.0
2016-12-02	TLT	Stock	119.17	120.21	119.14	119.6	12487458.0
2016-12-02	ES	Stock	51.43	51.9	51.2	51.68	2039200.0
2016-12-02	CL	Stock	65.18	65.47	64.46	64.72	4486800.0
2016-12-02	A	Stock	43.27	44.09	43.27	44.03	2153200.0
2016-12-02	AA	Stock	28.86	29.625	28.73	29.04	3870300.0
2016-12-02	AAAP-DELISTED	Stock	29.45	30.1488	29.35	29.7	97230.0
2016-12-02	AABA-DELISTED	Stock	39.77	40.32	39.58	40.07	7916152.0
2016-12-02	AAC-DELISTED	Stock	8.41	8.72	8.35	8.44	151389.0
2016-12-02	AACG	Stock	4.0	4.0	3.7	3.7	8400.0
2016-12-02	AAIC-DELISTED	Stock	16.21	16.29	16.07	16.12	209795.0
2016-12-02	AAL	Stock	46.09	46.86	45.91	46.1	6505100.0
2016-12-02	AAMC-DELISTED	Stock	8.1471	8.3382	8.1471	8.2353	16929.0
2016-12-02	AAME	Stock	3.95	3.95	3.95	3.95	500.0
2016-12-02	AAMI	Stock	14.77	14.77	14.39	14.47	155700.0
2016-12-02	AAOI	Stock	23.4	23.74	22.904	23.27	456200.0
2016-12-02	AAON	Stock	21.7333	21.8	21.4333	21.6667	141900.0
2016-12-02	AAP	Stock	170.46	171.98	169.88	170.14	487000.0
2016-12-02	AAT	Stock	39.32	40.05	39.32	39.77	249700.0
2016-12-02	AAU-DELISTED	Stock	1.04	1.09	1.04	1.09	353768.0
2016-12-02	AAUAF-DELISTED	Stock	1.04	1.09	1.04	1.08	356015.0
2016-12-02	AAV-DELISTED	Stock	7.3	7.375	7.2	7.25	69716.0
2016-12-02	AAWW-DELISTED	Stock	49.75	50.45	49.65	49.65	96593.0
2016-12-02	AAXJ	Stock	56.62	56.85	56.5	56.62	669123.0
2016-12-02	AAXN-DELISTED	Stock	27.6	28.01	27.4565	27.92	485908.0
2016-12-02	AB	Stock	23.05	23.15	22.71	22.8	225400.0
2016-12-02	ABAC-DELISTED	Stock	3.25	3.25	3.01	3.07	31243.0
2016-12-02	ABAX-DELISTED	Stock	50.95	51.96	50.48	50.6	111932.0
2016-12-02	ABB-DELISTED	Stock	20.63	20.73	20.54	20.61	1380285.0
2016-12-02	ABBNY-DELISTED	Stock	20.63	20.73	20.54	20.61	1433128.0
2016-12-02	ABBV	Stock	59.19	60.0	58.95	59.43	8020700.0
2016-12-02	ABC-DELISTED	Stock	78.15	79.58	77.66	78.79	1502347.0
2016-12-02	ABCB	Stock	44.45	44.5	43.8	44.2	127000.0
2016-12-02	ABCD-DELISTED	Stock	4.77	4.96	4.45	4.645	82152.0
2016-12-02	ABCO-DELISTED	Stock	32.15	32.3	30.4	31.9	884992.0
2016-12-02	ABDC-DELISTED	Stock	11.7	11.89	11.36	11.51	23712.0
2016-12-02	ABE-DELISTED	Stock	11.27	11.27	11.17	11.17	6465.0
2016-12-02	ABEO	Stock	156.25	160.0	152.5	155.0	10756.0
2016-12-02	ABEOW-DELISTED	Stock	3.3333	3.35	3.33	3.33	6650.0
2016-12-02	ABEV	Stock	4.74	4.81	4.7	4.78	36156200.0
2016-12-02	ABG	Stock	58.7	59.5	56.75	56.9	232700.0
2016-12-02	ABIL-DELISTED	Stock	3.32	3.34	3.26	3.29	3606.0
2016-12-02	ABM	Stock	42.93	43.61	42.71	43.57	231700.0
2016-12-02	ABMD-DELISTED	Stock	107.03	109.83	106.8	108.87	403077.0

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

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