PREVIEW / stock_daily / 2016-11-10

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-10.parquet
  size:    215 KB
  rows:    6,529
  symbols: 3,182

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-11-10	AAPL	Stock	27.7725	27.7725	26.4575	26.9475	228538000.0
2016-11-10	MSFT	Stock	60.48	60.49	57.63	58.7	57822400.0
2016-11-10	NVDA	Stock	1.7872	1.7875	1.669	1.6942	869280000.0
2016-11-10	AMZN	Stock	38.9405	38.9415	35.885	37.119	254940000.0
2016-11-10	GOOGL	Stock	40.5	40.503	38.4115	39.0145	118192180.0
2016-11-10	META	Stock	123.93	124.18	115.27	120.8	67846700.0
2016-11-10	TSLA	Stock	12.7367	12.774	12.028	12.3567	101254500.0
2016-11-10	TLT	Stock	123.97	124.96	122.72	122.73	22961169.0
2016-11-10	ES	Stock	52.85	53.36	50.99	52.34	3051600.0
2016-11-10	CL	Stock	69.76	69.9	66.64	67.2	9784900.0
2016-11-10	A	Stock	46.6	47.38	46.34	47.03	2558700.0
2016-11-10	AA	Stock	29.08	29.7	28.3	29.1	8189900.0
2016-11-10	AAAP-DELISTED	Stock	37.0	37.7502	35.94	37.17	120606.0
2016-11-10	AABA-DELISTED	Stock	41.55	41.65	39.54	40.16	15228986.0
2016-11-10	AAC-DELISTED	Stock	7.04	7.78	6.97	7.64	478359.0
2016-11-10	AACG	Stock	3.82	4.29	3.8	3.9	27100.0
2016-11-10	AAIC-DELISTED	Stock	14.9	15.08	14.665	14.9	405236.0
2016-11-10	AAL	Stock	42.71	43.39	42.15	42.3	8665900.0
2016-11-10	AAMC-DELISTED	Stock	10.9412	10.9412	10.6057	10.7647	9520.0
2016-11-10	AAME	Stock	3.6	3.7	3.45	3.7	3300.0
2016-11-10	AAMI	Stock	13.49	13.49	12.82	13.32	855300.0
2016-11-10	AAOI	Stock	23.62	24.066	22.73	23.58	474900.0
2016-11-10	AAON	Stock	19.9667	20.4	19.5333	20.2533	403650.0
2016-11-10	AAP	Stock	140.85	146.45	140.85	145.82	2272000.0
2016-11-10	AAT	Stock	39.59	39.8	38.4	39.05	290500.0
2016-11-10	AAU-DELISTED	Stock	1.29	1.3	1.23	1.24	251347.0
2016-11-10	AAUAF-DELISTED	Stock	1.29	1.3	1.23	1.23	253345.0
2016-11-10	AAV-DELISTED	Stock	6.6	6.75	6.55	6.675	52029.0
2016-11-10	AAWW-DELISTED	Stock	45.05	46.5	42.75	45.95	434227.0
2016-11-10	AAXJ	Stock	57.75	57.81	56.54	56.72	3279504.0
2016-11-10	AAXN-DELISTED	Stock	26.34	28.0	25.81	26.81	5390835.0
2016-11-10	AB	Stock	21.85	22.9	21.79	22.9	492300.0
2016-11-10	ABAC-DELISTED	Stock	2.68	2.82	2.68	2.79	37036.0
2016-11-10	ABAX-DELISTED	Stock	49.99	50.51	48.47	49.92	147170.0
2016-11-10	ABB-DELISTED	Stock	21.2	21.41	21.09	21.355	3271037.0
2016-11-10	ABBNY-DELISTED	Stock	21.19	21.41	21.09	21.36	3434556.0
2016-11-10	ABBV	Stock	63.06	65.05	62.79	64.0	15948700.0
2016-11-10	ABC-DELISTED	Stock	77.09	80.8025	77.09	79.59	4020915.0
2016-11-10	ABCB	Stock	39.55	41.68	39.55	41.5	645900.0
2016-11-10	ABCD-DELISTED	Stock	5.35	5.35	4.77	4.885	175822.0
2016-11-10	ABCO-DELISTED	Stock	34.6	34.65	32.95	33.3	551062.0
2016-11-10	ABDC-DELISTED	Stock	12.51	12.6999	12.35	12.36	35979.0
2016-11-10	ABE-DELISTED	Stock	11.5626	11.66	11.55	11.63	16363.0
2016-11-10	ABEO	Stock	153.75	153.75	146.25	150.0	16412.0
2016-11-10	ABEOW-DELISTED	Stock	2.91	3.07	2.75	2.93	12120.0
2016-11-10	ABEV	Stock	5.27	5.34	5.16	5.31	33301800.0
2016-11-10	ABG	Stock	53.55	55.65	53.2	54.35	312800.0
2016-11-10	ABIL-DELISTED	Stock	3.0	3.0234	2.86	2.96	29466.0
2016-11-10	ABM	Stock	40.32	41.56	40.08	41.44	466000.0
2016-11-10	ABMD-DELISTED	Stock	107.03	107.71	105.271	107.3	457837.0

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

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