PREVIEW / stock_daily / 2014-06-23

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-23.parquet
  size:    221 KB
  rows:    6,617
  symbols: 3,593

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-06-23	AAPL	Stock	22.83	22.905	22.65	22.7075	174776000.0
2014-06-23	MSFT	Stock	41.73	42.0	41.69	41.99	18743900.0
2014-06-23	NVDA	Stock	0.467	0.468	0.4615	0.4678	414200000.0
2014-06-23	AMZN	Stock	16.1665	16.3775	16.0705	16.362	52096000.0
2014-06-23	GOOGL	Stock	28.2175	28.722	28.175	28.7145	34481960.0
2014-06-23	META	Stock	64.32	65.66	64.22	65.37	34560000.0
2014-06-23	TSLA	Stock	15.3007	15.9327	15.2147	15.8147	116866500.0
2014-06-23	TLT	Stock	112.08	112.18	111.41	111.45	5822220.0
2014-06-23	ES	Stock	46.36	46.6	46.18	46.27	1232100.0
2014-06-23	CL	Stock	68.35	68.36	67.71	67.83	2656100.0
2014-06-23	A	Stock	41.9957	42.103	41.4664	41.5665	2006969.0
2014-06-23	AABA-DELISTED	Stock	34.13	34.22	33.37	33.64	23468798.0
2014-06-23	AACG	Stock	4.65	4.75	4.62	4.7	9000.0
2014-06-23	AAIC-DELISTED	Stock	28.0	28.09	27.93	27.96	178368.0
2014-06-23	AAL	Stock	44.3	44.88	43.8	44.36	18454500.0
2014-06-23	AAMC-DELISTED	Stock	298.8529	305.0	241.1471	241.1471	259175.0
2014-06-23	AAME	Stock	3.95	4.0	3.74	3.93	22200.0
2014-06-23	AAOI	Stock	23.57	23.57	22.85	23.06	237700.0
2014-06-23	AAON	Stock	14.7289	14.7911	14.5333	14.6489	146025.0
2014-06-23	AAP	Stock	129.7	130.82	129.21	130.67	1376200.0
2014-06-23	AAT	Stock	34.32	34.73	34.32	34.52	134700.0
2014-06-23	AAU-DELISTED	Stock	1.5	1.5304	1.459	1.5	254114.0
2014-06-23	AAUAF-DELISTED	Stock	1.48	1.51	1.44	1.5	258746.0
2014-06-23	AAV-DELISTED	Stock	6.92	6.925	6.76	6.86	293846.0
2014-06-23	AAWW-DELISTED	Stock	35.83	36.35	35.53	36.25	287188.0
2014-06-23	AAXJ	Stock	62.36	62.39	62.21	62.32	144338.0
2014-06-23	AAXN-DELISTED	Stock	13.82	13.82	13.5715	13.7	579862.0
2014-06-23	AB	Stock	25.41	25.71	25.09	25.52	261200.0
2014-06-23	ABAC-DELISTED	Stock	2.2	2.23	2.16	2.2243	39781.0
2014-06-23	ABAX-DELISTED	Stock	44.29	44.79	43.784	44.41	109744.0
2014-06-23	ABB-DELISTED	Stock	23.02	23.08	22.95	23.08	926004.0
2014-06-23	ABBNY-DELISTED	Stock	23.02	23.08	22.95	23.08	1000190.0
2014-06-23	ABBV	Stock	53.76	54.4	53.54	53.75	6235600.0
2014-06-23	ABC-DELISTED	Stock	72.47	72.77	72.27	72.46	875176.0
2014-06-23	ABCB	Stock	21.61	21.61	21.27	21.28	82000.0
2014-06-23	ABCD-DELISTED	Stock	2.08	2.08	1.91	2.0	37567.0
2014-06-23	ABCO-DELISTED	Stock	51.3	51.49	50.73	51.41	109445.0
2014-06-23	ABDC-DELISTED	Stock	14.05	14.4	14.0	14.31	27082.0
2014-06-23	ABE-DELISTED	Stock	14.35	14.35	14.22	14.31	4583.0
2014-06-23	ABEO	Stock	387.5	400.0	387.5	400.0	6.0
2014-06-23	ABEV	Stock	7.15	7.15	7.01	7.04	5732000.0
2014-06-23	ABG	Stock	65.75	66.38	65.6	66.1	194400.0
2014-06-23	ABGB-DELISTED	Stock	28.3	28.61	28.17	28.48	10915.0
2014-06-23	ABIL-DELISTED	Stock	9.75	9.76	9.75	9.75	848.0
2014-06-23	ABM	Stock	26.64	26.7	26.37	26.52	193900.0
2014-06-23	ABMD-DELISTED	Stock	23.47	23.67	22.89	23.26	127539.0
2014-06-23	ABR	Stock	7.07	7.11	7.04	7.08	113300.0
2014-06-23	ABR.A-DELISTED	Stock	24.36	24.3999	24.335	24.399	2300.0
2014-06-23	ABR.B-DELISTED	Stock	24.0	24.06	23.999	24.06	2434.0
2014-06-23	ABR.C-DELISTED	Stock	25.05	25.0576	25.05	25.051	4600.0

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

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