PREVIEW / stock_daily / 2016-08-22

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-22.parquet
  size:    219 KB
  rows:    6,543
  symbols: 3,236

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-22	AAPL	Stock	27.215	27.275	26.9625	27.1275	103280800.0
2016-08-22	MSFT	Stock	57.6	57.75	57.26	57.67	15221900.0
2016-08-22	NVDA	Stock	1.5613	1.5652	1.5428	1.563	244748000.0
2016-08-22	AMZN	Stock	37.875	37.9925	37.605	37.974	33586000.0
2016-08-22	GOOGL	Stock	39.9255	39.965	39.7165	39.8475	17067300.0
2016-08-22	META	Stock	123.33	124.83	123.11	124.15	14386400.0
2016-08-22	TSLA	Stock	14.9447	15.0073	14.8453	14.862	30982500.0
2016-08-22	TLT	Stock	139.65	140.14	139.3689	139.88	5549684.0
2016-08-22	ES	Stock	55.65	55.96	55.55	55.63	1015000.0
2016-08-22	CL	Stock	74.38	74.65	74.11	74.5	1623800.0
2016-08-22	A	Stock	47.63	47.85	47.38	47.58	1626800.0
2016-08-22	AA.B-DELISTED	Stock	35.07	35.25	34.91	34.9901	54216.0
2016-08-22	AAAP-DELISTED	Stock	32.56	32.82	32.25	32.67	14725.0
2016-08-22	AABA-DELISTED	Stock	42.84	42.87	42.33	42.54	5526997.0
2016-08-22	AAC-DELISTED	Stock	17.53	17.82	17.13	17.8	125676.0
2016-08-22	AACG	Stock	4.27	4.3	4.1	4.29	4400.0
2016-08-22	AAIC-DELISTED	Stock	14.5	14.5	14.39	14.47	102582.0
2016-08-22	AAL	Stock	36.33	36.48	35.86	36.0	5189400.0
2016-08-22	AAMC-DELISTED	Stock	4.1912	4.1912	3.9676	3.9824	49031.0
2016-08-22	AAME	Stock	3.9	4.29	3.51	3.51	139100.0
2016-08-22	AAMI	Stock	13.54	13.54	13.33	13.5	61400.0
2016-08-22	AAOI	Stock	13.66	13.68	13.342	13.64	100800.0
2016-08-22	AAON	Stock	18.3467	18.4867	18.18	18.46	104700.0
2016-08-22	AAP	Stock	158.97	160.96	158.04	158.47	1151200.0
2016-08-22	AAT	Stock	44.46	44.95	44.21	44.64	63200.0
2016-08-22	AAU-DELISTED	Stock	1.62	1.64	1.52	1.55	518166.0
2016-08-22	AAUAF-DELISTED	Stock	1.62	1.64	1.52	1.55	567816.0
2016-08-22	AAV-DELISTED	Stock	7.22	7.22	7.04	7.06	117621.0
2016-08-22	AAWW-DELISTED	Stock	34.76	34.91	34.23	34.7	187857.0
2016-08-22	AAXJ	Stock	59.05	59.05	58.72	58.86	708838.0
2016-08-22	AAXN-DELISTED	Stock	29.05	29.205	28.63	29.035	647012.0
2016-08-22	AB	Stock	21.94	22.1	21.56	21.93	242600.0
2016-08-22	ABAC-DELISTED	Stock	0.732	0.79	0.732	0.7895	13318.0
2016-08-22	ABAX-DELISTED	Stock	48.87	50.51	48.8501	49.83	67606.0
2016-08-22	ABB-DELISTED	Stock	21.92	22.01	21.865	21.95	1052836.0
2016-08-22	ABBNY-DELISTED	Stock	21.92	22.01	21.865	21.95	1089504.0
2016-08-22	ABBV	Stock	67.31	67.79	66.92	67.01	7884800.0
2016-08-22	ABC-DELISTED	Stock	88.8	88.93	88.47	88.76	856835.0
2016-08-22	ABCB	Stock	33.5	33.83	33.41	33.78	61300.0
2016-08-22	ABCD-DELISTED	Stock	4.77	4.89	4.75	4.87	28387.0
2016-08-22	ABCO-DELISTED	Stock	41.52	41.9999	41.31	41.51	263176.0
2016-08-22	ABDC-DELISTED	Stock	12.46	12.49	12.42	12.48	63167.0
2016-08-22	ABE-DELISTED	Stock	12.51	12.68	12.51	12.67	11262.0
2016-08-22	ABEO	Stock	103.5	105.0	101.25	104.0	2644.0
2016-08-22	ABEOW-DELISTED	Stock	1.7164	1.9	1.7164	1.9	900.0
2016-08-22	ABEV	Stock	6.17	6.17	6.06	6.1	7746100.0
2016-08-22	ABG	Stock	53.87	53.93	52.14	52.63	313900.0
2016-08-22	ABIL-DELISTED	Stock	4.25	4.38	4.12	4.12	43052.0
2016-08-22	ABM	Stock	37.71	38.27	37.71	38.21	199500.0
2016-08-22	ABMD-DELISTED	Stock	121.02	121.61	120.09	120.67	272521.0

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

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