PREVIEW / stock_daily / 2016-07-13

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-13.parquet
  size:    218 KB
  rows:    6,517
  symbols: 3,234

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-07-13	AAPL	Stock	24.3525	24.4175	24.21	24.2175	103568800.0
2016-07-13	MSFT	Stock	53.56	53.86	53.18	53.51	25356800.0
2016-07-13	NVDA	Stock	1.3225	1.33	1.3175	1.3195	324604000.0
2016-07-13	AMZN	Stock	37.338	37.8435	37.0625	37.1315	82846000.0
2016-07-13	GOOGL	Stock	36.776	36.776	36.451	36.474	20436540.0
2016-07-13	META	Stock	118.39	118.4	116.68	116.78	16207700.0
2016-07-13	TSLA	Stock	15.0333	15.0393	14.686	14.8353	53506500.0
2016-07-13	TLT	Stock	141.37	141.77	140.95	141.65	8181672.0
2016-07-13	ES	Stock	58.09	58.4	57.98	58.31	2151300.0
2016-07-13	CL	Stock	74.18	74.5	73.89	74.47	2648300.0
2016-07-13	A	Stock	46.64	46.82	46.33	46.41	1852400.0
2016-07-13	AA.B-DELISTED	Stock	36.7426	36.9099	36.2001	36.7	36041.0
2016-07-13	AAAP-DELISTED	Stock	31.0	31.0	30.83	30.85	8260.0
2016-07-13	AABA-DELISTED	Stock	38.02	38.02	37.46	37.64	8612933.0
2016-07-13	AAC-DELISTED	Stock	22.37	22.76	22.11	22.45	99654.0
2016-07-13	AACG	Stock	4.2	4.34	4.2	4.32	7400.0
2016-07-13	AAIC-DELISTED	Stock	13.3	13.3	13.06	13.21	162844.0
2016-07-13	AAL	Stock	35.0	35.29	34.12	34.45	15215100.0
2016-07-13	AAMC-DELISTED	Stock	4.1235	4.3265	3.9794	4.0912	106097.0
2016-07-13	AAMI	Stock	13.87	13.94	13.55	13.79	179300.0
2016-07-13	AAOI	Stock	11.62	11.79	11.52	11.58	201700.0
2016-07-13	AAON	Stock	18.9133	19.1333	18.7733	18.9467	243300.0
2016-07-13	AAP	Stock	164.15	164.73	160.54	162.91	906100.0
2016-07-13	AAT	Stock	43.87	44.7	43.5	44.67	248100.0
2016-07-13	AAU-DELISTED	Stock	1.47	1.5201	1.42	1.5199	557788.0
2016-07-13	AAUAF-DELISTED	Stock	1.47	1.5201	1.42	1.5199	561369.0
2016-07-13	AAV-DELISTED	Stock	5.86	5.97	5.75	5.81	63775.0
2016-07-13	AAWW-DELISTED	Stock	43.08	43.15	42.12	42.71	99877.0
2016-07-13	AAXJ	Stock	56.23	56.26	55.925	56.19	687988.0
2016-07-13	AAXN-DELISTED	Stock	27.04	27.3331	26.71	27.01	1270177.0
2016-07-13	AB	Stock	23.49	23.63	23.21	23.41	138400.0
2016-07-13	ABAC-DELISTED	Stock	0.76	0.8	0.7524	0.8	4433.0
2016-07-13	ABAX-DELISTED	Stock	52.86	53.5	52.54	53.37	175141.0
2016-07-13	ABB-DELISTED	Stock	19.69	19.7199	19.561	19.63	1314534.0
2016-07-13	ABBNY-DELISTED	Stock	19.69	19.7199	19.561	19.63	1352241.0
2016-07-13	ABBV	Stock	64.81	65.04	64.25	64.77	7684200.0
2016-07-13	ABC-DELISTED	Stock	84.53	85.35	84.33	84.93	2268940.0
2016-07-13	ABCB	Stock	30.53	30.66	30.39	30.53	152100.0
2016-07-13	ABCD-DELISTED	Stock	4.92	4.97	4.88	4.91	15807.0
2016-07-13	ABCO-DELISTED	Stock	39.28	39.93	38.2	39.35	243065.0
2016-07-13	ABDC-DELISTED	Stock	12.352	12.37	12.3	12.31	27795.0
2016-07-13	ABE-DELISTED	Stock	12.48	12.6	12.45	12.52	4864.0
2016-07-13	ABEO	Stock	61.25	62.5	58.75	60.75	2328.0
2016-07-13	ABEV	Stock	5.8	5.82	5.75	5.8	6803900.0
2016-07-13	ABG	Stock	57.05	57.23	55.84	56.69	109000.0
2016-07-13	ABIL-DELISTED	Stock	4.42	4.44	4.31	4.395	20219.0
2016-07-13	ABM	Stock	37.32	37.4	37.12	37.24	189400.0
2016-07-13	ABMD-DELISTED	Stock	118.53	119.72	116.82	117.51	567054.0
2016-07-13	ABR	Stock	7.2	7.25	7.2	7.25	65400.0
2016-07-13	ABR.A-DELISTED	Stock	25.59	25.63	25.45	25.63	1828.0

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

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