PREVIEW / stock_daily / 2016-05-11

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-11.parquet
  size:    218 KB
  rows:    6,539
  symbols: 3,279

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-05-11	AAPL	Stock	23.37	23.3925	23.115	23.1275	114876400.0
2016-05-11	MSFT	Stock	51.13	51.78	51.0	51.05	24039100.0
2016-05-11	NVDA	Stock	0.9018	0.9115	0.8968	0.9015	328176000.0
2016-05-11	AMZN	Stock	35.2895	35.95	35.0825	35.6615	146764000.0
2016-05-11	GOOGL	Stock	37.026	37.04	36.3951	36.5275	29834920.0
2016-05-11	META	Stock	120.41	121.08	119.42	119.52	22038400.0
2016-05-11	TSLA	Stock	13.8393	14.3653	13.7367	13.9307	77428500.0
2016-05-11	TLT	Stock	130.83	132.0	130.66	131.61	9256048.0
2016-05-11	ES	Stock	57.64	57.84	56.99	57.36	2016400.0
2016-05-11	CL	Stock	72.25	72.39	71.81	71.98	3044600.0
2016-05-11	A	Stock	42.19	43.2	42.12	42.46	3329000.0
2016-05-11	AA.B-DELISTED	Stock	34.0	34.02	33.28	33.28	17637.0
2016-05-11	AAAP-DELISTED	Stock	35.21	35.21	32.46	32.79	60089.0
2016-05-11	AABA-DELISTED	Stock	37.27	37.63	37.2	37.37	9471477.0
2016-05-11	AAC-DELISTED	Stock	21.58	21.71	21.165	21.38	37895.0
2016-05-11	AACG	Stock	5.51	5.58	5.26	5.3	6300.0
2016-05-11	AAIC-DELISTED	Stock	12.49	13.07	12.49	12.94	391132.0
2016-05-11	AAL	Stock	33.68	34.04	32.85	32.86	8148600.0
2016-05-11	AAMC-DELISTED	Stock	3.9912	4.2594	3.7118	3.7735	124420.0
2016-05-11	AAME	Stock	3.95	3.95	3.95	3.95	400.0
2016-05-11	AAMI	Stock	14.26	14.31	13.84	13.86	143000.0
2016-05-11	AAOI	Stock	8.45	9.24	8.435	9.14	951700.0
2016-05-11	AAON	Stock	18.8267	18.86	18.3933	18.3933	181800.0
2016-05-11	AAP	Stock	151.74	152.17	148.06	148.13	614400.0
2016-05-11	AAT	Stock	41.88	41.88	40.73	41.2	112200.0
2016-05-11	AAU-DELISTED	Stock	1.13	1.2359	1.11	1.21	571866.0
2016-05-11	AAUAF-DELISTED	Stock	1.13	1.2359	1.11	1.19	574597.0
2016-05-11	AAV-DELISTED	Stock	5.42	5.6	5.37	5.57	67600.0
2016-05-11	AAVL-DELISTED	Stock	4.3	4.3	4.13	4.14	258752.0
2016-05-11	AAWW-DELISTED	Stock	46.31	47.71	45.5	46.59	333768.0
2016-05-11	AAXJ	Stock	52.25	52.44	52.09	52.09	412036.0
2016-05-11	AAXN-DELISTED	Stock	19.33	20.0	19.2	19.79	1098502.0
2016-05-11	AB	Stock	23.07	23.49	22.88	22.93	255900.0
2016-05-11	ABAC-DELISTED	Stock	0.6999	0.6999	0.688	0.688	2000.0
2016-05-11	ABAX-DELISTED	Stock	44.39	44.9899	43.83	43.84	113706.0
2016-05-11	ABB-DELISTED	Stock	20.75	20.85	20.66	20.69	1253242.0
2016-05-11	ABBNY-DELISTED	Stock	20.75	20.85	20.66	20.7	1316413.0
2016-05-11	ABBV	Stock	63.77	63.83	62.64	62.7	9375200.0
2016-05-11	ABC-DELISTED	Stock	76.48	76.82	75.5	75.75	3087209.0
2016-05-11	ABCB	Stock	31.16	31.46	30.84	30.91	83300.0
2016-05-11	ABCD-DELISTED	Stock	4.25	4.33	4.2	4.2	19098.0
2016-05-11	ABCO-DELISTED	Stock	33.57	33.94	33.035	33.58	262236.0
2016-05-11	ABDC-DELISTED	Stock	11.06	11.57	11.054	11.56	50062.0
2016-05-11	ABE-DELISTED	Stock	11.92	11.92	11.86	11.92	700.0
2016-05-11	ABEO	Stock	61.25	62.0	60.25	61.0	924.0
2016-05-11	ABEV	Stock	5.5	5.51	5.39	5.44	11163700.0
2016-05-11	ABG	Stock	57.28	57.79	55.19	55.19	303600.0
2016-05-11	ABIL-DELISTED	Stock	3.36	3.48	3.21	3.38	21288.0
2016-05-11	ABM	Stock	33.27	33.34	32.78	32.95	163600.0
2016-05-11	ABMD-DELISTED	Stock	96.28	97.8	96.0033	96.1	353812.0

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

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