PREVIEW / stock_daily / 2014-06-02

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-02.parquet
  size:    219 KB
  rows:    6,553
  symbols: 3,556

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
2014-06-02	AAPL	Stock	22.6414	22.6725	22.2321	22.4518	369350800.0
2014-06-02	MSFT	Stock	40.95	41.09	40.68	40.79	18504300.0
2014-06-02	NVDA	Stock	0.4765	0.4795	0.4695	0.4735	181500000.0
2014-06-02	AMZN	Stock	15.6295	15.63	15.35	15.442	44068000.0
2014-06-02	GOOGL	Stock	28.4875	28.5205	27.835	28.217	33272800.0
2014-06-02	META	Stock	63.23	63.59	62.05	63.08	35996000.0
2014-06-02	TSLA	Stock	13.822	13.9567	13.4447	13.6467	70021500.0
2014-06-02	TLT	Stock	113.04	113.68	112.55	112.96	11728400.0
2014-06-02	ES	Stock	45.37	45.52	45.25	45.34	831800.0
2014-06-02	CL	Stock	68.13	68.27	67.81	68.21	2924900.0
2014-06-02	A	Stock	40.7439	40.7654	40.2718	40.6938	1782170.0
2014-06-02	AABA-DELISTED	Stock	34.69	34.95	34.2828	34.875	8625987.0
2014-06-02	AACG	Stock	5.3	5.48	5.28	5.36	22200.0
2014-06-02	AAIC-DELISTED	Stock	27.65	27.78	27.57	27.68	138789.0
2014-06-02	AAL	Stock	40.0	41.25	40.0	41.22	9902100.0
2014-06-02	AAMC-DELISTED	Stock	287.0647	292.6471	287.0647	289.7059	12791.0
2014-06-02	AAME	Stock	3.65	3.65	3.51	3.52	6600.0
2014-06-02	AAOI	Stock	21.36	21.5	20.02	20.5	177800.0
2014-06-02	AAON	Stock	14.0533	14.2044	13.76	13.9733	302400.0
2014-06-02	AAP	Stock	124.22	124.49	123.2	124.47	509700.0
2014-06-02	AAT	Stock	34.33	34.41	34.12	34.22	310200.0
2014-06-02	AAU-DELISTED	Stock	1.31	1.32	1.29	1.29	104332.0
2014-06-02	AAUAF-DELISTED	Stock	1.31	1.32	1.29	1.29	105342.0
2014-06-02	AAV-DELISTED	Stock	6.29	6.3699	6.11	6.19	759044.0
2014-06-02	AAWW-DELISTED	Stock	36.61	36.7	35.57	35.66	113945.0
2014-06-02	AAXJ	Stock	62.22	62.22	62.02	62.08	712665.0
2014-06-02	AAXN-DELISTED	Stock	13.28	13.355	13.04	13.325	540446.0
2014-06-02	AB	Stock	24.27	24.68	24.13	24.51	664800.0
2014-06-02	ABAC-DELISTED	Stock	2.22	2.22	2.11	2.16	34307.0
2014-06-02	ABAX-DELISTED	Stock	41.47	42.07	40.96	41.87	122266.0
2014-06-02	ABB-DELISTED	Stock	23.69	23.695	23.47	23.485	2473542.0
2014-06-02	ABBNY-DELISTED	Stock	23.69	23.695	23.47	23.48	2700620.0
2014-06-02	ABBV	Stock	54.43	54.95	53.91	54.15	3635000.0
2014-06-02	ABC-DELISTED	Stock	73.31	73.79	73.08	73.22	1395448.0
2014-06-02	ABCB	Stock	20.99	21.45	20.58	21.11	82700.0
2014-06-02	ABCD-DELISTED	Stock	2.23	2.24	2.16	2.17	22553.0
2014-06-02	ABCO-DELISTED	Stock	48.45	48.96	47.69	48.56	207953.0
2014-06-02	ABDC-DELISTED	Stock	14.91	15.0	14.85	14.96	4727.0
2014-06-02	ABE-DELISTED	Stock	14.01	14.13	14.01	14.11	14401.0
2014-06-02	ABEO	Stock	537.5	575.0	500.0	575.0	1.0
2014-06-02	ABEV	Stock	7.06	7.14	7.04	7.09	9392400.0
2014-06-02	ABG	Stock	64.98	64.98	63.82	64.4	180500.0
2014-06-02	ABGB-DELISTED	Stock	23.81	24.25	23.81	24.09	15634.0
2014-06-02	ABIL-DELISTED	Stock	9.66	9.66	9.66	9.66	248.0
2014-06-02	ABM	Stock	27.26	27.66	26.86	27.38	214700.0
2014-06-02	ABMD-DELISTED	Stock	22.75	23.05	22.4	22.9	579006.0
2014-06-02	ABR	Stock	7.32	7.32	7.2	7.26	59000.0
2014-06-02	ABR.A-DELISTED	Stock	24.41	24.4899	24.39	24.39	2926.0
2014-06-02	ABR.B-DELISTED	Stock	23.84	23.91	23.67	23.7	14825.0
2014-06-02	ABR.C-DELISTED	Stock	25.08	25.08	24.87	25.0199	4481.0

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

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