PREVIEW / stock_daily / 2014-08-15

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-15.parquet
  size:    221 KB
  rows:    6,599
  symbols: 3,562

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-15	AAPL	Stock	24.475	24.5475	24.215	24.495	195804000.0
2014-08-15	MSFT	Stock	44.58	44.9	44.4	44.79	41611300.0
2014-08-15	NVDA	Stock	0.4715	0.4788	0.467	0.476	369796000.0
2014-08-15	AMZN	Stock	16.7	16.75	16.416	16.6815	77934000.0
2014-08-15	GOOGL	Stock	29.375	29.4735	29.038	29.1855	34507160.0
2014-08-15	META	Stock	74.32	74.65	73.0	73.63	38846600.0
2014-08-15	TSLA	Stock	17.432	17.4727	17.2333	17.4673	58018500.0
2014-08-15	TLT	Stock	116.71	118.36	116.69	117.71	17606660.0
2014-08-15	ES	Stock	44.03	44.41	43.88	44.17	1276700.0
2014-08-15	CL	Stock	64.4	64.67	63.69	64.13	3972300.0
2014-08-15	A	Stock	42.1674	42.2461	41.0229	41.1874	7799162.0
2014-08-15	AABA-DELISTED	Stock	36.19	36.57	36.12	36.47	12694594.0
2014-08-15	AACG	Stock	4.68	4.71	4.45	4.7	13800.0
2014-08-15	AAIC-DELISTED	Stock	27.43	27.43	27.12	27.34	119967.0
2014-08-15	AAL	Stock	39.98	40.08	38.79	39.19	9806500.0
2014-08-15	AAMC-DELISTED	Stock	163.0618	168.0235	160.6059	168.0235	20403.0
2014-08-15	AAME	Stock	4.11	4.2	3.95	4.16	17700.0
2014-08-15	AAOI	Stock	18.19	18.76	18.04	18.42	283300.0
2014-08-15	AAON	Stock	12.5	12.5	12.08	12.36	223050.0
2014-08-15	AAP	Stock	132.35	133.42	130.88	131.47	1352900.0
2014-08-15	AAT	Stock	35.45	35.5	34.5	34.79	266600.0
2014-08-15	AAU-DELISTED	Stock	1.51	1.51	1.4601	1.4899	53088.0
2014-08-15	AAUAF-DELISTED	Stock	1.51	1.51	1.4601	1.49	71090.0
2014-08-15	AAV-DELISTED	Stock	5.43	5.74	5.43	5.65	879670.0
2014-08-15	AAVL-DELISTED	Stock	26.81	29.8	26.81	27.95	74482.0
2014-08-15	AAWW-DELISTED	Stock	33.55	33.55	32.31	32.93	159961.0
2014-08-15	AAXJ	Stock	65.72	65.83	65.16	65.44	595591.0
2014-08-15	AAXN-DELISTED	Stock	13.17	14.14	13.14	13.92	3230265.0
2014-08-15	AB	Stock	25.74	25.79	25.38	25.5	118800.0
2014-08-15	ABAC-DELISTED	Stock	2.0	2.0	1.911	1.9301	6984.0
2014-08-15	ABAX-DELISTED	Stock	46.23	46.745	45.26	45.43	233955.0
2014-08-15	ABB-DELISTED	Stock	22.79	22.83	22.4	22.62	1172340.0
2014-08-15	ABBNY-DELISTED	Stock	22.79	22.83	22.4	22.62	1246019.0
2014-08-15	ABBV	Stock	54.34	54.59	53.58	53.9	10109300.0
2014-08-15	ABC-DELISTED	Stock	76.79	77.0	76.1	76.33	1421732.0
2014-08-15	ABCB	Stock	22.49	22.49	22.14	22.34	117700.0
2014-08-15	ABCD-DELISTED	Stock	1.761	1.89	1.761	1.86	13363.0
2014-08-15	ABCO-DELISTED	Stock	50.76	50.76	49.05	49.25	314948.0
2014-08-15	ABDC-DELISTED	Stock	13.45	13.59	13.1	13.1	87873.0
2014-08-15	ABE-DELISTED	Stock	14.59	14.6464	14.4601	14.549	3532.0
2014-08-15	ABEO	Stock	412.5	412.5	387.5	412.5	62.0
2014-08-15	ABEV	Stock	6.94	6.99	6.81	6.98	9637300.0
2014-08-15	ABG	Stock	70.99	70.99	68.8	69.2	203200.0
2014-08-15	ABGB-DELISTED	Stock	25.82	25.91	25.117	25.66	8230.0
2014-08-15	ABM	Stock	25.88	25.88	25.32	25.56	175900.0
2014-08-15	ABMD-DELISTED	Stock	25.4	25.4	24.67	24.87	249859.0
2014-08-15	ABR	Stock	6.97	6.97	6.91	6.91	78300.0
2014-08-15	ABR.A-DELISTED	Stock	24.5	24.68	24.42	24.68	5900.0
2014-08-15	ABR.B-DELISTED	Stock	24.18	24.2	24.03	24.084	6149.0
2014-08-15	ABR.C-DELISTED	Stock	25.02	25.0372	25.0	25.019	1690.0

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

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