PREVIEW / stock_daily / 2016-08-24

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-24.parquet
  size:    220 KB
  rows:    6,560
  symbols: 3,247

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-24	AAPL	Stock	27.1425	27.1875	26.92	27.0075	94700400.0
2016-08-24	MSFT	Stock	57.8	58.04	57.72	57.95	18151500.0
2016-08-24	NVDA	Stock	1.5783	1.579	1.5412	1.5485	298448000.0
2016-08-24	AMZN	Stock	38.15	38.1705	37.768	37.8625	34882000.0
2016-08-24	GOOGL	Stock	39.843	39.923	39.538	39.68	25688740.0
2016-08-24	META	Stock	124.47	124.69	123.09	123.48	12243700.0
2016-08-24	TSLA	Stock	15.1367	15.1433	14.8147	14.8413	38560500.0
2016-08-24	TLT	Stock	140.1	140.19	139.39	139.7	6027834.0
2016-08-24	ES	Stock	55.2	55.35	54.78	55.34	1140700.0
2016-08-24	CL	Stock	74.4	74.46	74.0	74.36	1742700.0
2016-08-24	A	Stock	47.74	47.82	46.63	46.7	2634700.0
2016-08-24	AA.B-DELISTED	Stock	35.79	35.79	34.56	34.5863	41475.0
2016-08-24	AAAP-DELISTED	Stock	33.58	35.998	33.5	34.4	174722.0
2016-08-24	AABA-DELISTED	Stock	42.5	42.77	41.79	41.92	6315437.0
2016-08-24	AAC-DELISTED	Stock	18.75	19.01	18.11	18.46	172116.0
2016-08-24	AACG	Stock	4.5	4.5	4.3	4.3	2800.0
2016-08-24	AAIC-DELISTED	Stock	14.75	14.77	14.53	14.61	213501.0
2016-08-24	AAL	Stock	36.27	36.99	36.19	36.65	5945800.0
2016-08-24	AAMC-DELISTED	Stock	3.9824	4.016	3.8382	3.9118	23967.0
2016-08-24	AAME	Stock	3.44	3.78	3.42	3.55	4200.0
2016-08-24	AAMI	Stock	13.71	13.8	13.58	13.6	134700.0
2016-08-24	AAOI	Stock	13.97	14.228	13.86	13.88	143700.0
2016-08-24	AAON	Stock	18.5667	18.7333	18.48	18.6533	128850.0
2016-08-24	AAP	Stock	158.93	163.97	158.93	160.36	1747400.0
2016-08-24	AAT	Stock	44.49	44.49	44.15	44.46	108900.0
2016-08-24	AAU-DELISTED	Stock	1.4	1.43	1.32	1.37	1062954.0
2016-08-24	AAUAF-DELISTED	Stock	1.4	1.43	1.32	1.39	1069573.0
2016-08-24	AAV-DELISTED	Stock	7.11	7.16	6.99	7.0	132959.0
2016-08-24	AAWW-DELISTED	Stock	35.53	36.61	35.44	35.57	214087.0
2016-08-24	AAXJ	Stock	58.89	59.11	58.83	59.02	687057.0
2016-08-24	AAXN-DELISTED	Stock	28.93	29.15	28.35	28.5	882242.0
2016-08-24	AB	Stock	21.91	22.17	21.8	21.84	207600.0
2016-08-24	ABAC-DELISTED	Stock	0.81	0.81	0.7024	0.75	89693.0
2016-08-24	ABAX-DELISTED	Stock	50.05	50.64	49.28	49.48	48792.0
2016-08-24	ABB-DELISTED	Stock	22.05	22.08	21.9637	21.985	562634.0
2016-08-24	ABBNY-DELISTED	Stock	22.05	22.08	21.9637	21.99	585655.0
2016-08-24	ABBV	Stock	66.31	66.53	64.84	65.06	8551100.0
2016-08-24	ABC-DELISTED	Stock	88.9	89.09	88.095	88.41	1178246.0
2016-08-24	ABCB	Stock	33.85	33.9	33.68	33.87	58500.0
2016-08-24	ABCD-DELISTED	Stock	4.74	4.78	4.6	4.67	37944.0
2016-08-24	ABCO-DELISTED	Stock	42.21	42.81	41.7	42.51	158161.0
2016-08-24	ABDC-DELISTED	Stock	12.5	12.67	12.45	12.49	32408.0
2016-08-24	ABE-DELISTED	Stock	12.63	12.7101	12.63	12.7101	1274.0
2016-08-24	ABEO	Stock	107.25	109.0	105.25	108.5	3060.0
2016-08-24	ABEOW-DELISTED	Stock	2.01	2.1	1.97	2.05	9190.0
2016-08-24	ABEV	Stock	6.03	6.1	6.01	6.07	6529100.0
2016-08-24	ABG	Stock	53.32	53.82	52.76	52.83	239600.0
2016-08-24	ABIL-DELISTED	Stock	4.23	4.32	4.2	4.23	17352.0
2016-08-24	ABM	Stock	38.36	38.38	38.09	38.15	167200.0
2016-08-24	ABMD-DELISTED	Stock	121.49	121.93	117.035	117.38	283384.0

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

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