PREVIEW / stock_daily / 2016-09-23

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-23.parquet
  size:    219 KB
  rows:    6,522
  symbols: 3,210

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-09-23	AAPL	Stock	28.605	28.6975	27.8875	28.1775	209924800.0
2016-09-23	MSFT	Stock	57.87	57.91	57.38	57.43	19955300.0
2016-09-23	NVDA	Stock	1.6275	1.6323	1.6165	1.6238	276132000.0
2016-09-23	AMZN	Stock	40.1565	40.3875	40.106	40.2875	47070000.0
2016-09-23	GOOGL	Stock	40.757	40.85	40.6365	40.748	28233460.0
2016-09-23	META	Stock	127.56	128.6	127.3	127.96	28326300.0
2016-09-23	TSLA	Stock	13.7327	14.012	13.7113	13.83	43578000.0
2016-09-23	TLT	Stock	137.03	137.34	136.71	136.82	5928833.0
2016-09-23	ES	Stock	55.65	56.41	55.52	56.23	1731600.0
2016-09-23	CL	Stock	73.52	73.53	73.09	73.25	3613100.0
2016-09-23	A	Stock	46.43	46.87	46.31	46.61	1957000.0
2016-09-23	AA.B-DELISTED	Stock	32.6	32.6	32.1816	32.3	20362.0
2016-09-23	AAAP-DELISTED	Stock	38.4	38.96	38.245	38.55	33701.0
2016-09-23	AABA-DELISTED	Stock	43.53	43.76	42.54	42.8	30449533.0
2016-09-23	AAC-DELISTED	Stock	17.84	18.05	16.84	17.06	283191.0
2016-09-23	AACG	Stock	4.59	4.59	4.3	4.51	1000.0
2016-09-23	AAIC-DELISTED	Stock	15.46	15.65	15.44	15.5	315252.0
2016-09-23	AAL	Stock	35.3	35.67	34.96	35.55	4603200.0
2016-09-23	AAMC-DELISTED	Stock	4.95	4.9794	4.8559	4.8824	36611.0
2016-09-23	AAME	Stock	3.37	3.43	3.37	3.43	2100.0
2016-09-23	AAMI	Stock	13.6	13.66	13.45	13.48	164500.0
2016-09-23	AAOI	Stock	20.76	21.54	20.7	21.14	427800.0
2016-09-23	AAON	Stock	19.1467	19.2333	18.9067	18.94	163950.0
2016-09-23	AAP	Stock	149.0	149.82	148.23	149.24	1375900.0
2016-09-23	AAT	Stock	44.0	44.37	43.5	44.21	101700.0
2016-09-23	AAU-DELISTED	Stock	1.43	1.44	1.38	1.43	251625.0
2016-09-23	AAUAF-DELISTED	Stock	1.43	1.44	1.38	1.43	273307.0
2016-09-23	AAV-DELISTED	Stock	6.84	6.89	6.68	6.73	46742.0
2016-09-23	AAWW-DELISTED	Stock	40.53	41.12	40.23	40.66	134224.0
2016-09-23	AAXJ	Stock	60.92	61.0	60.61	60.61	920399.0
2016-09-23	AAXN-DELISTED	Stock	28.23	28.23	27.92	28.095	418108.0
2016-09-23	AB	Stock	23.02	23.15	22.95	23.09	140600.0
2016-09-23	ABAC-DELISTED	Stock	2.27	2.28	2.07	2.09	13451.0
2016-09-23	ABAX-DELISTED	Stock	52.81	52.85	51.98	52.07	103751.0
2016-09-23	ABB-DELISTED	Stock	22.69	22.79	22.615	22.65	1890001.0
2016-09-23	ABBNY-DELISTED	Stock	22.69	22.79	22.615	22.65	1936831.0
2016-09-23	ABBV	Stock	65.05	65.33	64.75	64.98	5154200.0
2016-09-23	ABC-DELISTED	Stock	83.55	83.78	82.97	83.32	1635856.0
2016-09-23	ABCB	Stock	35.29	35.89	35.26	35.66	196600.0
2016-09-23	ABCD-DELISTED	Stock	5.7	5.7	5.55	5.57	32065.0
2016-09-23	ABCO-DELISTED	Stock	43.92	44.305	43.4	43.61	215511.0
2016-09-23	ABDC-DELISTED	Stock	13.09	13.24	13.09	13.1	41658.0
2016-09-23	ABE-DELISTED	Stock	12.6554	12.71	12.635	12.67	7462.0
2016-09-23	ABEO	Stock	159.5	160.5	153.75	157.25	10016.0
2016-09-23	ABEOW-DELISTED	Stock	2.2896	4.33	2.2896	4.33	9945.0
2016-09-23	ABEV	Stock	6.1	6.13	6.05	6.07	7659600.0
2016-09-23	ABG	Stock	54.88	55.82	54.79	55.62	156200.0
2016-09-23	ABIL-DELISTED	Stock	3.85	3.89	3.85	3.87	2800.0
2016-09-23	ABM	Stock	40.0	40.05	39.62	39.72	187900.0
2016-09-23	ABMD-DELISTED	Stock	126.03	126.09	123.06	123.54	232818.0

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

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