PREVIEW / stock_daily / 2014-10-07

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-07.parquet
  size:    221 KB
  rows:    6,642
  symbols: 3,570

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-10-07	AAPL	Stock	24.8575	25.03	24.6825	24.6875	168376800.0
2014-10-07	MSFT	Stock	45.86	45.93	45.42	45.53	25723700.0
2014-10-07	NVDA	Stock	0.451	0.4555	0.4478	0.4482	301896000.0
2014-10-07	AMZN	Stock	15.9715	16.1	15.8335	15.849	47308000.0
2014-10-07	GOOGL	Stock	29.245	29.2925	28.705	28.705	30924560.0
2014-10-07	META	Stock	77.05	77.95	76.24	76.29	25317000.0
2014-10-07	TSLA	Stock	17.2353	17.4307	17.0487	17.3047	67282500.0
2014-10-07	TLT	Stock	118.31	119.43	118.18	119.36	8841306.0
2014-10-07	ES	Stock	45.44	46.16	45.35	45.81	3786400.0
2014-10-07	CL	Stock	64.76	65.28	64.64	64.9	4280100.0
2014-10-07	A	Stock	40.2361	40.2933	39.3419	39.3419	2117271.0
2014-10-07	AA.B-DELISTED	Stock	49.85	50.3	49.51	49.86	168636.0
2014-10-07	AABA-DELISTED	Stock	41.04	41.29	40.78	40.93	21612103.0
2014-10-07	AAC-DELISTED	Stock	19.36	19.48	18.9293	19.25	174473.0
2014-10-07	AACG	Stock	4.43	4.49	4.33	4.34	4500.0
2014-10-07	AAIC-DELISTED	Stock	25.42	25.44	25.26	25.35	343470.0
2014-10-07	AAL	Stock	34.75	35.02	34.06	34.09	10030100.0
2014-10-07	AAMC-DELISTED	Stock	199.1529	204.3912	198.5294	198.6029	12791.0
2014-10-07	AAME	Stock	3.95	4.0	3.82	4.0	2600.0
2014-10-07	AAOI	Stock	14.66	15.0	14.282	14.52	194600.0
2014-10-07	AAON	Stock	11.52	11.7667	11.3133	11.34	441150.0
2014-10-07	AAP	Stock	134.34	136.1	133.38	133.81	773000.0
2014-10-07	AAT	Stock	34.0	34.26	33.78	33.81	79600.0
2014-10-07	AAU-DELISTED	Stock	1.32	1.34	1.29	1.29	57430.0
2014-10-07	AAUAF-DELISTED	Stock	1.28	1.3	1.25	1.29	59943.0
2014-10-07	AAV-DELISTED	Stock	4.81	4.91	4.7	4.8	287964.0
2014-10-07	AAVL-DELISTED	Stock	33.6	33.6	31.02	31.61	48358.0
2014-10-07	AAWW-DELISTED	Stock	32.37	33.17	32.07	32.38	178888.0
2014-10-07	AAXJ	Stock	61.33	61.33	60.82	60.87	443725.0
2014-10-07	AAXN-DELISTED	Stock	14.78	14.809	14.42	14.43	1622120.0
2014-10-07	AB	Stock	25.6	25.69	25.01	25.11	257100.0
2014-10-07	ABAC-DELISTED	Stock	2.0701	2.1	2.07	2.0899	66264.0
2014-10-07	ABAX-DELISTED	Stock	49.57	50.048	47.41	47.53	381546.0
2014-10-07	ABB-DELISTED	Stock	21.61	21.69	21.5	21.5	3230066.0
2014-10-07	ABBNY-DELISTED	Stock	21.61	21.69	21.5	21.5	3305688.0
2014-10-07	ABBV	Stock	57.6	57.6	56.51	56.65	8923500.0
2014-10-07	ABC-DELISTED	Stock	77.2	77.24	76.48	76.5	940599.0
2014-10-07	ABCB	Stock	22.2	22.42	22.12	22.3	67200.0
2014-10-07	ABCD-DELISTED	Stock	1.6	1.72	1.59	1.6	6218.0
2014-10-07	ABCO-DELISTED	Stock	45.97	46.45	45.57	46.17	343924.0
2014-10-07	ABDC-DELISTED	Stock	12.85	12.92	12.63	12.91	37500.0
2014-10-07	ABE-DELISTED	Stock	14.15	14.1593	13.98	14.07	2323.0
2014-10-07	ABEO	Stock	325.0	337.5	325.0	325.0	17.0
2014-10-07	ABEV	Stock	6.92	6.96	6.81	6.85	21722800.0
2014-10-07	ABG	Stock	67.52	67.52	65.58	65.95	171700.0
2014-10-07	ABGB-DELISTED	Stock	22.05	22.75	21.75	22.05	63982.0
2014-10-07	ABIL-DELISTED	Stock	9.7	9.7	9.7	9.7	100.0
2014-10-07	ABM	Stock	25.63	25.9	25.47	25.48	226100.0
2014-10-07	ABMD-DELISTED	Stock	24.07	24.26	23.5	23.58	285755.0
2014-10-07	ABR	Stock	6.62	6.62	6.56	6.59	51800.0

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

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