PREVIEW / stock_daily / 2015-04-23

all stock daily files

  file:    by_date/stock_daily/2015/2015-04-23.parquet
  size:    223 KB
  rows:    6,636
  symbols: 3,509

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-23	AAPL	Stock	32.075	32.605	32.035	32.4175	183083600.0
2015-04-23	MSFT	Stock	42.89	43.61	42.8	43.34	46309500.0
2015-04-23	NVDA	Stock	0.5475	0.5608	0.5412	0.5555	259380000.0
2015-04-23	AMZN	Stock	19.5105	19.594	19.3075	19.4995	159600000.0
2015-04-23	GOOGL	Stock	27.5205	28.0585	27.504	27.873	78183100.0
2015-04-23	META	Stock	84.1	85.59	82.41	82.41	73728100.0
2015-04-23	TSLA	Stock	14.5513	14.7653	14.4767	14.5733	66168000.0
2015-04-23	TLT	Stock	127.8	128.85	127.61	128.27	6843409.0
2015-04-23	ES	Stock	49.56	49.85	49.37	49.62	1611300.0
2015-04-23	CL	Stock	68.93	69.5	68.79	69.22	2378200.0
2015-04-23	A	Stock	42.42	42.86	42.24	42.62	3972800.0
2015-04-23	AA.B-DELISTED	Stock	45.5	45.5	44.6	44.836	78357.0
2015-04-23	AABA-DELISTED	Stock	43.87	44.06	43.58	43.69	13311588.0
2015-04-23	AAC-DELISTED	Stock	33.46	34.5	32.86	33.03	183510.0
2015-04-23	AACG	Stock	4.58	4.64	4.57	4.64	40900.0
2015-04-23	AAIC-DELISTED	Stock	23.67	23.72	23.52	23.64	258558.0
2015-04-23	AAL	Stock	51.07	51.72	50.7	51.45	9821800.0
2015-04-23	AAMC-DELISTED	Stock	62.8735	65.4462	62.8735	65.0824	21920.0
2015-04-23	AAME	Stock	3.93	3.96	3.93	3.96	900.0
2015-04-23	AAMI	Stock	19.03	19.53	19.01	19.37	93900.0
2015-04-23	AAOI	Stock	14.58	15.03	14.42	15.0	115400.0
2015-04-23	AAON	Stock	16.2933	16.78	16.2933	16.6	241200.0
2015-04-23	AAP	Stock	153.65	153.98	146.54	146.69	1864300.0
2015-04-23	AAT	Stock	41.35	41.98	41.2	41.34	212700.0
2015-04-23	AAU-DELISTED	Stock	0.8102	0.8337	0.8102	0.83	71748.0
2015-04-23	AAUAF-DELISTED	Stock	0.8005	0.825	0.8005	0.825	72953.0
2015-04-23	AAV-DELISTED	Stock	5.98	6.09	5.98	6.0	161561.0
2015-04-23	AAVL-DELISTED	Stock	38.93	38.9599	38.15	38.41	145254.0
2015-04-23	AAWW-DELISTED	Stock	42.75	43.57	42.47	43.27	175983.0
2015-04-23	AAXJ	Stock	69.14	69.56	68.92	69.42	1448691.0
2015-04-23	AAXN-DELISTED	Stock	29.27	30.18	28.78	29.68	1553044.0
2015-04-23	AB	Stock	31.22	31.84	31.22	31.74	262900.0
2015-04-23	ABAC-DELISTED	Stock	1.7299	1.7299	1.6	1.66	26126.0
2015-04-23	ABAX-DELISTED	Stock	63.26	63.915	62.98	63.32	74372.0
2015-04-23	ABB-DELISTED	Stock	21.55	21.91	21.52	21.84	1303294.0
2015-04-23	ABBNY-DELISTED	Stock	21.55	21.91	21.52	21.83	1468631.0
2015-04-23	ABBV	Stock	65.26	65.31	62.73	64.25	18405300.0
2015-04-23	ABC-DELISTED	Stock	113.81	116.18	113.57	115.21	1921650.0
2015-04-23	ABCB	Stock	24.95	25.54	24.68	25.18	366000.0
2015-04-23	ABCD-DELISTED	Stock	3.08	3.08	3.0	3.01	29109.0
2015-04-23	ABCO-DELISTED	Stock	51.78	52.12	51.62	51.92	158014.0
2015-04-23	ABCW-DELISTED	Stock	34.15	34.53	33.97	34.53	5399.0
2015-04-23	ABDC-DELISTED	Stock	13.65	13.88	13.65	13.83	23487.0
2015-04-23	ABE-DELISTED	Stock	13.41	13.68	13.32	13.55	12675.0
2015-04-23	ABEO	Stock	85.0	96.25	78.5	90.75	28112.0
2015-04-23	ABEOW-DELISTED	Stock	1.35	1.54	1.34	1.54	11010.0
2015-04-23	ABEV	Stock	6.25	6.36	6.23	6.33	25217200.0
2015-04-23	ABG	Stock	86.99	88.34	86.95	87.59	335700.0
2015-04-23	ABGB-DELISTED	Stock	15.9	16.08	15.77	16.04	34219.0
2015-04-23	ABIL-DELISTED	Stock	9.95	11.0	9.8	11.0	23228.0

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

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