PREVIEW / stock_daily / 2016-06-24

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-24.parquet
  size:    218 KB
  rows:    6,572
  symbols: 3,276

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-24	AAPL	Stock	23.2275	23.665	23.1625	23.35	301245600.0
2016-06-24	MSFT	Stock	49.81	50.94	49.52	49.83	133503000.0
2016-06-24	NVDA	Stock	1.1625	1.184	1.1325	1.1432	1017684000.0
2016-06-24	AMZN	Stock	34.65	35.6265	34.61	34.948	152650000.0
2016-06-24	GOOGL	Stock	34.5085	35.25	34.2455	34.26	95435580.0
2016-06-24	META	Stock	111.01	113.68	111.0	112.08	40643100.0
2016-06-24	TSLA	Stock	12.67	13.008	12.6487	12.8767	105397500.0
2016-06-24	TLT	Stock	136.61	136.61	135.3	135.78	17155023.0
2016-06-24	ES	Stock	56.13	57.69	55.88	57.22	2366500.0
2016-06-24	CL	Stock	71.11	71.8	70.15	70.58	11070000.0
2016-06-24	A	Stock	44.56	45.07	43.92	44.12	5263600.0
2016-06-24	AA.B-DELISTED	Stock	33.25	33.8295	32.88	33.1	32045.0
2016-06-24	AAAP-DELISTED	Stock	28.99	29.16	27.59	28.75	50045.0
2016-06-24	AABA-DELISTED	Stock	36.42	36.95	36.085	36.24	18187383.0
2016-06-24	AAC-DELISTED	Stock	19.64	20.88	19.12	20.78	338489.0
2016-06-24	AACG	Stock	5.05	5.1	4.85	5.0	3300.0
2016-06-24	AAIC-DELISTED	Stock	13.5	13.9	13.36	13.56	566647.0
2016-06-24	AAL	Stock	28.2	28.5	27.04	27.05	36049900.0
2016-06-24	AAMC-DELISTED	Stock	4.6382	4.7647	4.4059	4.4059	354389.0
2016-06-24	AAME	Stock	4.02	4.02	3.96	3.99	1700.0
2016-06-24	AAMI	Stock	13.88	14.41	13.44	13.55	2096500.0
2016-06-24	AAOI	Stock	9.86	9.966	9.7	9.82	589600.0
2016-06-24	AAON	Stock	17.06	17.9	17.06	17.5133	407700.0
2016-06-24	AAP	Stock	151.0	155.97	150.92	154.52	1750800.0
2016-06-24	AAT	Stock	40.2	41.2	39.7	40.8	982600.0
2016-06-24	AAU-DELISTED	Stock	1.42	1.49	1.26	1.2853	849030.0
2016-06-24	AAUAF-DELISTED	Stock	1.42	1.49	1.26	1.2853	853610.0
2016-06-24	AAV-DELISTED	Stock	5.3	5.46	5.29	5.36	62048.0
2016-06-24	AAWW-DELISTED	Stock	40.75	41.76	40.05	40.31	243263.0
2016-06-24	AAXJ	Stock	52.49	53.36	52.06	52.29	2196236.0
2016-06-24	AAXN-DELISTED	Stock	22.43	23.41	22.25	23.0	1405806.0
2016-06-24	AB	Stock	22.39	22.78	22.1	22.59	300100.0
2016-06-24	ABAC-DELISTED	Stock	0.74	0.798	0.74	0.7926	9922.0
2016-06-24	ABAX-DELISTED	Stock	45.12	46.42	44.39	44.71	122141.0
2016-06-24	ABB-DELISTED	Stock	20.0	20.39	19.84	19.87	4105485.0
2016-06-24	ABBNY-DELISTED	Stock	20.0	20.39	19.84	19.88	4212960.0
2016-06-24	ABBV	Stock	59.26	60.6	59.18	59.86	9878500.0
2016-06-24	ABC-DELISTED	Stock	75.08	75.85	75.04	75.48	4073141.0
2016-06-24	ABCB	Stock	28.98	29.35	28.73	28.99	1117700.0
2016-06-24	ABCD-DELISTED	Stock	4.52	4.64	4.51	4.62	150680.0
2016-06-24	ABCO-DELISTED	Stock	34.44	35.19	34.26	35.0	463284.0
2016-06-24	ABDC-DELISTED	Stock	12.13	12.29	12.13	12.18	50536.0
2016-06-24	ABE-DELISTED	Stock	11.78	11.915	11.65	11.75	3661.0
2016-06-24	ABEO	Stock	64.25	66.75	61.5	64.0	36328.0
2016-06-24	ABEOW-DELISTED	Stock	0.95	0.95	0.95	0.95	100.0
2016-06-24	ABEV	Stock	5.33	5.47	5.32	5.45	11033900.0
2016-06-24	ABG	Stock	52.32	53.62	52.14	53.33	528800.0
2016-06-24	ABIL-DELISTED	Stock	4.0	4.22	4.0	4.2095	19178.0
2016-06-24	ABM	Stock	35.85	36.05	35.54	35.74	531900.0
2016-06-24	ABMD-DELISTED	Stock	99.0	103.98	99.0	100.11	3248028.0

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

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