PREVIEW / stock_daily / 2016-05-24

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-24.parquet
  size:    218 KB
  rows:    6,560
  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-24	AAPL	Stock	24.305	24.5225	24.21	24.475	140560800.0
2016-05-24	MSFT	Stock	50.7	51.71	50.4	51.59	34757900.0
2016-05-24	NVDA	Stock	1.1105	1.1375	1.1075	1.134	415788000.0
2016-05-24	AMZN	Stock	34.9005	35.375	34.9	35.21	60676000.0
2016-05-24	GOOGL	Stock	35.9925	36.71	35.9822	36.6515	37883220.0
2016-05-24	META	Stock	116.24	117.73	116.12	117.7	20183600.0
2016-05-24	TSLA	Stock	14.44	14.5827	14.3453	14.5273	45207000.0
2016-05-24	TLT	Stock	129.97	130.19	129.24	129.86	5968275.0
2016-05-24	ES	Stock	54.2	54.73	53.95	54.67	1649600.0
2016-05-24	CL	Stock	70.43	71.08	70.33	70.87	2515500.0
2016-05-24	A	Stock	44.76	45.29	44.7	45.03	3236300.0
2016-05-24	AA.B-DELISTED	Stock	32.49	33.0678	32.49	32.99	32855.0
2016-05-24	AAAP-DELISTED	Stock	29.17	29.6425	28.045	28.975	49428.0
2016-05-24	AABA-DELISTED	Stock	36.83	37.63	36.77	37.53	9803474.0
2016-05-24	AAC-DELISTED	Stock	20.0	21.0	19.55	20.89	114146.0
2016-05-24	AACG	Stock	4.98	5.08	4.98	5.05	5500.0
2016-05-24	AAIC-DELISTED	Stock	12.79	13.0	12.71	12.94	414404.0
2016-05-24	AAL	Stock	31.89	32.28	31.85	32.15	6962700.0
2016-05-24	AAMC-DELISTED	Stock	4.147	4.2647	4.0585	4.1235	77000.0
2016-05-24	AAME	Stock	3.22	3.44	3.22	3.35	4000.0
2016-05-24	AAMI	Stock	14.0	15.09	13.87	14.95	462100.0
2016-05-24	AAOI	Stock	10.0	10.35	9.78	10.2	483100.0
2016-05-24	AAON	Stock	18.3333	18.8133	18.3333	18.76	181950.0
2016-05-24	AAP	Stock	144.9	149.95	144.9	149.34	1126800.0
2016-05-24	AAT	Stock	39.35	39.81	39.35	39.74	89500.0
2016-05-24	AAU-DELISTED	Stock	1.08	1.08	1.02	1.0299	290104.0
2016-05-24	AAUAF-DELISTED	Stock	1.08	1.08	1.02	1.03	291927.0
2016-05-24	AAV-DELISTED	Stock	5.77	5.8	5.7	5.74	45501.0
2016-05-24	AAWW-DELISTED	Stock	43.24	44.82	42.76	44.39	214345.0
2016-05-24	AAXJ	Stock	51.52	51.97	51.5	51.88	404794.0
2016-05-24	AAXN-DELISTED	Stock	21.51	21.92	21.47	21.85	711903.0
2016-05-24	AB	Stock	23.13	23.45	23.03	23.23	406600.0
2016-05-24	ABAC-DELISTED	Stock	0.671	0.72	0.63	0.71	15622.0
2016-05-24	ABAX-DELISTED	Stock	44.51	46.04	44.06	45.83	154440.0
2016-05-24	ABB-DELISTED	Stock	20.42	20.59	20.415	20.535	1559485.0
2016-05-24	ABBNY-DELISTED	Stock	20.42	20.59	20.415	20.54	1613587.0
2016-05-24	ABBV	Stock	59.73	60.91	59.52	60.7	8888100.0
2016-05-24	ABC-DELISTED	Stock	74.37	74.59	73.89	74.32	1719643.0
2016-05-24	ABCB	Stock	30.9	31.25	30.77	31.15	960000.0
2016-05-24	ABCD-DELISTED	Stock	4.54	4.61	4.54	4.6	21713.0
2016-05-24	ABCO-DELISTED	Stock	31.38	31.98	31.01	31.84	618393.0
2016-05-24	ABDC-DELISTED	Stock	12.18	12.33	11.737	11.99	28812.0
2016-05-24	ABE-DELISTED	Stock	11.51	11.63	11.51	11.63	1450.0
2016-05-24	ABEO	Stock	64.25	68.25	62.5	66.75	3464.0
2016-05-24	ABEOW-DELISTED	Stock	0.7226	0.75	0.71	0.75	12200.0
2016-05-24	ABEV	Stock	5.15	5.2	5.13	5.19	8034500.0
2016-05-24	ABG	Stock	52.68	54.04	52.26	53.6	241900.0
2016-05-24	ABIL-DELISTED	Stock	2.785	2.785	2.6	2.7	70056.0
2016-05-24	ABM	Stock	33.11	33.59	32.89	33.52	229100.0
2016-05-24	ABMD-DELISTED	Stock	97.6	99.82	97.4001	99.62	368326.0

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

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