PREVIEW / stock_daily / 2016-09-02

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-02.parquet
  size:    218 KB
  rows:    6,511
  symbols: 3,200

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-09-02	AAPL	Stock	26.925	27.0	26.705	26.9325	107210000.0
2016-09-02	MSFT	Stock	57.67	58.19	57.42	57.67	18900500.0
2016-09-02	NVDA	Stock	1.582	1.5838	1.5455	1.5632	323148000.0
2016-09-02	AMZN	Stock	38.7055	38.8	38.585	38.622	43636000.0
2016-09-02	GOOGL	Stock	39.7635	39.855	39.663	39.8435	26997920.0
2016-09-02	META	Stock	126.85	126.86	126.0	126.51	12118800.0
2016-09-02	TSLA	Stock	13.4887	13.5467	13.08	13.1853	89661000.0
2016-09-02	TLT	Stock	138.96	139.0511	138.17	138.63	8396973.0
2016-09-02	ES	Stock	53.59	54.45	53.55	54.37	1624800.0
2016-09-02	CL	Stock	74.61	75.35	74.59	74.89	2981300.0
2016-09-02	A	Stock	47.23	47.39	46.89	47.0	1424500.0
2016-09-02	AA.B-DELISTED	Stock	34.4	34.62	34.11	34.2	139477.0
2016-09-02	AAAP-DELISTED	Stock	34.4	34.78	33.041	34.63	108293.0
2016-09-02	AABA-DELISTED	Stock	43.27	43.6	43.08	43.27	6111277.0
2016-09-02	AAC-DELISTED	Stock	19.34	20.05	19.14	20.05	168528.0
2016-09-02	AACG	Stock	4.6	4.63	4.33	4.48	9700.0
2016-09-02	AAIC-DELISTED	Stock	14.95	15.12	14.88	15.09	130631.0
2016-09-02	AAL	Stock	36.0	36.7	36.0	36.53	5429100.0
2016-09-02	AAMC-DELISTED	Stock	4.25	4.2529	3.9618	3.9618	51636.0
2016-09-02	AAME	Stock	3.43	3.67	3.41	3.64	4700.0
2016-09-02	AAMI	Stock	13.46	13.64	13.3	13.42	181000.0
2016-09-02	AAOI	Stock	17.36	17.85	17.17	17.51	352100.0
2016-09-02	AAON	Stock	19.1	19.3333	19.1	19.3267	221700.0
2016-09-02	AAP	Stock	158.79	159.65	158.05	158.57	635300.0
2016-09-02	AAT	Stock	44.16	45.09	44.16	44.52	127100.0
2016-09-02	AAU-DELISTED	Stock	1.4	1.47	1.37	1.455	441334.0
2016-09-02	AAUAF-DELISTED	Stock	1.4	1.47	1.37	1.47	444076.0
2016-09-02	AAV-DELISTED	Stock	6.93	7.0	6.86	6.95	74970.0
2016-09-02	AAWW-DELISTED	Stock	38.29	39.35	38.29	38.84	230877.0
2016-09-02	AAXJ	Stock	59.66	59.8757	59.54	59.82	1455171.0
2016-09-02	AAXN-DELISTED	Stock	26.97	27.18	26.45	26.57	782043.0
2016-09-02	AB	Stock	21.65	22.03	21.57	22.01	218000.0
2016-09-02	ABAC-DELISTED	Stock	0.7	0.75	0.5611	0.6617	195447.0
2016-09-02	ABAX-DELISTED	Stock	50.58	50.58	49.33	49.5	122212.0
2016-09-02	ABB-DELISTED	Stock	22.14	22.25	22.09	22.21	1651004.0
2016-09-02	ABBNY-DELISTED	Stock	22.15	22.25	22.09	22.21	1922964.0
2016-09-02	ABBV	Stock	64.37	64.48	63.87	64.12	4100800.0
2016-09-02	ABC-DELISTED	Stock	87.55	87.87	87.25	87.45	1060176.0
2016-09-02	ABCB	Stock	35.14	35.26	34.72	35.25	168200.0
2016-09-02	ABCD-DELISTED	Stock	4.74	4.79	4.5	4.68	589242.0
2016-09-02	ABCO-DELISTED	Stock	42.2	42.47	42.1	42.2	330084.0
2016-09-02	ABDC-DELISTED	Stock	12.6	12.69	12.58	12.68	54929.0
2016-09-02	ABE-DELISTED	Stock	12.55	12.67	12.55	12.6364	3350.0
2016-09-02	ABEO	Stock	108.25	112.5	105.25	111.75	3096.0
2016-09-02	ABEOW-DELISTED	Stock	1.61	2.11	1.58	2.0	900.0
2016-09-02	ABEV	Stock	6.14	6.16	6.05	6.13	15295700.0
2016-09-02	ABG	Stock	54.62	55.36	53.9	55.18	170900.0
2016-09-02	ABIL-DELISTED	Stock	4.48	4.58	4.455	4.455	26557.0
2016-09-02	ABM	Stock	38.9	39.16	38.6	38.91	222500.0
2016-09-02	ABMD-DELISTED	Stock	118.0	118.0	116.7165	117.46	271244.0

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

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