PREVIEW / stock_daily / 2014-10-14

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-14.parquet
  size:    221 KB
  rows:    6,620
  symbols: 3,564

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-14	AAPL	Stock	25.0975	25.13	24.6425	24.6875	254754400.0
2014-10-14	MSFT	Stock	43.87	44.38	43.56	43.73	38115700.0
2014-10-14	NVDA	Stock	0.4255	0.4412	0.423	0.4295	376620000.0
2014-10-14	AMZN	Stock	15.4	15.612	15.2875	15.4155	67716000.0
2014-10-14	GOOGL	Stock	27.507	27.9315	27.225	27.4345	52200660.0
2014-10-14	META	Stock	74.0	74.18	72.05	73.59	50299000.0
2014-10-14	TSLA	Stock	15.2167	15.498	14.8667	15.1373	106579500.0
2014-10-14	TLT	Stock	121.31	121.78	120.68	121.57	11285617.0
2014-10-14	ES	Stock	46.83	48.15	46.61	47.56	2557300.0
2014-10-14	CL	Stock	64.36	66.12	64.0	64.41	4631700.0
2014-10-14	A	Stock	37.9399	38.1903	37.0315	37.0458	5554114.0
2014-10-14	AA.B-DELISTED	Stock	46.8	47.1	45.72	45.93	67028.0
2014-10-14	AABA-DELISTED	Stock	38.66	39.0	37.71	37.98	36710018.0
2014-10-14	AAC-DELISTED	Stock	19.03	19.03	17.91	18.11	124001.0
2014-10-14	AACG	Stock	4.36	4.36	4.3	4.31	4200.0
2014-10-14	AAIC-DELISTED	Stock	25.47	25.732	25.465	25.66	327722.0
2014-10-14	AAL	Stock	29.29	32.18	29.28	31.51	28136800.0
2014-10-14	AAMC-DELISTED	Stock	185.2912	188.8029	183.8235	185.7382	17228.0
2014-10-14	AAME	Stock	3.85	3.88	3.72	3.88	2900.0
2014-10-14	AAMI	Stock	14.03	14.25	13.85	14.0	302000.0
2014-10-14	AAOI	Stock	12.37	13.46	12.14	13.4	715100.0
2014-10-14	AAON	Stock	11.62	12.1	11.46	11.6933	278400.0
2014-10-14	AAP	Stock	131.35	134.05	130.8	133.98	684400.0
2014-10-14	AAT	Stock	34.58	35.37	34.58	34.93	154300.0
2014-10-14	AAU-DELISTED	Stock	1.26	1.31	1.26	1.29	87605.0
2014-10-14	AAUAF-DELISTED	Stock	1.26	1.3	1.26	1.29	98690.0
2014-10-14	AAV-DELISTED	Stock	4.4	4.54	4.28	4.34	663897.0
2014-10-14	AAVL-DELISTED	Stock	30.55	31.24	29.76	30.06	110813.0
2014-10-14	AAWW-DELISTED	Stock	31.81	32.43	31.524	32.21	319590.0
2014-10-14	AAXJ	Stock	60.38	60.77	60.2	60.44	1014543.0
2014-10-14	AAXN-DELISTED	Stock	13.8	14.51	13.77	14.2	1458946.0
2014-10-14	AB	Stock	23.18	23.94	23.03	23.56	265700.0
2014-10-14	ABAC-DELISTED	Stock	2.08	2.08	2.0	2.07	20247.0
2014-10-14	ABAX-DELISTED	Stock	47.78	48.68	47.476	47.85	166094.0
2014-10-14	ABB-DELISTED	Stock	20.61	20.8	20.48	20.545	1864141.0
2014-10-14	ABBNY-DELISTED	Stock	20.61	20.8	20.48	20.54	2039739.0
2014-10-14	ABBV	Stock	53.59	54.84	53.02	54.13	14293600.0
2014-10-14	ABC-DELISTED	Stock	76.25	77.34	75.66	76.63	1326826.0
2014-10-14	ABCB	Stock	23.0	23.75	22.98	23.72	150900.0
2014-10-14	ABCD-DELISTED	Stock	1.551	1.59	1.48	1.48	8316.0
2014-10-14	ABCO-DELISTED	Stock	48.26	49.71	48.26	48.92	252486.0
2014-10-14	ABDC-DELISTED	Stock	12.67	12.79	12.06	12.32	87475.0
2014-10-14	ABE-DELISTED	Stock	13.7	13.7717	13.3272	13.625	15128.0
2014-10-14	ABEO	Stock	287.5	287.5	275.0	275.0	18.0
2014-10-14	ABEV	Stock	6.68	6.79	6.63	6.73	12957000.0
2014-10-14	ABG	Stock	62.36	64.74	60.63	63.87	879300.0
2014-10-14	ABGB-DELISTED	Stock	18.73	19.5	18.68	19.12	87000.0
2014-10-14	ABM	Stock	25.38	25.57	25.18	25.48	265200.0
2014-10-14	ABMD-DELISTED	Stock	22.68	23.18	22.3401	22.89	327838.0
2014-10-14	ABR	Stock	6.54	6.6	6.51	6.54	44700.0

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

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