PREVIEW / stock_daily / 2015-03-17

all stock daily files

  file:    by_date/stock_daily/2015/2015-03-17.parquet
  size:    223 KB
  rows:    6,619
  symbols: 3,506

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-03-17	AAPL	Stock	31.475	31.83	31.4125	31.76	204092400.0
2015-03-17	MSFT	Stock	41.37	41.83	41.15	41.7	31673400.0
2015-03-17	NVDA	Stock	0.573	0.5815	0.569	0.5812	299900000.0
2015-03-17	AMZN	Stock	18.5555	18.725	18.482	18.596	40740000.0
2015-03-17	GOOGL	Stock	27.9145	28.032	27.7205	27.8805	28891200.0
2015-03-17	META	Stock	78.36	79.78	78.34	79.36	22170000.0
2015-03-17	TSLA	Stock	13.0287	13.2473	12.9293	12.982	73411500.0
2015-03-17	TLT	Stock	128.55	129.1099	128.28	129.0	6313964.0
2015-03-17	ES	Stock	49.68	50.11	49.28	49.53	1938200.0
2015-03-17	CL	Stock	68.55	68.81	68.33	68.41	2843100.0
2015-03-17	A	Stock	41.52	41.69	41.06	41.58	1504900.0
2015-03-17	AA.B-DELISTED	Stock	44.08	44.34	43.85	44.01	57894.0
2015-03-17	AABA-DELISTED	Stock	43.54	44.16	43.46	43.79	9037741.0
2015-03-17	AAC-DELISTED	Stock	28.65	30.74	28.65	29.55	379513.0
2015-03-17	AACG	Stock	4.02	4.02	3.85	3.85	13000.0
2015-03-17	AAIC-DELISTED	Stock	24.72	24.88	24.549	24.62	179218.0
2015-03-17	AAL	Stock	52.63	54.18	52.5	53.69	41837900.0
2015-03-17	AAMC-DELISTED	Stock	65.2941	65.2941	61.7853	61.7853	7181.0
2015-03-17	AAME	Stock	4.0	4.02	4.0	4.02	8900.0
2015-03-17	AAMI	Stock	17.43	18.25	17.24	18.01	226100.0
2015-03-17	AAOI	Stock	12.69	13.0	12.5	12.85	140700.0
2015-03-17	AAON	Stock	14.88	14.9933	14.76	14.84	178050.0
2015-03-17	AAP	Stock	151.02	151.69	149.83	150.0	531900.0
2015-03-17	AAT	Stock	42.46	42.66	42.32	42.55	97600.0
2015-03-17	AAU-DELISTED	Stock	0.887	0.9025	0.8725	0.8926	103116.0
2015-03-17	AAUAF-DELISTED	Stock	0.885	0.9	0.8701	0.8921	104390.0
2015-03-17	AAV-DELISTED	Stock	5.0	5.21	5.0	5.18	149188.0
2015-03-17	AAVL-DELISTED	Stock	41.68	42.25	40.92	42.06	209974.0
2015-03-17	AAWW-DELISTED	Stock	46.39	46.82	46.1532	46.53	109060.0
2015-03-17	AAXJ	Stock	62.16	62.63	62.07	62.59	1148389.0
2015-03-17	AAXN-DELISTED	Stock	23.38	23.7	23.24	23.44	921015.0
2015-03-17	AB	Stock	29.12	29.31	29.01	29.2	408000.0
2015-03-17	ABAX-DELISTED	Stock	63.62	64.57	63.42	64.13	127263.0
2015-03-17	ABB-DELISTED	Stock	20.38	20.4	20.2899	20.38	1421154.0
2015-03-17	ABBNY-DELISTED	Stock	20.38	20.4	20.2899	20.39	1549992.0
2015-03-17	ABBV	Stock	58.72	60.18	58.7	59.73	10983600.0
2015-03-17	ABC-DELISTED	Stock	109.94	110.71	109.27	110.37	1522121.0
2015-03-17	ABCB	Stock	26.32	26.45	26.11	26.16	68700.0
2015-03-17	ABCD-DELISTED	Stock	3.03	3.03	2.9405	2.98	5107.0
2015-03-17	ABCO-DELISTED	Stock	53.65	53.88	52.48	52.88	174929.0
2015-03-17	ABCW-DELISTED	Stock	34.12	34.45	33.97	34.44	2599.0
2015-03-17	ABDC-DELISTED	Stock	13.83	13.92	13.8	13.87	20358.0
2015-03-17	ABE-DELISTED	Stock	12.37	12.53	12.37	12.5	6565.0
2015-03-17	ABEO	Stock	84.75	87.25	77.75	82.0	1236.0
2015-03-17	ABEOW-DELISTED	Stock	0.84	0.84	0.84	0.84	600.0
2015-03-17	ABEV	Stock	5.55	5.67	5.54	5.64	10776200.0
2015-03-17	ABG	Stock	77.46	78.02	77.26	77.85	196200.0
2015-03-17	ABGB-DELISTED	Stock	15.66	16.085	15.55	16.03	23417.0
2015-03-17	ABIL-DELISTED	Stock	9.95	9.95	9.95	9.95	2500.0
2015-03-17	ABM	Stock	30.53	31.35	30.53	31.07	452100.0

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

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