PREVIEW / stock_daily / 2015-12-23

all stock daily files

  file:    by_date/stock_daily/2015/2015-12-23.parquet
  size:    222 KB
  rows:    6,666
  symbols: 3,419

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
2015-12-23	AAPL	Stock	26.8175	27.2125	26.8	27.1525	130629600.0
2015-12-23	MSFT	Stock	55.7	55.88	55.44	55.82	27279800.0
2015-12-23	NVDA	Stock	0.8245	0.8298	0.823	0.8265	122524000.0
2015-12-23	AMZN	Stock	33.325	33.33	32.8315	33.185	54458000.0
2015-12-23	GOOGL	Stock	38.5345	38.595	37.8825	38.4255	30594840.0
2015-12-23	META	Stock	105.89	106.11	103.86	104.63	19599700.0
2015-12-23	TSLA	Stock	15.4787	15.5633	15.2087	15.3133	23325000.0
2015-12-23	TLT	Stock	121.23	121.61	120.87	121.39	7287134.0
2015-12-23	ES	Stock	50.91	51.81	50.61	51.64	1169000.0
2015-12-23	CL	Stock	66.86	67.39	66.78	67.16	1675500.0
2015-12-23	A	Stock	41.62	41.86	41.39	41.77	1510700.0
2015-12-23	AA.B-DELISTED	Stock	33.11	34.09	32.6536	34.06	314349.0
2015-12-23	AAAP-DELISTED	Stock	29.75	30.3	29.15	29.99	13912.0
2015-12-23	AABA-DELISTED	Stock	34.26	34.575	33.99	34.46	11726800.0
2015-12-23	AAC-DELISTED	Stock	20.15	20.41	18.67	18.7999	308492.0
2015-12-23	AACG	Stock	6.03	6.2	6.02	6.16	83000.0
2015-12-23	AAIC-DELISTED	Stock	14.51	14.63	14.39	14.51	403439.0
2015-12-23	AAL	Stock	42.78	43.39	42.43	43.29	6093600.0
2015-12-23	AAMC-DELISTED	Stock	4.9794	5.7441	4.8324	5.6059	276712.0
2015-12-23	AAME	Stock	4.71	4.73	4.7	4.73	2600.0
2015-12-23	AAMI	Stock	14.99	15.32	14.97	15.32	126500.0
2015-12-23	AAOI	Stock	16.99	17.25	16.92	17.12	188300.0
2015-12-23	AAON	Stock	15.4867	15.6467	15.3933	15.4733	170250.0
2015-12-23	AAP	Stock	148.43	150.05	146.56	149.06	1426300.0
2015-12-23	AAT	Stock	38.59	38.62	38.25	38.59	266400.0
2015-12-23	AAU-DELISTED	Stock	0.65	0.6874	0.64	0.6739	105532.0
2015-12-23	AAUAF-DELISTED	Stock	0.65	0.6874	0.64	0.6739	105969.0
2015-12-23	AAV-DELISTED	Stock	4.8	4.99	4.8	4.99	79740.0
2015-12-23	AAVL-DELISTED	Stock	9.34	9.52	9.16	9.31	125606.0
2015-12-23	AAWW-DELISTED	Stock	41.99	43.45	41.6028	43.43	246822.0
2015-12-23	AAXJ	Stock	54.27	54.7	54.27	54.63	932408.0
2015-12-23	AAXN-DELISTED	Stock	17.58	18.34	17.43	18.03	1009441.0
2015-12-23	AB	Stock	24.5	25.16	24.36	24.9	188700.0
2015-12-23	ABAC-DELISTED	Stock	0.99	0.99	0.8841	0.97	18647.0
2015-12-23	ABAX-DELISTED	Stock	54.41	54.83	53.9	54.78	110479.0
2015-12-23	ABB-DELISTED	Stock	17.93	18.08	17.87	18.08	1750265.0
2015-12-23	ABBNY-DELISTED	Stock	17.93	18.08	17.87	18.07	1790303.0
2015-12-23	ABBV	Stock	57.88	58.61	57.61	58.58	6634400.0
2015-12-23	ABC-DELISTED	Stock	103.05	104.24	102.8001	103.93	1118049.0
2015-12-23	ABCB	Stock	34.0	34.2	33.73	33.98	170000.0
2015-12-23	ABCD-DELISTED	Stock	5.18	5.44	5.05	5.13	135345.0
2015-12-23	ABCO-DELISTED	Stock	49.29	50.14	48.86	49.89	195726.0
2015-12-23	ABCW-DELISTED	Stock	44.47	44.55	44.05	44.14	9232.0
2015-12-23	ABDC-DELISTED	Stock	11.96	12.48	11.96	12.16	26882.0
2015-12-23	ABE-DELISTED	Stock	10.94	10.953	10.7608	10.92	3358.0
2015-12-23	ABEO	Stock	87.0	91.5	87.0	91.0	5352.0
2015-12-23	ABEV	Stock	4.5	4.59	4.49	4.59	16131800.0
2015-12-23	ABG	Stock	69.44	69.58	68.04	69.17	260500.0
2015-12-23	ABGB-DELISTED	Stock	1.52	1.6099	1.5	1.54	12480.0
2015-12-23	ABIL-DELISTED	Stock	10.1	10.11	9.01	9.16	113128.0

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

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