PREVIEW / stock_daily / 2014-08-13

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-13.parquet
  size:    221 KB
  rows:    6,613
  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-08-13	AAPL	Stock	24.0375	24.31	24.01	24.31	127664000.0
2014-08-13	MSFT	Stock	43.68	44.18	43.52	44.08	22889500.0
2014-08-13	NVDA	Stock	0.4732	0.4793	0.4702	0.4753	256596000.0
2014-08-13	AMZN	Stock	16.38	16.586	16.307	16.314	98782000.0
2014-08-13	GOOGL	Stock	28.8225	29.3062	28.76	29.228	38065640.0
2014-08-13	META	Stock	73.12	74.25	73.05	73.77	29266000.0
2014-08-13	TSLA	Stock	17.4673	17.7093	17.3073	17.354	103989000.0
2014-08-13	TLT	Stock	114.87	115.52	114.78	115.51	8210642.0
2014-08-13	ES	Stock	43.14	43.57	43.13	43.45	926300.0
2014-08-13	CL	Stock	64.6	64.7	64.05	64.38	3686800.0
2014-08-13	A	Stock	38.97	39.3205	38.7625	39.1845	2406377.0
2014-08-13	AABA-DELISTED	Stock	35.96	36.45	35.772	36.19	15331614.0
2014-08-13	AACG	Stock	4.44	4.75	4.44	4.74	25300.0
2014-08-13	AAIC-DELISTED	Stock	27.0	27.15	27.0	27.14	92989.0
2014-08-13	AAL	Stock	37.64	38.46	37.44	38.12	6177000.0
2014-08-13	AAMC-DELISTED	Stock	161.7735	164.45	157.3824	158.8235	44268.0
2014-08-13	AAME	Stock	4.19	4.25	4.1	4.21	19200.0
2014-08-13	AAOI	Stock	18.49	19.0	17.62	18.01	886400.0
2014-08-13	AAON	Stock	12.4133	12.68	12.3067	12.4	211950.0
2014-08-13	AAP	Stock	125.2	125.45	122.68	122.93	1098200.0
2014-08-13	AAT	Stock	34.87	35.34	34.8	35.25	266800.0
2014-08-13	AAU-DELISTED	Stock	1.49	1.5	1.43	1.5	43040.0
2014-08-13	AAUAF-DELISTED	Stock	1.49	1.51	1.43	1.51	43687.0
2014-08-13	AAV-DELISTED	Stock	5.33	5.4	5.3	5.39	128627.0
2014-08-13	AAVL-DELISTED	Stock	24.0	25.44	24.0	24.23	98967.0
2014-08-13	AAWW-DELISTED	Stock	33.57	33.88	32.98	33.05	125498.0
2014-08-13	AAXJ	Stock	65.39	65.66	65.39	65.57	1210413.0
2014-08-13	AAXN-DELISTED	Stock	12.05	12.45	12.02	12.36	691953.0
2014-08-13	AB	Stock	25.28	25.85	25.18	25.61	270700.0
2014-08-13	ABAC-DELISTED	Stock	1.8101	2.0	1.81	2.0	25577.0
2014-08-13	ABAX-DELISTED	Stock	46.62	47.28	46.38	46.68	122872.0
2014-08-13	ABB-DELISTED	Stock	22.57	22.61	22.5	22.525	1088147.0
2014-08-13	ABBNY-DELISTED	Stock	22.58	22.61	22.5	22.52	1122457.0
2014-08-13	ABBV	Stock	52.97	53.64	52.75	53.6	9029400.0
2014-08-13	ABC-DELISTED	Stock	76.17	76.49	75.94	76.14	1014723.0
2014-08-13	ABCB	Stock	22.15	22.38	22.12	22.21	100000.0
2014-08-13	ABCD-DELISTED	Stock	1.8	1.87	1.8	1.86	3204.0
2014-08-13	ABCO-DELISTED	Stock	50.55	50.99	50.22	50.3	232577.0
2014-08-13	ABDC-DELISTED	Stock	12.5	12.93	12.32	12.74	132751.0
2014-08-13	ABE-DELISTED	Stock	14.53	14.55	14.41	14.4696	6846.0
2014-08-13	ABEO	Stock	375.0	400.0	325.0	400.0	28.0
2014-08-13	ABEV	Stock	6.97	6.99	6.71	6.82	16609000.0
2014-08-13	ABG	Stock	69.06	70.24	68.57	70.04	134200.0
2014-08-13	ABGB-DELISTED	Stock	25.99	25.99	25.7001	25.83	12105.0
2014-08-13	ABM	Stock	25.46	25.76	25.37	25.62	165500.0
2014-08-13	ABMD-DELISTED	Stock	26.12	26.12	25.48	25.62	219272.0
2014-08-13	ABR	Stock	6.89	6.97	6.85	6.92	159500.0
2014-08-13	ABR.A-DELISTED	Stock	24.61	24.69	24.4	24.5801	10885.0
2014-08-13	ABR.B-DELISTED	Stock	24.2	24.2	24.08	24.08	4148.0
2014-08-13	ABR.C-DELISTED	Stock	24.9	24.93	24.9	24.93	204.0

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

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