PREVIEW / stock_daily / 2016-07-19

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-19.parquet
  size:    219 KB
  rows:    6,551
  symbols: 3,252

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-07-19	AAPL	Stock	24.89	25.0	24.835	24.9675	95119600.0
2016-07-19	MSFT	Stock	53.71	53.9	52.93	53.09	53336500.0
2016-07-19	NVDA	Stock	1.3235	1.3432	1.321	1.338	382652000.0
2016-07-19	AMZN	Stock	36.625	37.1665	36.6155	36.9975	44336000.0
2016-07-19	GOOGL	Stock	37.4935	37.8295	37.4244	37.6705	30435900.0
2016-07-19	META	Stock	118.99	120.85	118.66	120.61	21541300.0
2016-07-19	TSLA	Stock	15.0	15.2733	14.9833	15.0173	46726500.0
2016-07-19	TLT	Stock	138.94	139.31	138.4	139.04	8073906.0
2016-07-19	ES	Stock	58.17	58.32	57.74	58.09	1287900.0
2016-07-19	CL	Stock	74.21	74.56	74.09	74.56	3396500.0
2016-07-19	A	Stock	46.67	47.0	46.49	46.98	2583900.0
2016-07-19	AA.B-DELISTED	Stock	36.77	36.9338	36.36	36.36	40473.0
2016-07-19	AAAP-DELISTED	Stock	30.5	30.69	30.5	30.51	8506.0
2016-07-19	AABA-DELISTED	Stock	37.77	38.49	37.65	38.17	9668307.0
2016-07-19	AAC-DELISTED	Stock	22.89	23.15	22.33	22.59	71757.0
2016-07-19	AACG	Stock	4.6	4.6	4.1	4.19	1200.0
2016-07-19	AAIC-DELISTED	Stock	13.26	13.43	13.252	13.38	142662.0
2016-07-19	AAL	Stock	35.78	36.08	35.33	36.01	7956300.0
2016-07-19	AAMC-DELISTED	Stock	3.9735	4.1029	3.8029	3.8059	108882.0
2016-07-19	AAMI	Stock	14.09	14.25	14.06	14.17	158600.0
2016-07-19	AAOI	Stock	11.73	11.78	11.5	11.51	97600.0
2016-07-19	AAON	Stock	18.62	18.64	18.3533	18.3667	184650.0
2016-07-19	AAP	Stock	163.17	163.77	161.66	163.7	855900.0
2016-07-19	AAT	Stock	44.58	44.66	44.36	44.53	153400.0
2016-07-19	AAU-DELISTED	Stock	1.45	1.45	1.3735	1.3748	330482.0
2016-07-19	AAUAF-DELISTED	Stock	1.44	1.45	1.3735	1.3748	352447.0
2016-07-19	AAV-DELISTED	Stock	6.46	6.4948	6.23	6.29	114823.0
2016-07-19	AAWW-DELISTED	Stock	43.26	43.49	42.98	43.02	129508.0
2016-07-19	AAXJ	Stock	56.77	56.8	56.49	56.58	639217.0
2016-07-19	AAXN-DELISTED	Stock	28.0	28.469	27.63	28.12	992827.0
2016-07-19	AB	Stock	23.81	23.97	23.43	23.75	257400.0
2016-07-19	ABAC-DELISTED	Stock	0.7999	0.8	0.75	0.8	41358.0
2016-07-19	ABAX-DELISTED	Stock	53.4	53.81	52.76	53.12	69005.0
2016-07-19	ABB-DELISTED	Stock	20.0	20.175	19.95	20.12	1989074.0
2016-07-19	ABBNY-DELISTED	Stock	20.0	20.175	19.95	20.11	2072738.0
2016-07-19	ABBV	Stock	63.41	63.97	63.09	63.32	5794500.0
2016-07-19	ABC-DELISTED	Stock	85.76	86.15	85.1	85.94	1735410.0
2016-07-19	ABCB	Stock	30.74	30.87	30.44	30.56	143200.0
2016-07-19	ABCD-DELISTED	Stock	4.97	4.99	4.87	4.95	6020.0
2016-07-19	ABCO-DELISTED	Stock	38.01	38.11	37.32	37.97	180672.0
2016-07-19	ABDC-DELISTED	Stock	12.15	12.2	12.15	12.2	20783.0
2016-07-19	ABE-DELISTED	Stock	12.4	12.41	12.36	12.36	2655.0
2016-07-19	ABEO	Stock	59.5	64.0	59.5	60.25	7380.0
2016-07-19	ABEOW-DELISTED	Stock	1.15	1.15	1.1192	1.15	3000.0
2016-07-19	ABEV	Stock	5.79	5.84	5.78	5.84	8586700.0
2016-07-19	ABG	Stock	58.89	59.87	58.75	59.29	193100.0
2016-07-19	ABIL-DELISTED	Stock	4.6347	4.6347	4.54	4.58	3241.0
2016-07-19	ABM	Stock	36.89	37.1	36.62	36.77	247600.0
2016-07-19	ABMD-DELISTED	Stock	117.32	118.88	116.155	116.62	346415.0
2016-07-19	ABR	Stock	7.19	7.2	7.12	7.18	52800.0

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

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