PREVIEW / stock_daily / 2016-08-04

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-04.parquet
  size:    218 KB
  rows:    6,524
  symbols: 3,234

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-04	AAPL	Stock	26.395	26.5	26.32	26.4675	109634800.0
2016-08-04	MSFT	Stock	56.8	57.52	56.67	57.39	26587700.0
2016-08-04	NVDA	Stock	1.4115	1.4373	1.4088	1.4308	272712000.0
2016-08-04	AMZN	Stock	37.685	38.25	37.5175	38.0385	63564000.0
2016-08-04	GOOGL	Stock	39.912	40.01	39.696	39.8625	21520620.0
2016-08-04	META	Stock	122.94	124.79	122.51	124.36	21066000.0
2016-08-04	TSLA	Stock	15.046	15.3907	14.8033	15.374	62205000.0
2016-08-04	TLT	Stock	139.46	140.16	139.2711	139.45	5645951.0
2016-08-04	ES	Stock	57.6	57.99	57.45	57.62	1356800.0
2016-08-04	CL	Stock	74.21	75.06	74.21	74.78	3026300.0
2016-08-04	A	Stock	47.16	47.33	46.74	46.83	1700200.0
2016-08-04	AA.B-DELISTED	Stock	35.37	36.34	35.37	35.94	104100.0
2016-08-04	AAAP-DELISTED	Stock	32.0	32.94	31.4	31.75	63783.0
2016-08-04	AABA-DELISTED	Stock	38.49	39.03	38.43	38.92	9265405.0
2016-08-04	AAC-DELISTED	Stock	19.01	21.06	19.01	20.0	280460.0
2016-08-04	AACG	Stock	3.86	3.98	3.53	3.53	1800.0
2016-08-04	AAIC-DELISTED	Stock	14.34	14.49	14.33	14.47	204246.0
2016-08-04	AAL	Stock	33.57	33.77	33.0	33.58	6384700.0
2016-08-04	AAMC-DELISTED	Stock	3.7846	3.8529	3.6796	3.7559	46971.0
2016-08-04	AAME	Stock	4.25	4.25	4.15	4.16	700.0
2016-08-04	AAMI	Stock	13.53	14.01	13.29	13.82	158200.0
2016-08-04	AAOI	Stock	12.28	12.889	12.28	12.82	367700.0
2016-08-04	AAON	Stock	17.6333	17.6467	16.8867	17.1667	295500.0
2016-08-04	AAP	Stock	168.38	170.38	168.31	170.18	1102600.0
2016-08-04	AAT	Stock	44.94	45.81	44.88	45.15	129800.0
2016-08-04	AAU-DELISTED	Stock	1.47	1.47	1.4	1.41	173514.0
2016-08-04	AAUAF-DELISTED	Stock	1.47	1.47	1.4	1.41	174884.0
2016-08-04	AAV-DELISTED	Stock	6.36	6.5	6.36	6.45	58433.0
2016-08-04	AAWW-DELISTED	Stock	38.0	39.18	35.22	35.7005	700092.0
2016-08-04	AAXJ	Stock	57.43	57.6286	57.256	57.43	503279.0
2016-08-04	AAXN-DELISTED	Stock	28.72	29.15	28.51	28.96	1329961.0
2016-08-04	AB	Stock	21.5	21.93	21.5	21.82	284100.0
2016-08-04	ABAC-DELISTED	Stock	0.59	0.67	0.59	0.6	73320.0
2016-08-04	ABAX-DELISTED	Stock	49.51	49.79	48.98	49.03	58295.0
2016-08-04	ABB-DELISTED	Stock	21.18	21.3	21.14	21.24	868230.0
2016-08-04	ABBNY-DELISTED	Stock	21.18	21.3	21.14	21.23	898891.0
2016-08-04	ABBV	Stock	66.58	66.98	66.08	66.1	4901900.0
2016-08-04	ABC-DELISTED	Stock	89.71	89.81	88.44	88.975	1616895.0
2016-08-04	ABCB	Stock	32.84	33.38	32.84	33.01	142000.0
2016-08-04	ABCD-DELISTED	Stock	4.87	4.87	4.71	4.75	14749.0
2016-08-04	ABCO-DELISTED	Stock	41.55	42.3771	41.13	41.18	239303.0
2016-08-04	ABDC-DELISTED	Stock	12.29	12.29	12.21	12.24	7886.0
2016-08-04	ABE-DELISTED	Stock	12.5	12.535	12.48	12.5081	7826.0
2016-08-04	ABEO	Stock	84.5	95.25	84.5	90.75	22988.0
2016-08-04	ABEOW-DELISTED	Stock	1.1	1.66	1.1	1.6	19152.0
2016-08-04	ABEV	Stock	5.72	5.87	5.72	5.86	19036900.0
2016-08-04	ABG	Stock	55.38	57.17	53.04	56.08	157000.0
2016-08-04	ABIL-DELISTED	Stock	5.32	5.4	5.23	5.39	56261.0
2016-08-04	ABM	Stock	37.29	37.34	37.02	37.12	115400.0
2016-08-04	ABMD-DELISTED	Stock	118.73	121.57	118.46	121.4	471713.0

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

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