PREVIEW / stock_daily / 2016-01-12

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-12.parquet
  size:    220 KB
  rows:    6,618
  symbols: 3,376

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-12	AAPL	Stock	25.1375	25.1725	24.71	24.99	196616800.0
2016-01-12	MSFT	Stock	52.76	53.1	52.06	52.78	36095500.0
2016-01-12	NVDA	Stock	0.7553	0.7655	0.7492	0.7545	469356000.0
2016-01-12	AMZN	Stock	31.2625	31.2995	30.612	30.8945	94482000.0
2016-01-12	GOOGL	Stock	37.0375	37.417	36.8215	37.267	46815060.0
2016-01-12	META	Stock	99.0	99.96	97.55	99.37	28395400.0
2016-01-12	TSLA	Stock	14.1067	14.2493	13.6873	13.998	46378500.0
2016-01-12	TLT	Stock	122.34	124.32	122.15	123.77	12897720.0
2016-01-12	ES	Stock	51.27	51.44	50.4	51.12	1555400.0
2016-01-12	CL	Stock	63.27	63.5	62.67	63.38	2834900.0
2016-01-12	A	Stock	38.43	38.58	37.65	38.19	1989400.0
2016-01-12	AA.B-DELISTED	Stock	28.18	28.18	25.84	25.87	109982.0
2016-01-12	AAAP-DELISTED	Stock	27.96	28.0	23.54	24.7	73268.0
2016-01-12	AABA-DELISTED	Stock	30.58	30.97	30.21	30.69	12531890.0
2016-01-12	AAC-DELISTED	Stock	17.58	18.1789	16.46	16.9	186127.0
2016-01-12	AACG	Stock	5.05	5.63	5.05	5.35	37100.0
2016-01-12	AAIC-DELISTED	Stock	12.5	12.56	12.05	12.22	293237.0
2016-01-12	AAL	Stock	41.15	42.36	40.48	42.0	12636000.0
2016-01-12	AAMC-DELISTED	Stock	4.8971	5.2206	4.6824	4.8441	96002.0
2016-01-12	AAME	Stock	4.17	4.4	4.17	4.28	900.0
2016-01-12	AAMI	Stock	13.88	13.88	12.55	12.86	363100.0
2016-01-12	AAOI	Stock	14.93	15.1	14.31	14.93	207800.0
2016-01-12	AAON	Stock	13.8067	13.9733	13.3933	13.6933	252000.0
2016-01-12	AAP	Stock	147.52	148.97	145.74	148.07	1045400.0
2016-01-12	AAT	Stock	37.99	37.99	37.17	37.53	196500.0
2016-01-12	AAU-DELISTED	Stock	0.59	0.61	0.57	0.58	68301.0
2016-01-12	AAUAF-DELISTED	Stock	0.59	0.61	0.57	0.58	69067.0
2016-01-12	AAV-DELISTED	Stock	4.7	4.74	4.495	4.7	93560.0
2016-01-12	AAVL-DELISTED	Stock	6.77	7.01	6.06	6.33	409665.0
2016-01-12	AAWW-DELISTED	Stock	34.22	34.58	33.18	34.37	215643.0
2016-01-12	AAXJ	Stock	49.42	49.59	48.94	49.26	803321.0
2016-01-12	AAXN-DELISTED	Stock	16.02	16.4617	15.58	16.03	1226301.0
2016-01-12	AB	Stock	20.87	21.17	20.69	21.0	161900.0
2016-01-12	ABAC-DELISTED	Stock	0.93	0.94	0.93	0.9301	7682.0
2016-01-12	ABAX-DELISTED	Stock	51.02	51.95	50.74	51.915	88929.0
2016-01-12	ABB-DELISTED	Stock	16.59	16.69	16.44	16.66	3161116.0
2016-01-12	ABBNY-DELISTED	Stock	16.59	16.69	16.44	16.66	4156203.0
2016-01-12	ABBV	Stock	54.47	54.97	53.57	54.84	6799600.0
2016-01-12	ABC-DELISTED	Stock	94.45	95.51	93.78	94.17	3331218.0
2016-01-12	ABCB	Stock	31.54	31.88	30.62	31.03	219600.0
2016-01-12	ABCD-DELISTED	Stock	4.62	4.78	4.51	4.68	59893.0
2016-01-12	ABCO-DELISTED	Stock	46.25	47.39	45.99	46.58	316371.0
2016-01-12	ABCW-DELISTED	Stock	44.81	45.5	44.09	44.18	337536.0
2016-01-12	ABDC-DELISTED	Stock	11.54	11.58	11.07	11.1	21626.0
2016-01-12	ABE-DELISTED	Stock	10.25	10.25	10.14	10.2089	14233.0
2016-01-12	ABEO	Stock	70.75	73.75	64.25	67.0	5068.0
2016-01-12	ABEOW-DELISTED	Stock	0.89	0.89	0.89	0.89	436.0
2016-01-12	ABEV	Stock	4.19	4.21	4.12	4.2	20734300.0
2016-01-12	ABG	Stock	54.9	54.94	51.0	52.56	750800.0
2016-01-12	ABGB-DELISTED	Stock	1.28	1.28	1.23	1.2301	5430.0

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

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