PREVIEW / stock_daily / 2016-03-21

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-21.parquet
  size:    219 KB
  rows:    6,581
  symbols: 3,333

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
2016-03-21	AAPL	Stock	26.4825	26.9125	26.285	26.4775	142010800.0
2016-03-21	MSFT	Stock	53.25	53.93	52.93	53.86	23925700.0
2016-03-21	NVDA	Stock	0.8378	0.848	0.8288	0.8478	337780000.0
2016-03-21	AMZN	Stock	27.4455	27.762	26.929	27.699	103114000.0
2016-03-21	GOOGL	Stock	37.6955	38.167	37.5635	38.108	28773160.0
2016-03-21	META	Stock	111.66	112.37	111.03	111.85	18448000.0
2016-03-21	TSLA	Stock	15.6893	15.992	15.6667	15.888	79617000.0
2016-03-21	TLT	Stock	128.25	128.62	127.745	128.07	5514849.0
2016-03-21	ES	Stock	57.1	57.82	56.74	57.35	1657600.0
2016-03-21	CL	Stock	70.07	70.87	69.8	70.43	4128700.0
2016-03-21	A	Stock	40.07	40.14	39.64	39.65	2172600.0
2016-03-21	AA.B-DELISTED	Stock	33.11	33.11	32.56	32.93	16412.0
2016-03-21	AAAP-DELISTED	Stock	38.05	38.75	36.56	37.6899	26324.0
2016-03-21	AABA-DELISTED	Stock	35.0	36.1	35.0	35.48	12594051.0
2016-03-21	AAC-DELISTED	Stock	19.92	20.32	19.09	20.22	272688.0
2016-03-21	AACG	Stock	5.34	5.34	4.95	5.14	1132300.0
2016-03-21	AAIC-DELISTED	Stock	13.5	13.82	13.5	13.61	271877.0
2016-03-21	AAL	Stock	43.32	43.78	43.28	43.47	4756400.0
2016-03-21	AAMC-DELISTED	Stock	4.2206	4.2353	4.1038	4.1441	41725.0
2016-03-21	AAME	Stock	4.13	4.34	3.99	4.21	13400.0
2016-03-21	AAMI	Stock	12.69	12.97	12.63	12.94	112000.0
2016-03-21	AAOI	Stock	17.53	17.91	17.45	17.46	159900.0
2016-03-21	AAON	Stock	18.0	18.34	17.74	18.0733	331800.0
2016-03-21	AAP	Stock	157.48	158.75	157.38	158.61	389400.0
2016-03-21	AAT	Stock	38.09	38.1	37.51	37.71	170400.0
2016-03-21	AAU-DELISTED	Stock	0.7019	0.7444	0.7019	0.7389	159931.0
2016-03-21	AAUAF-DELISTED	Stock	0.7019	0.7444	0.7019	0.73	162932.0
2016-03-21	AAV-DELISTED	Stock	5.45	5.53	5.36	5.4	97942.0
2016-03-21	AAVL-DELISTED	Stock	5.17	5.47	5.03	5.38	241506.0
2016-03-21	AAWW-DELISTED	Stock	42.08	43.44	41.93	42.96	225189.0
2016-03-21	AAXJ	Stock	54.27	54.465	54.19	54.38	442153.0
2016-03-21	AAXN-DELISTED	Stock	19.0	19.47	18.78	18.96	715593.0
2016-03-21	AB	Stock	23.33	23.49	22.86	22.87	241600.0
2016-03-21	ABAC-DELISTED	Stock	0.555	0.6641	0.555	0.65	2020.0
2016-03-21	ABAX-DELISTED	Stock	41.96	42.03	41.66	41.7	89522.0
2016-03-21	ABB-DELISTED	Stock	19.21	19.36	19.19	19.25	2235043.0
2016-03-21	ABBNY-DELISTED	Stock	19.21	19.36	19.19	19.24	2730379.0
2016-03-21	ABBV	Stock	56.52	56.78	55.73	56.01	6632900.0
2016-03-21	ABC-DELISTED	Stock	87.58	87.84	86.8	87.12	1441727.0
2016-03-21	ABCB	Stock	29.43	29.8	28.9	29.11	159500.0
2016-03-21	ABCD-DELISTED	Stock	4.4	4.46	4.34	4.36	12927.0
2016-03-21	ABCO-DELISTED	Stock	30.31	31.06	30.123	30.73	362178.0
2016-03-21	ABCW-DELISTED	Stock	44.25	44.38	43.88	44.0	23512.0
2016-03-21	ABDC-DELISTED	Stock	10.85	11.11	10.826	10.98	31609.0
2016-03-21	ABE-DELISTED	Stock	11.4	11.57	11.4	11.5	6490.0
2016-03-21	ABEO	Stock	72.0	74.5	70.75	73.5	1812.0
2016-03-21	ABEOW-DELISTED	Stock	0.65	0.68	0.61	0.67	2032.0
2016-03-21	ABEV	Stock	5.05	5.16	5.03	5.14	19933200.0
2016-03-21	ABG	Stock	59.85	61.36	59.85	61.27	568000.0
2016-03-21	ABGB-DELISTED	Stock	1.39	1.39	1.24	1.31	53564.0

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

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