PREVIEW / stock_daily / 2014-07-07

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-07.parquet
  size:    221 KB
  rows:    6,627
  symbols: 3,590

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-07-07	AAPL	Stock	23.535	23.9975	23.525	23.9925	225872000.0
2014-07-07	MSFT	Stock	41.75	42.12	41.71	41.99	21952400.0
2014-07-07	NVDA	Stock	0.472	0.4723	0.4668	0.4675	127496000.0
2014-07-07	AMZN	Stock	16.875	16.8775	16.626	16.6775	42578000.0
2014-07-07	GOOGL	Stock	29.6755	29.7822	29.397	29.538	26741760.0
2014-07-07	META	Stock	66.3	66.57	65.12	65.29	28745000.0
2014-07-07	TSLA	Stock	15.1667	15.3187	14.6933	14.844	88405500.0
2014-07-07	TLT	Stock	111.27	111.81	111.23	111.49	5928870.0
2014-07-07	ES	Stock	45.68	46.16	45.54	45.73	1680800.0
2014-07-07	CL	Stock	68.79	68.95	68.61	68.86	1951800.0
2014-07-07	A	Stock	41.6309	41.6667	41.3805	41.5737	1326982.0
2014-07-07	AABA-DELISTED	Stock	36.15	36.23	35.48	35.52	15029132.0
2014-07-07	AACG	Stock	4.75	4.75	4.45	4.47	6000.0
2014-07-07	AAIC-DELISTED	Stock	26.68	26.711	26.42	26.42	248394.0
2014-07-07	AAL	Stock	41.72	41.72	39.92	40.1	14223500.0
2014-07-07	AAMC-DELISTED	Stock	204.6971	204.6971	183.8971	188.2912	94683.0
2014-07-07	AAME	Stock	3.95	3.95	3.93	3.95	1900.0
2014-07-07	AAOI	Stock	23.1	23.2	22.12	22.24	98900.0
2014-07-07	AAON	Stock	15.2356	15.3467	14.7467	14.7822	204975.0
2014-07-07	AAP	Stock	133.97	135.07	133.8	134.0	431100.0
2014-07-07	AAT	Stock	34.64	34.75	34.42	34.58	121700.0
2014-07-07	AAU-DELISTED	Stock	1.4	1.47	1.37	1.45	213097.0
2014-07-07	AAUAF-DELISTED	Stock	1.42	1.49	1.39	1.45	211490.0
2014-07-07	AAV-DELISTED	Stock	6.6	6.62	6.34	6.49	706705.0
2014-07-07	AAWW-DELISTED	Stock	37.48	37.48	36.3901	36.63	184735.0
2014-07-07	AAXJ	Stock	63.9	64.12	63.89	64.08	194724.0
2014-07-07	AAXN-DELISTED	Stock	13.1	13.17	12.86	12.9	637208.0
2014-07-07	AB	Stock	26.53	26.53	26.16	26.36	223300.0
2014-07-07	ABAC-DELISTED	Stock	2.14	2.14	2.06	2.06	8215.0
2014-07-07	ABAX-DELISTED	Stock	45.0	45.27	43.49	43.66	135829.0
2014-07-07	ABB-DELISTED	Stock	22.83	23.0	22.83	22.915	1957260.0
2014-07-07	ABBNY-DELISTED	Stock	22.83	23.0	22.83	22.93	2309387.0
2014-07-07	ABBV	Stock	57.91	58.15	57.39	57.4	4736300.0
2014-07-07	ABC-DELISTED	Stock	73.2	73.23	72.6601	73.005	756487.0
2014-07-07	ABCB	Stock	22.26	22.26	21.94	22.06	43200.0
2014-07-07	ABCD-DELISTED	Stock	2.11	2.112	2.05	2.0507	10300.0
2014-07-07	ABCO-DELISTED	Stock	52.15	52.15	51.23	51.65	193984.0
2014-07-07	ABDC-DELISTED	Stock	14.98	15.0	14.52	15.0	25052.0
2014-07-07	ABE-DELISTED	Stock	14.55	14.55	14.51	14.5113	5354.0
2014-07-07	ABEO	Stock	350.0	362.5	350.0	362.5	35.0
2014-07-07	ABEV	Stock	7.24	7.25	7.15	7.18	5748700.0
2014-07-07	ABG	Stock	70.78	71.36	70.62	70.89	201200.0
2014-07-07	ABGB-DELISTED	Stock	26.19	26.37	26.0	26.14	8363.0
2014-07-07	ABIL-DELISTED	Stock	9.76	9.76	9.76	9.76	377.0
2014-07-07	ABM	Stock	27.1	27.12	26.46	26.47	269900.0
2014-07-07	ABMD-DELISTED	Stock	25.53	25.832	24.95	25.33	412076.0
2014-07-07	ABR	Stock	6.95	6.98	6.87	6.94	233400.0
2014-07-07	ABR.A-DELISTED	Stock	24.588	24.6099	24.52	24.6099	3565.0
2014-07-07	ABR.B-DELISTED	Stock	24.392	24.55	24.392	24.5151	3212.0
2014-07-07	ABR.C-DELISTED	Stock	25.1	25.2063	25.09	25.2	9709.0

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

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