PREVIEW / stock_daily / 2016-09-12

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-12.parquet
  size:    218 KB
  rows:    6,545
  symbols: 3,218

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-12	AAPL	Stock	25.6625	26.43	25.6325	26.36	181171200.0
2016-09-12	MSFT	Stock	56.0	57.21	55.61	57.05	29303000.0
2016-09-12	NVDA	Stock	1.4682	1.5218	1.433	1.5188	598260000.0
2016-09-12	AMZN	Stock	37.8675	38.633	37.8	38.5745	62494000.0
2016-09-12	GOOGL	Stock	39.226	40.0085	39.175	39.941	37274740.0
2016-09-12	META	Stock	125.96	128.76	125.75	128.69	21252800.0
2016-09-12	TSLA	Stock	13.0	13.4247	12.94	13.22	55728000.0
2016-09-12	TLT	Stock	135.32	135.83	135.16	135.59	9096573.0
2016-09-12	ES	Stock	53.34	54.41	53.08	54.31	2766200.0
2016-09-12	CL	Stock	71.39	72.84	71.28	72.78	5928700.0
2016-09-12	A	Stock	44.59	45.81	44.47	45.75	1835400.0
2016-09-12	AA.B-DELISTED	Stock	32.31	33.12	32.2228	32.94	118316.0
2016-09-12	AAAP-DELISTED	Stock	34.24	34.74	34.24	34.61	23399.0
2016-09-12	AABA-DELISTED	Stock	42.28	43.65	42.18	43.465	9845293.0
2016-09-12	AAC-DELISTED	Stock	18.5	18.81	18.08	18.7	210880.0
2016-09-12	AACG	Stock	4.88	4.88	4.44	4.44	1100.0
2016-09-12	AAIC-DELISTED	Stock	14.63	14.96	14.59	14.89	284237.0
2016-09-12	AAL	Stock	37.22	38.38	36.62	38.34	11959800.0
2016-09-12	AAMC-DELISTED	Stock	4.0382	4.2124	4.0265	4.0559	44523.0
2016-09-12	AAME	Stock	3.57	3.57	3.34	3.36	11700.0
2016-09-12	AAMI	Stock	13.01	13.39	12.94	13.34	127200.0
2016-09-12	AAOI	Stock	19.31	20.63	18.7	20.42	811000.0
2016-09-12	AAON	Stock	17.8933	18.3933	17.6733	18.3933	317700.0
2016-09-12	AAP	Stock	152.72	153.88	151.42	153.37	2165300.0
2016-09-12	AAT	Stock	42.71	43.34	42.51	43.17	284700.0
2016-09-12	AAU-DELISTED	Stock	1.34	1.44	1.33	1.44	238603.0
2016-09-12	AAUAF-DELISTED	Stock	1.34	1.44	1.33	1.41	244354.0
2016-09-12	AAV-DELISTED	Stock	6.86	6.96	6.77	6.93	65544.0
2016-09-12	AAWW-DELISTED	Stock	38.11	39.0	37.91	38.96	195755.0
2016-09-12	AAXJ	Stock	58.64	59.77	58.43	59.58	1103065.0
2016-09-12	AAXN-DELISTED	Stock	25.02	25.52	25.01	25.39	384832.0
2016-09-12	AB	Stock	21.85	22.25	21.77	22.09	230600.0
2016-09-12	ABAC-DELISTED	Stock	2.09	2.09	1.51	1.86	69588.0
2016-09-12	ABAX-DELISTED	Stock	47.61	48.18	47.03	48.16	89185.0
2016-09-12	ABB-DELISTED	Stock	22.02	22.435	21.985	22.38	1888384.0
2016-09-12	ABBNY-DELISTED	Stock	22.02	22.435	21.985	22.39	1940918.0
2016-09-12	ABBV	Stock	62.98	64.23	62.66	64.08	6653000.0
2016-09-12	ABC-DELISTED	Stock	85.01	87.14	84.95	86.95	2140800.0
2016-09-12	ABCB	Stock	35.62	35.78	35.04	35.68	178400.0
2016-09-12	ABCD-DELISTED	Stock	5.33	5.39	5.32	5.37	18480.0
2016-09-12	ABCO-DELISTED	Stock	43.0	43.47	42.69	43.46	149841.0
2016-09-12	ABDC-DELISTED	Stock	12.75	12.8199	12.73	12.74	25434.0
2016-09-12	ABE-DELISTED	Stock	12.41	12.51	12.41	12.46	340.0
2016-09-12	ABEO	Stock	120.0	127.25	120.0	125.75	7028.0
2016-09-12	ABEV	Stock	5.97	6.09	5.95	6.08	28165700.0
2016-09-12	ABG	Stock	52.69	55.07	51.6	54.85	210900.0
2016-09-12	ABIL-DELISTED	Stock	3.8968	3.939	3.8968	3.939	2600.0
2016-09-12	ABM	Stock	38.33	38.78	38.06	38.76	254200.0
2016-09-12	ABMD-DELISTED	Stock	115.56	119.48	114.57	119.34	278143.0
2016-09-12	ABR	Stock	7.54	7.65	7.46	7.61	108300.0

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

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