PREVIEW / stock_daily / 2016-08-05

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-05.parquet
  size:    220 KB
  rows:    6,544
  symbols: 3,243

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-05	AAPL	Stock	26.5675	26.9125	26.545	26.87	162213600.0
2016-08-05	MSFT	Stock	57.65	58.21	57.45	57.96	29335200.0
2016-08-05	NVDA	Stock	1.4473	1.4558	1.4402	1.455	371588000.0
2016-08-05	AMZN	Stock	38.2405	38.4235	38.1545	38.299	54088000.0
2016-08-05	GOOGL	Stock	40.0055	40.361	39.8905	40.3465	36145420.0
2016-08-05	META	Stock	124.98	125.84	124.62	125.15	20184000.0
2016-08-05	TSLA	Stock	15.3333	15.4667	15.16	15.3353	48078000.0
2016-08-05	TLT	Stock	139.05	139.18	137.825	138.0	7778635.0
2016-08-05	ES	Stock	57.24	57.66	56.46	56.74	2158200.0
2016-08-05	CL	Stock	74.7	74.88	74.21	74.58	2290200.0
2016-08-05	A	Stock	47.1	47.54	47.1	47.49	1250700.0
2016-08-05	AA.B-DELISTED	Stock	36.1	36.11	35.62	35.82	160265.0
2016-08-05	AAAP-DELISTED	Stock	32.25	32.25	30.9042	31.13	29154.0
2016-08-05	AABA-DELISTED	Stock	39.0	39.15	38.9	38.98	7705723.0
2016-08-05	AAC-DELISTED	Stock	20.13	20.23	18.64	18.78	243688.0
2016-08-05	AACG	Stock	3.7	3.85	3.7	3.74	5800.0
2016-08-05	AAIC-DELISTED	Stock	14.55	14.95	14.515	14.87	309559.0
2016-08-05	AAL	Stock	33.71	34.72	33.68	34.44	16437200.0
2016-08-05	AAMC-DELISTED	Stock	3.7941	3.8912	3.7647	3.8559	68323.0
2016-08-05	AAME	Stock	4.1	4.16	4.08	4.16	1100.0
2016-08-05	AAMI	Stock	13.9	14.1	13.81	13.84	109700.0
2016-08-05	AAOI	Stock	14.66	15.25	14.02	14.79	1520100.0
2016-08-05	AAON	Stock	17.1667	17.86	17.1667	17.7533	277650.0
2016-08-05	AAP	Stock	170.5	171.95	170.2	170.49	1090300.0
2016-08-05	AAT	Stock	45.23	45.32	44.98	45.15	165900.0
2016-08-05	AAU-DELISTED	Stock	1.38	1.43	1.33	1.41	248721.0
2016-08-05	AAUAF-DELISTED	Stock	1.36	1.43	1.33	1.43	251730.0
2016-08-05	AAV-DELISTED	Stock	6.5	6.8201	6.5	6.66	243884.0
2016-08-05	AAWW-DELISTED	Stock	36.5	37.989	35.89	35.96	616443.0
2016-08-05	AAXJ	Stock	58.0	58.28	57.89	58.24	475972.0
2016-08-05	AAXN-DELISTED	Stock	29.6	30.15	28.48	29.26	2376914.0
2016-08-05	AB	Stock	21.83	22.47	21.29	21.34	468300.0
2016-08-05	ABAC-DELISTED	Stock	0.5868	0.7196	0.562	0.71	285937.0
2016-08-05	ABAX-DELISTED	Stock	49.27	50.4	49.0	49.33	154266.0
2016-08-05	ABB-DELISTED	Stock	21.19	21.32	21.19	21.3	988769.0
2016-08-05	ABBNY-DELISTED	Stock	21.19	21.32	21.19	21.3	1034569.0
2016-08-05	ABBV	Stock	66.15	66.6	66.12	66.54	5045600.0
2016-08-05	ABC-DELISTED	Stock	89.4	90.48	89.25	89.33	1306928.0
2016-08-05	ABCB	Stock	33.02	33.82	32.87	33.8	224100.0
2016-08-05	ABCD-DELISTED	Stock	4.72	4.7789	4.7	4.71	21802.0
2016-08-05	ABCO-DELISTED	Stock	41.29	42.2399	40.12	41.99	237569.0
2016-08-05	ABDC-DELISTED	Stock	12.19	12.39	12.19	12.32	86631.0
2016-08-05	ABE-DELISTED	Stock	12.48	12.5566	12.41	12.5566	1800.0
2016-08-05	ABEO	Stock	90.75	91.0	85.75	86.75	7140.0
2016-08-05	ABEOW-DELISTED	Stock	1.6123	1.6123	1.5	1.5	749.0
2016-08-05	ABEV	Stock	5.93	6.03	5.87	6.03	23545700.0
2016-08-05	ABG	Stock	56.82	58.46	56.82	57.53	172000.0
2016-08-05	ABIL-DELISTED	Stock	5.45	5.55	5.45	5.5101	68106.0
2016-08-05	ABM	Stock	37.19	37.47	37.02	37.26	125800.0
2016-08-05	ABMD-DELISTED	Stock	121.62	122.98	120.0	120.22	418115.0

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

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