PREVIEW / stock_daily / 2014-11-14

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-14.parquet
  size:    223 KB
  rows:    6,661
  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-11-14	AAPL	Stock	28.2875	28.5475	27.8025	28.545	176254400.0
2014-11-14	MSFT	Stock	49.74	50.05	49.39	49.58	29081700.0
2014-11-14	NVDA	Stock	0.4892	0.4948	0.4845	0.4948	160248000.0
2014-11-14	AMZN	Stock	15.856	16.644	15.82	16.391	177556000.0
2014-11-14	GOOGL	Stock	27.9	27.9	27.6255	27.7595	28501200.0
2014-11-14	META	Stock	74.27	74.93	74.04	74.88	19476900.0
2014-11-14	TSLA	Stock	16.6667	17.2567	16.5667	17.2453	91516500.0
2014-11-14	TLT	Stock	118.84	119.59	118.68	119.49	5191200.0
2014-11-14	ES	Stock	49.07	49.21	48.65	48.8	1888100.0
2014-11-14	CL	Stock	68.2	68.34	67.51	67.56	3054800.0
2014-11-14	A	Stock	41.36	41.65	41.29	41.57	1331300.0
2014-11-14	AA.B-DELISTED	Stock	52.15	52.72	51.94	52.65	23785.0
2014-11-14	AABA-DELISTED	Stock	50.52	51.95	50.47	51.755	26805171.0
2014-11-14	AAC-DELISTED	Stock	26.96	26.96	25.57	26.5	104702.0
2014-11-14	AACG	Stock	3.87	3.99	3.87	3.99	4400.0
2014-11-14	AAIC-DELISTED	Stock	27.23	27.46	27.23	27.29	147985.0
2014-11-14	AAL	Stock	44.0	44.54	43.67	44.01	8746200.0
2014-11-14	AAMC-DELISTED	Stock	139.7059	141.4706	128.2444	141.4706	80876.0
2014-11-14	AAME	Stock	3.81	3.88	3.81	3.88	1500.0
2014-11-14	AAMI	Stock	15.56	15.8	15.27	15.57	234700.0
2014-11-14	AAOI	Stock	12.03	12.342	12.0	12.17	276600.0
2014-11-14	AAON	Stock	14.0733	14.08	13.9333	13.9733	268950.0
2014-11-14	AAP	Stock	146.8	147.61	144.35	144.81	563200.0
2014-11-14	AAT	Stock	39.12	39.25	38.51	38.69	96400.0
2014-11-14	AAU-DELISTED	Stock	1.06	1.14	1.0393	1.13	453717.0
2014-11-14	AAUAF-DELISTED	Stock	1.05	1.13	1.03	1.13	459144.0
2014-11-14	AAV-DELISTED	Stock	4.61	4.88	4.58	4.79	439927.0
2014-11-14	AAVL-DELISTED	Stock	34.52	34.98	32.76	33.84	111465.0
2014-11-14	AAWW-DELISTED	Stock	40.98	41.92	40.63	41.55	248612.0
2014-11-14	AAXJ	Stock	62.51	62.87	62.47	62.78	2311312.0
2014-11-14	AAXN-DELISTED	Stock	19.51	20.69	19.42	20.19	3730554.0
2014-11-14	AB	Stock	27.0	27.0	26.0	26.26	399300.0
2014-11-14	ABAC-DELISTED	Stock	2.28	2.29	2.18	2.2499	41138.0
2014-11-14	ABAX-DELISTED	Stock	55.04	55.85	54.55	54.8	204867.0
2014-11-14	ABB-DELISTED	Stock	22.12	22.37	22.11	22.32	1272416.0
2014-11-14	ABBNY-DELISTED	Stock	22.12	22.37	22.11	22.31	1463956.0
2014-11-14	ABBV	Stock	63.98	64.0	63.13	64.0	4684900.0
2014-11-14	ABC-DELISTED	Stock	88.87	89.24	88.34	88.83	1426706.0
2014-11-14	ABCB	Stock	25.98	26.16	25.65	25.7	120700.0
2014-11-14	ABCD-DELISTED	Stock	1.77	1.889	1.74	1.76	7118.0
2014-11-14	ABCO-DELISTED	Stock	46.12	46.81	45.73	46.38	230224.0
2014-11-14	ABCW-DELISTED	Stock	29.73	30.6201	29.73	30.6201	5380.0
2014-11-14	ABDC-DELISTED	Stock	12.73	12.91	12.73	12.85	35860.0
2014-11-14	ABE-DELISTED	Stock	13.71	13.8	13.5801	13.7	2034.0
2014-11-14	ABEO	Stock	178.0	178.0	170.0	175.0	372.0
2014-11-14	ABEV	Stock	6.12	6.16	6.06	6.11	12498300.0
2014-11-14	ABG	Stock	74.27	74.55	73.59	74.01	243300.0
2014-11-14	ABGB-DELISTED	Stock	7.87	9.95	7.71	9.0999	7109384.0
2014-11-14	ABM	Stock	27.44	27.73	27.15	27.22	170100.0
2014-11-14	ABMD-DELISTED	Stock	33.5	33.754	32.965	33.25	545797.0

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

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