PREVIEW / stock_daily / 2016-08-03

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-03.parquet
  size:    219 KB
  rows:    6,525
  symbols: 3,233

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-03	AAPL	Stock	26.2025	26.46	26.1925	26.4475	120810400.0
2016-08-03	MSFT	Stock	56.68	57.11	56.49	56.97	22075600.0
2016-08-03	NVDA	Stock	1.3993	1.4075	1.3915	1.4048	299828000.0
2016-08-03	AMZN	Stock	37.853	37.9445	37.6125	37.732	71630000.0
2016-08-03	GOOGL	Stock	39.8235	39.977	39.651	39.946	29220500.0
2016-08-03	META	Stock	123.09	123.92	122.31	122.51	18525300.0
2016-08-03	TSLA	Stock	15.158	15.3133	14.9473	15.0527	58317000.0
2016-08-03	TLT	Stock	138.6	138.78	137.91	138.41	4930593.0
2016-08-03	ES	Stock	58.52	58.79	57.33	57.58	1554300.0
2016-08-03	CL	Stock	75.03	75.09	73.89	74.08	2651900.0
2016-08-03	A	Stock	47.1	47.18	46.9	47.09	1508900.0
2016-08-03	AA.B-DELISTED	Stock	35.7	35.92	35.3	35.55	82650.0
2016-08-03	AAAP-DELISTED	Stock	31.42	32.98	31.36	32.1	72527.0
2016-08-03	AABA-DELISTED	Stock	38.43	38.55	38.28	38.395	5270906.0
2016-08-03	AAC-DELISTED	Stock	21.13	21.38	19.83	19.99	215257.0
2016-08-03	AACG	Stock	3.82	3.82	3.74	3.82	9300.0
2016-08-03	AAIC-DELISTED	Stock	14.13	14.36	14.1	14.32	186067.0
2016-08-03	AAL	Stock	33.47	33.96	33.17	33.48	8254200.0
2016-08-03	AAMC-DELISTED	Stock	3.75	3.9235	3.7088	3.7206	58422.0
2016-08-03	AAME	Stock	4.18	4.25	4.1	4.25	2200.0
2016-08-03	AAMI	Stock	13.5	13.82	13.48	13.59	150100.0
2016-08-03	AAOI	Stock	11.79	12.365	11.67	12.27	240700.0
2016-08-03	AAON	Stock	17.5	17.5667	17.3933	17.5333	143400.0
2016-08-03	AAP	Stock	166.44	168.66	164.99	168.65	594500.0
2016-08-03	AAT	Stock	45.49	45.54	44.98	45.12	156800.0
2016-08-03	AAU-DELISTED	Stock	1.43	1.49	1.4	1.465	298161.0
2016-08-03	AAUAF-DELISTED	Stock	1.43	1.49	1.4	1.47	302733.0
2016-08-03	AAV-DELISTED	Stock	6.23	6.39	6.21	6.38	80803.0
2016-08-03	AAWW-DELISTED	Stock	40.28	40.28	37.0907	38.3099	629862.0
2016-08-03	AAXJ	Stock	56.88	57.36	56.811	57.34	1086274.0
2016-08-03	AAXN-DELISTED	Stock	28.8	29.0	28.4	28.73	822629.0
2016-08-03	AB	Stock	22.53	22.53	21.89	21.99	464600.0
2016-08-03	ABAC-DELISTED	Stock	0.6899	0.6899	0.5899	0.65	32283.0
2016-08-03	ABAX-DELISTED	Stock	48.75	49.56	48.73	49.4	59404.0
2016-08-03	ABB-DELISTED	Stock	20.95	21.0166	20.935	20.99	1217124.0
2016-08-03	ABBNY-DELISTED	Stock	20.95	21.0166	20.935	21.0	1250288.0
2016-08-03	ABBV	Stock	66.81	67.0	66.22	66.57	6355100.0
2016-08-03	ABC-DELISTED	Stock	89.35	89.89	88.38	89.88	2238631.0
2016-08-03	ABCB	Stock	32.65	32.98	32.35	32.8	139200.0
2016-08-03	ABCD-DELISTED	Stock	4.79	4.87	4.79	4.87	3872.0
2016-08-03	ABCO-DELISTED	Stock	41.07	41.78	40.54	41.43	201602.0
2016-08-03	ABDC-DELISTED	Stock	12.23	12.37	12.2	12.24	19848.0
2016-08-03	ABE-DELISTED	Stock	12.4899	12.4899	12.46	12.46	3737.0
2016-08-03	ABEO	Stock	75.0	84.0	74.5	81.75	11304.0
2016-08-03	ABEOW-DELISTED	Stock	1.1	1.6	1.1	1.395	3119.0
2016-08-03	ABEV	Stock	5.7	5.76	5.66	5.73	29298200.0
2016-08-03	ABG	Stock	55.44	56.08	55.0	56.02	484100.0
2016-08-03	ABIL-DELISTED	Stock	5.08	5.44	5.03	5.32	61552.0
2016-08-03	ABM	Stock	36.86	37.27	36.63	37.27	283500.0
2016-08-03	ABMD-DELISTED	Stock	119.05	119.85	118.32	118.58	327248.0

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

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