PREVIEW / stock_daily / 2016-09-26

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-26.parquet
  size:    218 KB
  rows:    6,528
  symbols: 3,214

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-26	AAPL	Stock	27.91	28.3475	27.8875	28.22	119477600.0
2016-09-26	MSFT	Stock	57.08	57.14	56.83	56.9	21688700.0
2016-09-26	NVDA	Stock	1.6052	1.615	1.5883	1.6085	230040000.0
2016-09-26	AMZN	Stock	40.09	40.2965	39.8575	39.958	53028000.0
2016-09-26	GOOGL	Stock	40.491	40.504	40.0225	40.1325	29454640.0
2016-09-26	META	Stock	127.37	128.16	126.8	127.31	15064900.0
2016-09-26	TSLA	Stock	13.7667	14.0667	13.7667	13.9327	35916000.0
2016-09-26	TLT	Stock	137.07	137.8336	137.02	137.69	8661318.0
2016-09-26	ES	Stock	56.24	56.59	56.05	56.34	1769400.0
2016-09-26	CL	Stock	73.05	73.39	72.81	73.11	2502800.0
2016-09-26	A	Stock	46.46	46.77	46.16	46.57	2639100.0
2016-09-26	AA.B-DELISTED	Stock	32.07	32.51	32.0	32.01	465183.0
2016-09-26	AAAP-DELISTED	Stock	38.35	38.75	37.87	38.65	24790.0
2016-09-26	AABA-DELISTED	Stock	42.38	42.735	41.85	42.29	11778985.0
2016-09-26	AAC-DELISTED	Stock	16.87	17.1	16.555	16.89	244461.0
2016-09-26	AACG	Stock	4.49	4.51	4.44	4.51	3000.0
2016-09-26	AAIC-DELISTED	Stock	15.66	15.71	15.38	15.5	477620.0
2016-09-26	AAL	Stock	35.19	35.55	34.86	34.93	7353500.0
2016-09-26	AAMC-DELISTED	Stock	4.8853	5.0176	4.4176	4.5441	68150.0
2016-09-26	AAME	Stock	3.36	3.43	3.31	3.42	3300.0
2016-09-26	AAMI	Stock	13.42	13.42	13.135	13.22	248000.0
2016-09-26	AAOI	Stock	21.11	21.6	20.85	21.01	409300.0
2016-09-26	AAON	Stock	18.8	18.9467	18.58	18.6867	147300.0
2016-09-26	AAP	Stock	148.73	150.24	147.8	150.1	997000.0
2016-09-26	AAT	Stock	44.04	44.52	44.04	44.35	98000.0
2016-09-26	AAU-DELISTED	Stock	1.41	1.4288	1.38	1.38	154289.0
2016-09-26	AAUAF-DELISTED	Stock	1.41	1.4288	1.38	1.38	162658.0
2016-09-26	AAV-DELISTED	Stock	6.76	6.85	6.73	6.73	58847.0
2016-09-26	AAWW-DELISTED	Stock	40.32	40.53	39.76	40.1	203551.0
2016-09-26	AAXJ	Stock	60.1	60.21	59.855	59.87	663591.0
2016-09-26	AAXN-DELISTED	Stock	27.93	28.41	27.93	28.31	629297.0
2016-09-26	AB	Stock	23.0	23.15	22.25	22.29	183000.0
2016-09-26	ABAC-DELISTED	Stock	2.13	2.13	2.02	2.06	9289.0
2016-09-26	ABAX-DELISTED	Stock	51.63	51.63	50.56	50.57	76421.0
2016-09-26	ABB-DELISTED	Stock	22.6	22.61	22.49	22.51	1163055.0
2016-09-26	ABBNY-DELISTED	Stock	22.6	22.61	22.49	22.5	1202866.0
2016-09-26	ABBV	Stock	64.52	64.88	64.02	64.07	5567700.0
2016-09-26	ABC-DELISTED	Stock	83.07	83.56	82.67	82.73	1068216.0
2016-09-26	ABCB	Stock	35.49	35.49	34.85	34.87	106400.0
2016-09-26	ABCD-DELISTED	Stock	5.71	5.71	5.47	5.49	11900.0
2016-09-26	ABCO-DELISTED	Stock	43.56	43.84	42.55	43.41	195542.0
2016-09-26	ABDC-DELISTED	Stock	13.19	13.22	13.09	13.14	73755.0
2016-09-26	ABE-DELISTED	Stock	12.36	12.79	12.36	12.62	3638.0
2016-09-26	ABEO	Stock	157.5	159.25	151.0	152.75	10204.0
2016-09-26	ABEOW-DELISTED	Stock	4.0	4.0	3.1	3.75	4001.0
2016-09-26	ABEV	Stock	6.01	6.04	5.98	6.01	8435300.0
2016-09-26	ABG	Stock	55.41	55.87	54.89	55.15	219700.0
2016-09-26	ABIL-DELISTED	Stock	3.9	3.9	3.7111	3.76	3944.0
2016-09-26	ABM	Stock	39.46	39.93	39.2	39.55	205900.0
2016-09-26	ABMD-DELISTED	Stock	123.25	127.219	122.26	126.73	364694.0

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

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