PREVIEW / stock_daily / 2016-09-06

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-06.parquet
  size:    220 KB
  rows:    6,584
  symbols: 3,254

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-06	AAPL	Stock	26.975	27.075	26.8775	26.925	107521600.0
2016-09-06	MSFT	Stock	57.78	57.8	57.21	57.61	16278400.0
2016-09-06	NVDA	Stock	1.5688	1.578	1.5608	1.578	306812000.0
2016-09-06	AMZN	Stock	38.702	39.474	38.511	39.4435	74396000.0
2016-09-06	GOOGL	Stock	39.9195	40.5445	39.7715	40.401	39790740.0
2016-09-06	META	Stock	126.67	129.94	126.47	129.73	26278400.0
2016-09-06	TSLA	Stock	13.268	13.55	13.2667	13.522	65859000.0
2016-09-06	TLT	Stock	138.71	140.08	138.51	139.64	8542625.0
2016-09-06	ES	Stock	54.61	55.14	54.4	54.96	1352200.0
2016-09-06	CL	Stock	74.7	75.28	74.61	75.27	2139300.0
2016-09-06	A	Stock	46.9	47.11	46.72	46.95	1460900.0
2016-09-06	AA.B-DELISTED	Stock	34.38	34.8	34.33	34.78	25608.0
2016-09-06	AAAP-DELISTED	Stock	33.93	34.79	33.93	34.79	31458.0
2016-09-06	AABA-DELISTED	Stock	43.5	44.85	43.5	44.71	14672734.0
2016-09-06	AAC-DELISTED	Stock	19.99	20.29	19.27	20.16	169506.0
2016-09-06	AACG	Stock	4.34	4.6	4.33	4.33	4100.0
2016-09-06	AAIC-DELISTED	Stock	15.0	15.06	14.79	15.04	212674.0
2016-09-06	AAL	Stock	36.45	36.97	36.36	36.96	5501700.0
2016-09-06	AAMC-DELISTED	Stock	4.0412	4.1176	3.8353	3.8706	30093.0
2016-09-06	AAME	Stock	3.51	3.68	3.27	3.45	12700.0
2016-09-06	AAMI	Stock	13.41	13.64	13.21	13.52	347700.0
2016-09-06	AAOI	Stock	17.39	17.64	17.04	17.41	286100.0
2016-09-06	AAON	Stock	19.3733	19.4333	19.04	19.36	149400.0
2016-09-06	AAP	Stock	158.81	160.86	158.73	160.14	724400.0
2016-09-06	AAT	Stock	44.44	45.15	44.05	45.14	158200.0
2016-09-06	AAU-DELISTED	Stock	1.5	1.68	1.5	1.6799	651617.0
2016-09-06	AAUAF-DELISTED	Stock	1.5	1.68	1.5	1.68	660745.0
2016-09-06	AAV-DELISTED	Stock	6.99	7.13	6.97	7.11	59470.0
2016-09-06	AAWW-DELISTED	Stock	39.07	39.07	38.38	38.9	325903.0
2016-09-06	AAXJ	Stock	60.66	61.13	60.63	61.02	2174471.0
2016-09-06	AAXN-DELISTED	Stock	26.75	26.98	26.241	26.405	781787.0
2016-09-06	AB	Stock	22.0	22.25	21.86	22.08	339500.0
2016-09-06	ABAC-DELISTED	Stock	0.6737	0.6737	0.6302	0.6599	19464.0
2016-09-06	ABAX-DELISTED	Stock	49.21	49.48	48.19	49.44	235643.0
2016-09-06	ABB-DELISTED	Stock	22.46	22.59	22.34	22.55	2995710.0
2016-09-06	ABBNY-DELISTED	Stock	22.46	22.59	22.34	22.54	3144143.0
2016-09-06	ABBV	Stock	64.7	64.9	64.05	64.61	6286300.0
2016-09-06	ABC-DELISTED	Stock	87.3	87.798	87.0	87.64	1447288.0
2016-09-06	ABCB	Stock	35.41	35.41	34.87	35.16	237600.0
2016-09-06	ABCD-DELISTED	Stock	4.65	4.91	4.64	4.89	90744.0
2016-09-06	ABCO-DELISTED	Stock	42.31	42.89	41.96	42.79	167616.0
2016-09-06	ABDC-DELISTED	Stock	12.69	12.8	12.63	12.67	36853.0
2016-09-06	ABE-DELISTED	Stock	12.64	12.79	12.64	12.79	1821.0
2016-09-06	ABEO	Stock	112.5	119.5	111.25	117.25	9308.0
2016-09-06	ABEOW-DELISTED	Stock	1.99	2.0	1.99	2.0	400.0
2016-09-06	ABEV	Stock	6.12	6.25	6.09	6.25	21695300.0
2016-09-06	ABG	Stock	55.45	55.45	54.34	54.7	229900.0
2016-09-06	ABIL-DELISTED	Stock	4.6	4.6	4.27	4.39	31891.0
2016-09-06	ABM	Stock	38.97	39.06	38.46	38.99	233700.0
2016-09-06	ABMD-DELISTED	Stock	117.15	118.33	117.15	117.98	256422.0

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

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