PREVIEW / stock_daily / 2016-08-01

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-01.parquet
  size:    218 KB
  rows:    6,537
  symbols: 3,248

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-08-01	AAPL	Stock	26.1025	26.5375	26.1025	26.5125	152671600.0
2016-08-01	MSFT	Stock	56.6	56.75	56.14	56.58	26003400.0
2016-08-01	NVDA	Stock	1.4335	1.4388	1.409	1.4182	301120000.0
2016-08-01	AMZN	Stock	37.9935	38.525	37.853	38.387	71564000.0
2016-08-01	GOOGL	Stock	39.3335	40.3745	39.252	40.047	60593160.0
2016-08-01	META	Stock	123.85	124.58	122.86	124.31	25006900.0
2016-08-01	TSLA	Stock	15.7	15.7753	15.292	15.334	60244500.0
2016-08-01	TLT	Stock	139.78	140.5	139.61	139.77	9809348.0
2016-08-01	ES	Stock	58.62	59.28	58.58	59.03	1946000.0
2016-08-01	CL	Stock	74.44	75.14	74.43	75.11	2903700.0
2016-08-01	A	Stock	48.11	48.11	47.62	47.87	1604600.0
2016-08-01	AA.B-DELISTED	Stock	36.39	36.39	35.9	36.06	24751.0
2016-08-01	AAAP-DELISTED	Stock	31.46	31.98	31.12	31.52	59938.0
2016-08-01	AABA-DELISTED	Stock	38.18	38.89	38.1	38.78	8847217.0
2016-08-01	AAC-DELISTED	Stock	22.54	22.54	21.12	21.5	167032.0
2016-08-01	AACG	Stock	3.73	3.82	3.71	3.71	9200.0
2016-08-01	AAIC-DELISTED	Stock	13.95	14.31	13.902	14.19	317727.0
2016-08-01	AAL	Stock	35.54	35.75	35.1	35.6	7059000.0
2016-08-01	AAMC-DELISTED	Stock	3.8118	3.8941	3.6882	3.6912	77666.0
2016-08-01	AAMI	Stock	14.01	14.02	13.57	13.71	171400.0
2016-08-01	AAOI	Stock	11.75	12.21	11.75	12.1	380400.0
2016-08-01	AAON	Stock	17.58	17.7733	17.4133	17.6467	191100.0
2016-08-01	AAP	Stock	169.26	169.57	168.07	168.5	844900.0
2016-08-01	AAT	Stock	45.9	46.02	45.54	45.92	174000.0
2016-08-01	AAU-DELISTED	Stock	1.51	1.575	1.46	1.5101	376805.0
2016-08-01	AAUAF-DELISTED	Stock	1.51	1.575	1.46	1.5101	379271.0
2016-08-01	AAV-DELISTED	Stock	6.25	6.28	6.11	6.13	70438.0
2016-08-01	AAWW-DELISTED	Stock	43.36	43.61	42.41	43.55	158107.0
2016-08-01	AAXJ	Stock	57.99	57.99	57.62	57.67	938828.0
2016-08-01	AAXN-DELISTED	Stock	29.21	29.58	28.935	29.155	719720.0
2016-08-01	AB	Stock	24.14	24.14	23.55	23.57	205600.0
2016-08-01	ABAC-DELISTED	Stock	0.72	0.72	0.64	0.6599	29010.0
2016-08-01	ABAX-DELISTED	Stock	49.33	49.83	48.73	49.16	77705.0
2016-08-01	ABB-DELISTED	Stock	21.02	21.155	20.95	21.07	1139703.0
2016-08-01	ABBNY-DELISTED	Stock	21.02	21.155	20.95	21.07	1180759.0
2016-08-01	ABBV	Stock	66.23	67.08	66.23	66.94	7599000.0
2016-08-01	ABC-DELISTED	Stock	85.28	86.32	85.11	85.48	2575962.0
2016-08-01	ABCB	Stock	33.08	33.3	32.82	32.91	130500.0
2016-08-01	ABCD-DELISTED	Stock	4.845	4.91	4.77	4.84	13962.0
2016-08-01	ABCO-DELISTED	Stock	41.6	42.405	41.35	42.02	594695.0
2016-08-01	ABDC-DELISTED	Stock	12.28	12.38	12.17	12.23	29856.0
2016-08-01	ABE-DELISTED	Stock	12.64	12.64	12.62	12.624	2551.0
2016-08-01	ABEO	Stock	68.5	71.5	67.5	70.5	3272.0
2016-08-01	ABEOW-DELISTED	Stock	1.11	1.15	1.1	1.15	26070.0
2016-08-01	ABEV	Stock	5.71	5.83	5.68	5.8	15208000.0
2016-08-01	ABG	Stock	61.34	61.37	57.91	59.64	346400.0
2016-08-01	ABIL-DELISTED	Stock	4.9	4.9	4.81	4.9	76894.0
2016-08-01	ABM	Stock	37.16	37.41	36.9	37.27	194500.0
2016-08-01	ABMD-DELISTED	Stock	118.12	119.55	118.12	119.55	488548.0
2016-08-01	ABR	Stock	7.11	7.2	7.11	7.17	62700.0

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

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