PREVIEW / stock_daily / 2016-08-17

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-17.parquet
  size:    218 KB
  rows:    6,521
  symbols: 3,219

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-17	AAPL	Stock	27.275	27.3425	27.085	27.305	101424000.0
2016-08-17	MSFT	Stock	57.54	57.68	57.23	57.56	18856400.0
2016-08-17	NVDA	Stock	1.565	1.5685	1.5165	1.5288	595212000.0
2016-08-17	AMZN	Stock	38.2205	38.261	37.96	38.2315	37822000.0
2016-08-17	GOOGL	Stock	40.0	40.2815	39.815	40.271	21321400.0
2016-08-17	META	Stock	123.66	124.38	122.85	124.37	13794200.0
2016-08-17	TSLA	Stock	14.9553	14.9887	14.8533	14.8827	26806500.0
2016-08-17	TLT	Stock	138.63	139.44	138.5	139.22	5001992.0
2016-08-17	ES	Stock	55.41	55.91	54.18	55.77	4311300.0
2016-08-17	CL	Stock	74.39	74.65	73.9	74.58	1977800.0
2016-08-17	A	Stock	48.63	48.63	48.08	48.43	3154900.0
2016-08-17	AA.B-DELISTED	Stock	35.21	35.5632	35.0201	35.372	20731.0
2016-08-17	AAAP-DELISTED	Stock	31.81	32.16	31.78	32.01	19902.0
2016-08-17	AABA-DELISTED	Stock	42.39	42.75	42.39	42.69	7183670.0
2016-08-17	AAC-DELISTED	Stock	18.61	18.61	17.95	18.0	120499.0
2016-08-17	AACG	Stock	4.01	4.25	4.01	4.06	1500.0
2016-08-17	AAIC-DELISTED	Stock	14.55	14.56	14.36	14.41	173158.0
2016-08-17	AAL	Stock	36.68	36.75	36.19	36.6	8002000.0
2016-08-17	AAMC-DELISTED	Stock	4.0912	4.2191	3.95	4.0059	26044.0
2016-08-17	AAMI	Stock	13.55	13.68	13.42	13.55	261700.0
2016-08-17	AAOI	Stock	13.97	13.97	13.27	13.31	241900.0
2016-08-17	AAON	Stock	18.0733	18.3267	17.8933	18.1533	145200.0
2016-08-17	AAP	Stock	160.0	160.42	156.93	158.05	1986800.0
2016-08-17	AAT	Stock	44.39	44.69	44.05	44.68	199300.0
2016-08-17	AAU-DELISTED	Stock	1.73	1.75	1.61	1.75	382617.0
2016-08-17	AAUAF-DELISTED	Stock	1.73	1.75	1.61	1.75	384609.0
2016-08-17	AAV-DELISTED	Stock	7.23	7.23	7.06	7.11	117977.0
2016-08-17	AAWW-DELISTED	Stock	34.95	35.3	34.51	34.62	200858.0
2016-08-17	AAXJ	Stock	59.24	59.455	58.86	59.38	1700675.0
2016-08-17	AAXN-DELISTED	Stock	29.34	29.6	29.25	29.345	753933.0
2016-08-17	AB	Stock	21.94	22.14	21.87	21.95	118900.0
2016-08-17	ABAC-DELISTED	Stock	0.91	0.93	0.7501	0.7876	78354.0
2016-08-17	ABAX-DELISTED	Stock	49.47	49.47	48.83	49.02	56234.0
2016-08-17	ABB-DELISTED	Stock	22.05	22.1	21.91	22.05	1357014.0
2016-08-17	ABBNY-DELISTED	Stock	22.05	22.1	21.91	22.06	1413258.0
2016-08-17	ABBV	Stock	66.69	67.35	66.35	66.83	7945400.0
2016-08-17	ABC-DELISTED	Stock	89.29	89.52	88.36	88.93	1203364.0
2016-08-17	ABCB	Stock	33.49	33.8	33.37	33.46	69100.0
2016-08-17	ABCD-DELISTED	Stock	4.68	4.71	4.63	4.7	4973.0
2016-08-17	ABCO-DELISTED	Stock	41.3	41.3	40.57	41.2599	162037.0
2016-08-17	ABDC-DELISTED	Stock	12.42	12.46	12.3	12.33	22354.0
2016-08-17	ABE-DELISTED	Stock	12.76	12.76	12.6748	12.71	3852.0
2016-08-17	ABEO	Stock	99.5	106.25	99.5	102.0	3216.0
2016-08-17	ABEOW-DELISTED	Stock	2.03	2.03	1.55	1.55	700.0
2016-08-17	ABEV	Stock	6.2	6.27	6.15	6.25	22410200.0
2016-08-17	ABG	Stock	55.48	55.73	54.34	54.66	134200.0
2016-08-17	ABIL-DELISTED	Stock	4.22	4.22	3.9	4.05	99417.0
2016-08-17	ABM	Stock	38.09	38.09	37.72	37.89	210500.0
2016-08-17	ABMD-DELISTED	Stock	122.9	122.9	120.49	121.79	215129.0
2016-08-17	ABR	Stock	7.33	7.33	7.24	7.28	50400.0

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

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