PREVIEW / stock_daily / 2016-12-07

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-07.parquet
  size:    216 KB
  rows:    6,542
  symbols: 3,152

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-12-07	AAPL	Stock	27.315	27.7975	27.29	27.7575	119994800.0
2016-12-07	MSFT	Stock	60.01	61.38	59.8	61.37	30809000.0
2016-12-07	NVDA	Stock	2.321	2.3825	2.3025	2.3768	480804000.0
2016-12-07	AMZN	Stock	38.2275	38.521	37.791	38.521	73698000.0
2016-12-07	GOOGL	Stock	38.9975	39.6	38.6765	39.5735	40588300.0
2016-12-07	META	Stock	117.0	117.95	116.57	117.95	21913700.0
2016-12-07	TSLA	Stock	12.41	12.8933	12.3333	12.8767	81928500.0
2016-12-07	TLT	Stock	119.82	120.62	119.82	120.4	10392180.0
2016-12-07	ES	Stock	52.17	52.98	52.07	52.97	1643500.0
2016-12-07	CL	Stock	65.13	65.95	64.92	65.93	6570000.0
2016-12-07	A	Stock	44.56	44.99	44.11	44.99	1815200.0
2016-12-07	AA	Stock	31.3	31.89	30.765	30.9	5778300.0
2016-12-07	AAAP-DELISTED	Stock	30.0	30.66	30.0	30.15	114673.0
2016-12-07	AABA-DELISTED	Stock	39.98	40.57	39.75	40.51	6660560.0
2016-12-07	AAC-DELISTED	Stock	8.4	8.54	8.03	8.2	211755.0
2016-12-07	AACG	Stock	4.01	4.01	3.83	3.83	1900.0
2016-12-07	AAIC-DELISTED	Stock	16.61	16.8972	16.49	16.77	439342.0
2016-12-07	AAL	Stock	46.61	48.94	46.52	48.65	10210300.0
2016-12-07	AAMC-DELISTED	Stock	9.6765	10.9118	9.6765	10.8971	42741.0
2016-12-07	AAME	Stock	3.95	4.0	3.85	4.0	1300.0
2016-12-07	AAMI	Stock	14.5	15.085	14.48	14.85	1568800.0
2016-12-07	AAOI	Stock	23.65	24.55	23.63	24.39	552100.0
2016-12-07	AAON	Stock	21.7333	21.8667	21.6267	21.8	272550.0
2016-12-07	AAP	Stock	172.38	177.0	172.38	176.78	774500.0
2016-12-07	AAT	Stock	40.29	41.75	40.15	41.71	217800.0
2016-12-07	AAU-DELISTED	Stock	1.12	1.15	1.1	1.13	186917.0
2016-12-07	AAUAF-DELISTED	Stock	1.12	1.15	1.1	1.12	188038.0
2016-12-07	AAV-DELISTED	Stock	7.35	7.4	7.15	7.175	88939.0
2016-12-07	AAWW-DELISTED	Stock	50.5	51.6	50.15	50.95	187984.0
2016-12-07	AAXJ	Stock	57.27	57.82	57.12	57.68	1068160.0
2016-12-07	AAXN-DELISTED	Stock	28.44	28.44	27.4501	27.51	959717.0
2016-12-07	AB	Stock	22.85	23.75	22.85	23.6	252400.0
2016-12-07	ABAC-DELISTED	Stock	3.23	3.4	3.04	3.19	16367.0
2016-12-07	ABAX-DELISTED	Stock	52.21	53.34	50.92	53.16	199675.0
2016-12-07	ABB-DELISTED	Stock	20.89	21.14	20.86	21.1	1928822.0
2016-12-07	ABBNY-DELISTED	Stock	20.89	21.14	20.86	21.1	2104977.0
2016-12-07	ABBV	Stock	60.26	60.65	58.8	59.99	13095600.0
2016-12-07	ABC-DELISTED	Stock	78.19	78.19	73.86	76.39	4064626.0
2016-12-07	ABCB	Stock	46.4	46.63	46.0	46.25	188000.0
2016-12-07	ABCD-DELISTED	Stock	4.39	4.77	4.37	4.65	67387.0
2016-12-07	ABCO-DELISTED	Stock	32.55	33.355	32.25	32.6	458577.0
2016-12-07	ABDC-DELISTED	Stock	11.8	11.89	11.56	11.72	19769.0
2016-12-07	ABE-DELISTED	Stock	11.29	11.4	11.29	11.39	8413.0
2016-12-07	ABEO	Stock	146.25	152.5	141.25	148.75	8388.0
2016-12-07	ABEOW-DELISTED	Stock	3.09	3.1	3.05	3.1	600.0
2016-12-07	ABEV	Stock	4.88	4.92	4.85	4.91	17371300.0
2016-12-07	ABG	Stock	61.3	62.85	61.0	62.8	211000.0
2016-12-07	ABIL-DELISTED	Stock	3.321	3.45	3.32	3.439	5500.0
2016-12-07	ABM	Stock	43.0	43.27	42.66	43.01	404500.0
2016-12-07	ABMD-DELISTED	Stock	114.07	117.94	111.79	116.65	612227.0

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

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