PREVIEW / stock_daily / 2015-04-02

all stock daily files

  file:    by_date/stock_daily/2015/2015-04-02.parquet
  size:    223 KB
  rows:    6,647
  symbols: 3,514

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
2015-04-02	AAPL	Stock	31.2575	31.39	31.0475	31.33	128880400.0
2015-04-02	MSFT	Stock	40.66	40.74	40.12	40.29	37487500.0
2015-04-02	NVDA	Stock	0.5282	0.5298	0.522	0.5265	192204000.0
2015-04-02	AMZN	Stock	18.525	18.664	18.45	18.6125	37506000.0
2015-04-02	GOOGL	Stock	27.3705	27.4	27.022	27.0655	47760380.0
2015-04-02	META	Stock	82.25	82.56	81.44	81.56	19664100.0
2015-04-02	TSLA	Stock	12.682	12.882	12.6667	12.7333	75156000.0
2015-04-02	TLT	Stock	131.93	131.97	130.61	130.73	6663396.0
2015-04-02	ES	Stock	50.69	51.09	50.59	50.64	978500.0
2015-04-02	CL	Stock	69.05	69.45	68.81	69.33	1914000.0
2015-04-02	A	Stock	41.47	42.13	41.33	42.05	2135900.0
2015-04-02	AA.B-DELISTED	Stock	44.0	44.6499	43.87	44.54	109763.0
2015-04-02	AABA-DELISTED	Stock	44.11	44.36	43.68	44.14	11516857.0
2015-04-02	AAC-DELISTED	Stock	30.69	31.1299	30.52	30.98	136969.0
2015-04-02	AACG	Stock	3.91	3.99	3.89	3.89	1900.0
2015-04-02	AAIC-DELISTED	Stock	23.95	24.14	23.9	23.94	221038.0
2015-04-02	AAL	Stock	50.48	50.85	49.15	49.18	14109800.0
2015-04-02	AAMC-DELISTED	Stock	60.4176	62.6471	58.9471	62.3529	123971.0
2015-04-02	AAME	Stock	3.96	3.96	3.96	3.96	100.0
2015-04-02	AAMI	Stock	18.61	18.762	18.27	18.6	167300.0
2015-04-02	AAOI	Stock	13.4	13.79	13.164	13.46	178700.0
2015-04-02	AAON	Stock	15.9	16.0	15.8333	15.9	164100.0
2015-04-02	AAP	Stock	143.95	145.65	143.02	143.98	1530000.0
2015-04-02	AAT	Stock	43.04	43.73	43.03	43.24	124900.0
2015-04-02	AAU-DELISTED	Stock	0.868	0.91	0.8674	0.87	234459.0
2015-04-02	AAUAF-DELISTED	Stock	0.8505	0.89	0.85	0.87	240636.0
2015-04-02	AAV-DELISTED	Stock	5.5	5.62	5.44	5.6	264971.0
2015-04-02	AAVL-DELISTED	Stock	38.91	39.0	37.55	38.02	249420.0
2015-04-02	AAWW-DELISTED	Stock	43.48	43.78	42.93	42.94	101828.0
2015-04-02	AAXJ	Stock	64.93	65.38	64.9	65.3	670918.0
2015-04-02	AAXN-DELISTED	Stock	24.21	24.472	24.04	24.435	696668.0
2015-04-02	AB	Stock	30.95	31.2	30.74	30.9	225200.0
2015-04-02	ABAC-DELISTED	Stock	1.56	1.71	1.48	1.65	58026.0
2015-04-02	ABAX-DELISTED	Stock	64.09	64.12	63.02	63.06	94992.0
2015-04-02	ABB-DELISTED	Stock	21.48	21.63	21.45	21.49	1550728.0
2015-04-02	ABBNY-DELISTED	Stock	21.48	21.63	21.45	21.49	1599610.0
2015-04-02	ABBV	Stock	57.44	57.81	56.9	57.01	8787000.0
2015-04-02	ABC-DELISTED	Stock	112.16	112.59	111.58	112.37	1864388.0
2015-04-02	ABCB	Stock	26.61	27.01	26.59	26.87	188700.0
2015-04-02	ABCD-DELISTED	Stock	3.24	3.24	3.16	3.19	18365.0
2015-04-02	ABCO-DELISTED	Stock	52.01	53.09	51.672	52.98	255032.0
2015-04-02	ABCW-DELISTED	Stock	34.7	34.7	34.7	34.7	239.0
2015-04-02	ABDC-DELISTED	Stock	13.61	13.61	13.5093	13.55	44834.0
2015-04-02	ABE-DELISTED	Stock	12.74	12.9799	12.74	12.84	12838.0
2015-04-02	ABEO	Stock	76.25	82.25	76.25	79.25	4136.0
2015-04-02	ABEOW-DELISTED	Stock	0.95	1.04	0.95	1.0399	1600.0
2015-04-02	ABEV	Stock	6.03	6.1	5.94	6.04	22538300.0
2015-04-02	ABG	Stock	82.75	84.27	82.75	83.79	307000.0
2015-04-02	ABGB-DELISTED	Stock	18.42	18.91	18.4	18.84	65539.0
2015-04-02	ABIL-DELISTED	Stock	10.08	10.09	10.04	10.04	165900.0

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

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