PREVIEW / stock_daily / 2016-03-11

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-11.parquet
  size:    219 KB
  rows:    6,582
  symbols: 3,332

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-11	AAPL	Stock	25.56	25.57	25.375	25.565	109632800.0
2016-03-11	MSFT	Stock	53.0	53.07	52.38	53.07	32275700.0
2016-03-11	NVDA	Stock	0.8038	0.8058	0.7942	0.8055	277400000.0
2016-03-11	AMZN	Stock	28.3475	28.503	28.1365	28.4805	75426000.0
2016-03-11	GOOGL	Stock	36.9975	37.245	36.835	37.2435	35379900.0
2016-03-11	META	Stock	108.48	109.42	107.92	109.41	20697600.0
2016-03-11	TSLA	Stock	13.862	13.9613	13.6887	13.8333	50146500.0
2016-03-11	TLT	Stock	128.82	128.875	127.21	127.36	8927006.0
2016-03-11	ES	Stock	56.72	57.0	56.36	56.55	1655400.0
2016-03-11	CL	Stock	68.28	68.49	67.95	68.37	3186900.0
2016-03-11	A	Stock	38.43	39.27	38.32	39.23	1517300.0
2016-03-11	AA.B-DELISTED	Stock	32.19	32.36	31.17	31.6599	50447.0
2016-03-11	AAAP-DELISTED	Stock	33.5	34.6	33.04	33.8	22644.0
2016-03-11	AABA-DELISTED	Stock	33.25	33.859	32.835	33.81	11326940.0
2016-03-11	AAC-DELISTED	Stock	17.03	18.64	16.95	18.03	337888.0
2016-03-11	AACG	Stock	4.93	4.96	4.61	4.93	16300.0
2016-03-11	AAIC-DELISTED	Stock	12.66	13.29	12.66	13.29	263954.0
2016-03-11	AAL	Stock	41.89	42.5	41.7	42.47	5701500.0
2016-03-11	AAMC-DELISTED	Stock	3.8773	3.8971	3.8029	3.8676	50113.0
2016-03-11	AAME	Stock	4.26	4.26	4.07	4.26	2300.0
2016-03-11	AAMI	Stock	11.81	12.43	11.655	12.3	241200.0
2016-03-11	AAOI	Stock	17.54	17.63	17.18	17.61	128600.0
2016-03-11	AAON	Stock	16.92	16.9867	16.72	16.8467	400650.0
2016-03-11	AAP	Stock	156.84	159.16	155.97	158.57	963400.0
2016-03-11	AAT	Stock	37.86	38.29	37.86	38.28	173300.0
2016-03-11	AAU-DELISTED	Stock	0.723	0.7599	0.723	0.7551	116411.0
2016-03-11	AAUAF-DELISTED	Stock	0.723	0.7599	0.723	0.7551	120031.0
2016-03-11	AAV-DELISTED	Stock	5.63	5.738	5.57	5.59	98168.0
2016-03-11	AAVL-DELISTED	Stock	5.16	5.2	4.98	5.18	413933.0
2016-03-11	AAWW-DELISTED	Stock	39.27	40.76	39.27	40.71	202563.0
2016-03-11	AAXJ	Stock	52.62	53.11	52.51	53.08	787083.0
2016-03-11	AAXN-DELISTED	Stock	19.46	19.72	19.22	19.53	732033.0
2016-03-11	AB	Stock	22.34	22.53	22.07	22.26	321600.0
2016-03-11	ABAC-DELISTED	Stock	0.669	0.669	0.6122	0.62	6776.0
2016-03-11	ABAX-DELISTED	Stock	41.99	42.97	41.88	42.77	137706.0
2016-03-11	ABB-DELISTED	Stock	18.53	18.69	18.49	18.67	1684522.0
2016-03-11	ABBNY-DELISTED	Stock	18.53	18.69	18.49	18.67	1911973.0
2016-03-11	ABBV	Stock	56.4	57.87	56.35	57.73	6537400.0
2016-03-11	ABC-DELISTED	Stock	87.02	89.64	86.56	89.55	3315360.0
2016-03-11	ABCB	Stock	28.16	28.44	28.01	28.42	134200.0
2016-03-11	ABCD-DELISTED	Stock	4.39	4.5	4.34	4.5	35567.0
2016-03-11	ABCO-DELISTED	Stock	28.88	29.005	28.14	28.56	581359.0
2016-03-11	ABCW-DELISTED	Stock	43.56	44.1999	43.41	44.17	103420.0
2016-03-11	ABDC-DELISTED	Stock	10.7	10.7	10.3544	10.52	38263.0
2016-03-11	ABE-DELISTED	Stock	11.31	11.31	11.2501	11.285	10500.0
2016-03-11	ABEO	Stock	68.0	69.75	67.25	69.75	1044.0
2016-03-11	ABEV	Stock	5.11	5.14	4.96	4.99	27487700.0
2016-03-11	ABG	Stock	58.77	61.38	58.77	61.27	415800.0
2016-03-11	ABGB-DELISTED	Stock	1.49	1.62	1.48	1.54	33831.0
2016-03-11	ABIL-DELISTED	Stock	6.4535	6.4535	6.4	6.4	2000.0

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

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