PREVIEW / stock_daily / 2016-06-16

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-16.parquet
  size:    218 KB
  rows:    6,559
  symbols: 3,272

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-06-16	AAPL	Stock	24.1125	24.4375	24.0175	24.3875	125307200.0
2016-06-16	MSFT	Stock	49.52	50.47	49.51	50.39	31188600.0
2016-06-16	NVDA	Stock	1.1752	1.1908	1.1638	1.1888	246456000.0
2016-06-16	AMZN	Stock	35.6025	35.9	35.265	35.8755	61960000.0
2016-06-16	GOOGL	Stock	36.398	36.5195	35.777	36.2125	45001660.0
2016-06-16	META	Stock	113.87	114.5	112.94	114.39	19236300.0
2016-06-16	TSLA	Stock	14.4947	14.536	14.2333	14.5287	36604500.0
2016-06-16	TLT	Stock	136.74	137.56	136.18	136.46	10372653.0
2016-06-16	ES	Stock	56.51	57.02	56.37	56.78	1203000.0
2016-06-16	CL	Stock	71.56	72.07	71.36	72.0	2161200.0
2016-06-16	A	Stock	44.72	45.43	44.59	45.37	1784700.0
2016-06-16	AA.B-DELISTED	Stock	32.79	32.8799	32.1638	32.8	14548.0
2016-06-16	AAAP-DELISTED	Stock	29.64	29.64	27.91	29.0	89756.0
2016-06-16	AABA-DELISTED	Stock	37.39	37.45	36.54	37.39	10056451.0
2016-06-16	AAC-DELISTED	Stock	19.82	20.41	19.75	19.9	97355.0
2016-06-16	AACG	Stock	5.06	5.15	5.06	5.06	2300.0
2016-06-16	AAIC-DELISTED	Stock	13.17	13.36	13.06	13.3	178334.0
2016-06-16	AAL	Stock	29.8	29.8	29.02	29.14	18236700.0
2016-06-16	AAMC-DELISTED	Stock	4.7794	4.9167	4.7647	4.8706	19866.0
2016-06-16	AAME	Stock	3.98	3.98	3.79	3.79	1300.0
2016-06-16	AAMI	Stock	14.2	14.46	13.87	14.45	288300.0
2016-06-16	AAOI	Stock	10.14	10.19	9.8	10.15	499600.0
2016-06-16	AAON	Stock	17.1867	17.3733	17.0467	17.3133	183000.0
2016-06-16	AAP	Stock	152.41	154.22	151.74	153.94	942400.0
2016-06-16	AAT	Stock	40.84	41.11	40.7	41.0	99800.0
2016-06-16	AAU-DELISTED	Stock	1.16	1.21	1.13	1.1699	761787.0
2016-06-16	AAUAF-DELISTED	Stock	1.16	1.21	1.13	1.16	777579.0
2016-06-16	AAV-DELISTED	Stock	5.49	5.51	5.38	5.41	60092.0
2016-06-16	AAWW-DELISTED	Stock	43.36	43.76	41.88	42.93	291900.0
2016-06-16	AAXJ	Stock	53.0	53.22	52.22	53.17	1035698.0
2016-06-16	AAXN-DELISTED	Stock	22.63	22.69	22.1999	22.62	478085.0
2016-06-16	AB	Stock	22.35	22.68	22.2	22.54	124900.0
2016-06-16	ABAC-DELISTED	Stock	0.74	0.795	0.681	0.77	16290.0
2016-06-16	ABAX-DELISTED	Stock	45.13	46.15	44.62	45.98	168859.0
2016-06-16	ABB-DELISTED	Stock	20.11	20.35	19.89	20.315	1973297.0
2016-06-16	ABBNY-DELISTED	Stock	20.11	20.35	19.89	20.31	2029920.0
2016-06-16	ABBV	Stock	59.93	60.94	59.91	60.9	7011200.0
2016-06-16	ABC-DELISTED	Stock	75.67	76.25	75.05	76.03	1894992.0
2016-06-16	ABCB	Stock	29.86	30.0	29.4	29.65	182300.0
2016-06-16	ABCD-DELISTED	Stock	4.8	4.8	4.64	4.74	7176.0
2016-06-16	ABCO-DELISTED	Stock	33.38	33.84	32.84	33.7	341885.0
2016-06-16	ABDC-DELISTED	Stock	12.05	12.335	12.05	12.06	12057.0
2016-06-16	ABE-DELISTED	Stock	11.65	11.7639	11.65	11.72	16691.0
2016-06-16	ABEO	Stock	71.75	72.0	69.25	71.25	3164.0
2016-06-16	ABEOW-DELISTED	Stock	1.07	1.07	1.05	1.0534	2200.0
2016-06-16	ABEV	Stock	5.26	5.39	5.21	5.38	6756500.0
2016-06-16	ABG	Stock	54.01	55.5	53.21	55.16	340800.0
2016-06-16	ABIL-DELISTED	Stock	4.0	4.15	3.92	4.09	37950.0
2016-06-16	ABM	Stock	36.41	36.71	36.2	36.67	176500.0
2016-06-16	ABMD-DELISTED	Stock	102.56	103.0	99.4	100.74	512155.0

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

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