PREVIEW / stock_daily / 2014-05-28

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-28.parquet
  size:    220 KB
  rows:    6,572
  symbols: 3,568

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-05-28	AAPL	Stock	22.3579	22.4939	22.2779	22.2861	315481600.0
2014-05-28	MSFT	Stock	40.14	40.19	39.82	40.01	25711500.0
2014-05-28	NVDA	Stock	0.4723	0.4775	0.4678	0.4745	224676000.0
2014-05-28	AMZN	Stock	15.475	15.691	15.371	15.508	54520000.0
2014-05-28	GOOGL	Stock	28.7285	28.883	28.4976	28.5225	31631520.0
2014-05-28	META	Stock	63.39	64.14	62.62	63.51	47795000.0
2014-05-28	TSLA	Stock	14.0013	14.1847	13.684	14.016	82426500.0
2014-05-28	TLT	Stock	114.1	114.84	114.09	114.76	10360973.0
2014-05-28	ES	Stock	44.89	45.15	44.85	45.13	1114600.0
2014-05-28	CL	Stock	66.7	66.71	66.1	66.12	3281200.0
2014-05-28	A	Stock	40.3505	40.9371	40.279	40.8512	2518777.0
2014-05-28	AABA-DELISTED	Stock	35.06	35.17	34.42	34.78	16403012.0
2014-05-28	AACG	Stock	4.9	5.0	4.87	4.96	15200.0
2014-05-28	AAIC-DELISTED	Stock	27.45	27.55	27.31	27.42	156719.0
2014-05-28	AAL	Stock	39.4	40.33	39.19	39.8	11132400.0
2014-05-28	AAMC-DELISTED	Stock	293.5118	293.5118	276.6059	279.7059	32569.0
2014-05-28	AAME	Stock	3.54	3.61	3.47	3.6	10800.0
2014-05-28	AAOI	Stock	19.38	20.58	19.38	20.39	208600.0
2014-05-28	AAON	Stock	14.04	14.0844	13.84	13.9422	153900.0
2014-05-28	AAP	Stock	121.42	121.8	120.0	121.11	529300.0
2014-05-28	AAT	Stock	34.5	34.74	34.3	34.49	171000.0
2014-05-28	AAU-DELISTED	Stock	1.3	1.32	1.28	1.3	61421.0
2014-05-28	AAUAF-DELISTED	Stock	1.29	1.31	1.28	1.3	62050.0
2014-05-28	AAV-DELISTED	Stock	5.64	5.79	5.56	5.76	200026.0
2014-05-28	AAWW-DELISTED	Stock	37.16	37.31	36.47	37.3	137744.0
2014-05-28	AAXJ	Stock	61.98	62.23	61.953	62.16	849664.0
2014-05-28	AAXN-DELISTED	Stock	13.39	13.61	13.19	13.26	536288.0
2014-05-28	AB	Stock	23.78	23.78	23.3	23.63	204900.0
2014-05-28	ABAC-DELISTED	Stock	2.2499	2.38	2.2	2.26	194997.0
2014-05-28	ABAX-DELISTED	Stock	41.94	41.94	40.89	41.48	104893.0
2014-05-28	ABB-DELISTED	Stock	23.71	23.82	23.69	23.74	725178.0
2014-05-28	ABBNY-DELISTED	Stock	23.71	23.82	23.69	23.75	937001.0
2014-05-28	ABBV	Stock	53.96	54.61	53.82	54.07	4108300.0
2014-05-28	ABC-DELISTED	Stock	72.36	72.84	72.09	72.66	2048875.0
2014-05-28	ABCB	Stock	21.22	21.22	20.91	21.01	41300.0
2014-05-28	ABCD-DELISTED	Stock	2.2501	2.33	2.2299	2.25	7500.0
2014-05-28	ABCO-DELISTED	Stock	49.68	50.56	49.09	49.16	157939.0
2014-05-28	ABDC-DELISTED	Stock	14.85	15.0	14.8	14.91	24991.0
2014-05-28	ABE-DELISTED	Stock	14.1	14.1122	14.0556	14.1122	6721.0
2014-05-28	ABEO	Stock	525.0	575.0	525.0	575.0	2.0
2014-05-28	ABEV	Stock	7.14	7.22	7.1	7.17	6935000.0
2014-05-28	ABG	Stock	64.79	64.98	64.32	64.35	175800.0
2014-05-28	ABGB-DELISTED	Stock	22.04	22.2399	21.99	22.1	8084.0
2014-05-28	ABIL-DELISTED	Stock	9.77	9.77	9.77	9.77	232.0
2014-05-28	ABM	Stock	27.45	27.58	27.17	27.2	133500.0
2014-05-28	ABMD-DELISTED	Stock	21.46	21.96	21.41	21.71	277131.0
2014-05-28	ABR	Stock	7.14	7.16	7.09	7.16	183300.0
2014-05-28	ABR.A-DELISTED	Stock	24.25	24.4	24.2499	24.2999	40530.0
2014-05-28	ABR.B-DELISTED	Stock	23.8	23.8399	23.7701	23.7701	3800.0
2014-05-28	ABR.C-DELISTED	Stock	24.89	25.06	24.89	25.06	5515.0

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

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