PREVIEW / stock_daily / 2014-07-16

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-16.parquet
  size:    221 KB
  rows:    6,602
  symbols: 3,573

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-16	AAPL	Stock	24.2425	24.275	23.685	23.695	213585200.0
2014-07-16	MSFT	Stock	42.51	44.31	42.48	44.08	63318000.0
2014-07-16	NVDA	Stock	0.4862	0.49	0.481	0.4838	319728000.0
2014-07-16	AMZN	Stock	17.781	17.966	17.65	17.795	70072000.0
2014-07-16	GOOGL	Stock	29.8445	29.85	29.5125	29.531	28844220.0
2014-07-16	META	Stock	67.54	67.94	67.07	67.66	29541600.0
2014-07-16	TSLA	Stock	14.788	14.9867	14.4547	14.4773	60667500.0
2014-07-16	TLT	Stock	113.0	113.58	112.94	113.46	4615817.0
2014-07-16	ES	Stock	45.49	45.57	44.97	45.47	1755800.0
2014-07-16	CL	Stock	69.6	69.9	69.33	69.45	2499400.0
2014-07-16	A	Stock	40.6867	40.8441	40.6509	40.7439	2612163.0
2014-07-16	AABA-DELISTED	Stock	34.38	34.45	33.72	33.79	54299617.0
2014-07-16	AACG	Stock	4.4	4.4	4.31	4.35	1300.0
2014-07-16	AAIC-DELISTED	Stock	27.08	27.08	26.77	26.81	124527.0
2014-07-16	AAL	Stock	44.0	44.0	43.3	43.48	6371100.0
2014-07-16	AAMC-DELISTED	Stock	218.8206	219.2794	210.3029	213.8294	55634.0
2014-07-16	AAME	Stock	3.92	3.92	3.78	3.82	17500.0
2014-07-16	AAOI	Stock	23.3	23.3	22.48	22.51	159300.0
2014-07-16	AAON	Stock	14.3289	14.5244	14.0267	14.1778	207675.0
2014-07-16	AAP	Stock	133.52	133.52	131.17	131.82	471600.0
2014-07-16	AAT	Stock	35.39	35.63	34.95	35.49	257500.0
2014-07-16	AAU-DELISTED	Stock	1.4	1.48	1.4	1.42	64385.0
2014-07-16	AAUAF-DELISTED	Stock	1.4	1.48	1.4	1.42	65967.0
2014-07-16	AAV-DELISTED	Stock	5.74	5.77	5.57	5.66	359589.0
2014-07-16	AAWW-DELISTED	Stock	36.04	37.05	35.8	36.73	222356.0
2014-07-16	AAXJ	Stock	64.12	64.12	63.87	63.87	283093.0
2014-07-16	AAXN-DELISTED	Stock	10.96	10.97	10.7	10.775	989643.0
2014-07-16	AB	Stock	27.52	27.67	27.26	27.62	203100.0
2014-07-16	ABAC-DELISTED	Stock	2.12	2.2	2.12	2.1501	41401.0
2014-07-16	ABAX-DELISTED	Stock	42.57	42.6	41.63	42.15	135058.0
2014-07-16	ABB-DELISTED	Stock	22.94	23.02	22.86	22.95	1044377.0
2014-07-16	ABBNY-DELISTED	Stock	22.94	23.02	22.86	22.94	1082179.0
2014-07-16	ABBV	Stock	53.25	53.67	51.82	53.65	23291200.0
2014-07-16	ABC-DELISTED	Stock	72.99	72.99	72.4	72.97	1314520.0
2014-07-16	ABCB	Stock	21.41	21.58	21.05	21.1	43300.0
2014-07-16	ABCD-DELISTED	Stock	1.86	1.97	1.86	1.97	21429.0
2014-07-16	ABCO-DELISTED	Stock	51.18	51.21	50.05	50.39	154932.0
2014-07-16	ABDC-DELISTED	Stock	13.93	14.14	13.88	13.99	84062.0
2014-07-16	ABE-DELISTED	Stock	14.5	14.71	14.5	14.6308	22186.0
2014-07-16	ABEO	Stock	337.5	337.5	312.5	325.0	37.0
2014-07-16	ABEV	Stock	7.07	7.19	7.05	7.18	24415400.0
2014-07-16	ABG	Stock	71.4	71.77	70.9	71.36	167900.0
2014-07-16	ABGB-DELISTED	Stock	26.34	26.74	26.34	26.68	22556.0
2014-07-16	ABM	Stock	26.01	26.25	25.69	25.96	230000.0
2014-07-16	ABMD-DELISTED	Stock	25.02	25.09	24.55	24.56	112145.0
2014-07-16	ABR	Stock	6.87	6.95	6.85	6.87	71900.0
2014-07-16	ABR.A-DELISTED	Stock	24.8799	24.8799	24.82	24.83	3230.0
2014-07-16	ABR.B-DELISTED	Stock	24.649	24.65	24.5412	24.62	1493.0
2014-07-16	ABR.C-DELISTED	Stock	25.269	25.27	25.23	25.27	4490.0
2014-07-16	ABRN-DELISTED	Stock	25.09	25.09	25.02	25.07	6201.0

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

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