PREVIEW / stock_daily / 2014-08-14

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-14.parquet
  size:    220 KB
  rows:    6,620
  symbols: 3,583

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-08-14	AAPL	Stock	24.3325	24.3925	24.2	24.375	112464000.0
2014-08-14	MSFT	Stock	44.08	44.42	44.01	44.27	19313200.0
2014-08-14	NVDA	Stock	0.477	0.477	0.468	0.47	255992000.0
2014-08-14	AMZN	Stock	16.39	16.7045	16.3355	16.6605	68408000.0
2014-08-14	GOOGL	Stock	29.3345	29.39	29.046	29.2325	25457580.0
2014-08-14	META	Stock	73.97	74.38	73.69	74.3	22207000.0
2014-08-14	TSLA	Stock	17.4993	17.5333	17.1	17.4253	61899000.0
2014-08-14	TLT	Stock	115.93	116.5	115.39	116.44	9028616.0
2014-08-14	ES	Stock	43.5	44.05	43.5	44.03	1171600.0
2014-08-14	CL	Stock	64.4	64.55	64.04	64.21	4143700.0
2014-08-14	A	Stock	39.1845	39.7926	38.9485	39.7854	4862943.0
2014-08-14	AABA-DELISTED	Stock	36.32	36.42	36.18	36.37	8242884.0
2014-08-14	AACG	Stock	4.72	4.75	4.45	4.7	12700.0
2014-08-14	AAIC-DELISTED	Stock	27.23	27.32	27.08	27.32	124628.0
2014-08-14	AAL	Stock	38.5	39.61	38.46	39.57	10132500.0
2014-08-14	AAMC-DELISTED	Stock	161.7647	161.7647	155.8824	159.5529	28659.0
2014-08-14	AAME	Stock	4.2	4.24	4.07	4.24	9900.0
2014-08-14	AAOI	Stock	18.1	18.406	17.52	18.03	234900.0
2014-08-14	AAON	Stock	12.4	12.4733	12.2733	12.3333	142200.0
2014-08-14	AAP	Stock	129.0	132.37	126.25	131.59	2388100.0
2014-08-14	AAT	Stock	35.34	35.46	35.15	35.29	46200.0
2014-08-14	AAU-DELISTED	Stock	1.55	1.55	1.4997	1.53	110249.0
2014-08-14	AAUAF-DELISTED	Stock	1.53	1.53	1.48	1.53	122132.0
2014-08-14	AAV-DELISTED	Stock	5.4	5.46	5.3	5.37	143496.0
2014-08-14	AAVL-DELISTED	Stock	24.99	27.15	23.91	26.07	58146.0
2014-08-14	AAWW-DELISTED	Stock	32.99	33.36	32.93	33.23	78436.0
2014-08-14	AAXJ	Stock	65.65	65.65	65.48	65.62	300735.0
2014-08-14	AAXN-DELISTED	Stock	12.39	12.745	12.2	12.71	709202.0
2014-08-14	AB	Stock	25.64	25.73	25.18	25.56	134600.0
2014-08-14	ABAC-DELISTED	Stock	2.0	2.0	1.94	2.0	10800.0
2014-08-14	ABAX-DELISTED	Stock	46.82	46.86	45.76	45.76	110575.0
2014-08-14	ABB-DELISTED	Stock	22.68	22.69	22.61	22.65	623318.0
2014-08-14	ABBNY-DELISTED	Stock	22.68	22.69	22.61	22.65	674307.0
2014-08-14	ABBV	Stock	53.62	54.23	53.53	54.19	7959800.0
2014-08-14	ABC-DELISTED	Stock	76.06	76.64	76.044	76.61	942022.0
2014-08-14	ABCB	Stock	22.2	22.37	22.18	22.25	106600.0
2014-08-14	ABCD-DELISTED	Stock	1.82	1.86	1.73	1.8	8500.0
2014-08-14	ABCO-DELISTED	Stock	50.16	50.83	49.63	50.36	276409.0
2014-08-14	ABDC-DELISTED	Stock	12.7	13.6	12.7	13.2	156293.0
2014-08-14	ABE-DELISTED	Stock	14.5309	14.55	14.48	14.5115	3997.0
2014-08-14	ABEO	Stock	412.5	412.5	400.0	412.5	87.0
2014-08-14	ABEV	Stock	6.83	6.89	6.81	6.89	5171400.0
2014-08-14	ABG	Stock	70.42	70.84	70.15	70.41	110800.0
2014-08-14	ABGB-DELISTED	Stock	25.46	25.99	25.46	25.99	10677.0
2014-08-14	ABM	Stock	25.67	25.76	25.53	25.62	94000.0
2014-08-14	ABMD-DELISTED	Stock	25.63	25.71	25.06	25.12	208987.0
2014-08-14	ABR	Stock	6.91	6.95	6.9	6.9	93500.0
2014-08-14	ABR.A-DELISTED	Stock	24.65	24.69	24.58	24.69	1240.0
2014-08-14	ABR.B-DELISTED	Stock	24.33	24.7	24.21	24.21	23594.0
2014-08-14	ABR.C-DELISTED	Stock	24.9115	25.04	24.9115	25.04	3486.0

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

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