PREVIEW / stock_daily / 2016-01-15

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-15.parquet
  size:    220 KB
  rows:    6,647
  symbols: 3,394

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-01-15	AAPL	Stock	24.05	24.4275	23.84	24.2825	319335600.0
2016-01-15	MSFT	Stock	51.31	51.97	50.34	50.99	71820700.0
2016-01-15	NVDA	Stock	0.688	0.6962	0.666	0.6778	841452000.0
2016-01-15	AMZN	Stock	28.612	29.231	28.265	28.509	155690000.0
2016-01-15	GOOGL	Stock	35.4995	36.2079	35.0755	35.5245	76675020.0
2016-01-15	META	Stock	93.98	96.38	93.54	94.97	46132800.0
2016-01-15	TSLA	Stock	13.2647	13.6713	13.15	13.666	83679000.0
2016-01-15	TLT	Stock	125.4	125.96	125.08	125.752	13976332.0
2016-01-15	ES	Stock	51.3	51.72	50.82	51.39	3195700.0
2016-01-15	CL	Stock	62.37	63.92	62.32	63.35	6703000.0
2016-01-15	A	Stock	36.67	37.56	36.55	37.11	2994400.0
2016-01-15	AA.B-DELISTED	Stock	25.25	25.25	24.41	24.85	50609.0
2016-01-15	AAAP-DELISTED	Stock	24.85	26.024	24.01	24.68	37976.0
2016-01-15	AABA-DELISTED	Stock	29.28	29.77	28.585	29.14	16774017.0
2016-01-15	AAC-DELISTED	Stock	16.91	16.96	16.185	16.76	155440.0
2016-01-15	AACG	Stock	5.33	5.6	5.27	5.55	71700.0
2016-01-15	AAIC-DELISTED	Stock	10.94	10.99	10.1801	10.76	504276.0
2016-01-15	AAL	Stock	39.04	39.89	38.37	38.76	18924800.0
2016-01-15	AAMC-DELISTED	Stock	4.8529	5.0706	4.5382	5.0206	196765.0
2016-01-15	AAME	Stock	4.55	4.55	4.2	4.45	14200.0
2016-01-15	AAMI	Stock	11.61	11.91	11.32	11.79	269500.0
2016-01-15	AAOI	Stock	13.64	13.83	12.94	13.42	212800.0
2016-01-15	AAON	Stock	12.9267	13.2733	12.7667	13.22	331800.0
2016-01-15	AAP	Stock	138.03	144.71	137.66	144.29	1333100.0
2016-01-15	AAT	Stock	36.29	36.7	35.91	36.66	227500.0
2016-01-15	AAU-DELISTED	Stock	0.5633	0.5726	0.555	0.5685	122261.0
2016-01-15	AAUAF-DELISTED	Stock	0.5633	0.5726	0.555	0.5685	123256.0
2016-01-15	AAV-DELISTED	Stock	4.51	4.72	4.48	4.72	86512.0
2016-01-15	AAVL-DELISTED	Stock	5.79	6.09	5.73	6.08	328283.0
2016-01-15	AAWW-DELISTED	Stock	33.01	33.86	31.99	33.32	210524.0
2016-01-15	AAXJ	Stock	47.55	47.665	46.83	47.37	1154502.0
2016-01-15	AAXN-DELISTED	Stock	14.68	15.205	14.245	14.63	2208176.0
2016-01-15	AB	Stock	19.61	19.93	19.19	19.45	254700.0
2016-01-15	ABAC-DELISTED	Stock	0.8	0.849	0.69	0.791	26600.0
2016-01-15	ABAX-DELISTED	Stock	48.97	51.09	48.01	51.02	132437.0
2016-01-15	ABB-DELISTED	Stock	16.13	16.28	15.98	16.05	3070174.0
2016-01-15	ABBNY-DELISTED	Stock	16.13	16.28	15.98	16.06	3149517.0
2016-01-15	ABBV	Stock	53.01	57.41	53.01	57.34	27008800.0
2016-01-15	ABC-DELISTED	Stock	93.24	93.53	91.43	92.78	2912290.0
2016-01-15	ABCB	Stock	29.46	29.79	29.01	29.69	299300.0
2016-01-15	ABCD-DELISTED	Stock	4.41	4.51	4.25	4.46	67599.0
2016-01-15	ABCO-DELISTED	Stock	44.76	45.29	42.51	44.12	240409.0
2016-01-15	ABCW-DELISTED	Stock	41.96	42.89	41.96	42.49	157977.0
2016-01-15	ABDC-DELISTED	Stock	10.26	10.4	10.04	10.24	35080.0
2016-01-15	ABE-DELISTED	Stock	9.93	9.93	9.87	9.9	8686.0
2016-01-15	ABEO	Stock	71.5	72.25	63.0	69.75	5408.0
2016-01-15	ABEV	Stock	4.02	4.09	3.91	4.06	20311000.0
2016-01-15	ABG	Stock	48.54	49.18	46.88	48.06	345600.0
2016-01-15	ABGB-DELISTED	Stock	1.11	1.15	1.07	1.15	20538.0
2016-01-15	ABIL-DELISTED	Stock	9.29	9.35	9.0	9.24	36376.0

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

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