PREVIEW / stock_daily / 2016-01-29

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-29.parquet
  size:    221 KB
  rows:    6,652
  symbols: 3,394

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-01-29	AAPL	Stock	23.6975	24.335	23.5875	24.335	257666000.0
2016-01-29	MSFT	Stock	54.73	55.09	54.0	55.09	83611700.0
2016-01-29	NVDA	Stock	0.7072	0.7338	0.7045	0.7323	310504000.0
2016-01-29	AMZN	Stock	28.599	29.65	28.5	29.35	293552000.0
2016-01-29	GOOGL	Stock	37.448	38.2553	37.21	38.0675	75807900.0
2016-01-29	META	Stock	108.99	112.84	108.84	112.21	62739500.0
2016-01-29	TSLA	Stock	12.6633	12.916	12.5387	12.7467	42784500.0
2016-01-29	TLT	Stock	127.41	127.86	126.915	127.3	13170724.0
2016-01-29	ES	Stock	53.63	54.15	53.37	53.8	3007800.0
2016-01-29	CL	Stock	64.99	67.65	64.35	67.53	9512900.0
2016-01-29	A	Stock	36.44	37.69	36.31	37.65	2959900.0
2016-01-29	AA.B-DELISTED	Stock	25.6	26.8	25.6	26.493	54135.0
2016-01-29	AAAP-DELISTED	Stock	23.19	24.9689	23.175	24.91	54817.0
2016-01-29	AABA-DELISTED	Stock	29.1	29.49	28.51	29.43	18074889.0
2016-01-29	AAC-DELISTED	Stock	17.17	18.13	17.17	17.845	254756.0
2016-01-29	AACG	Stock	5.23	5.5	5.23	5.43	7700.0
2016-01-29	AAIC-DELISTED	Stock	10.95	11.29	10.8501	11.1	236345.0
2016-01-29	AAL	Stock	37.52	39.09	36.6	38.99	20957500.0
2016-01-29	AAMC-DELISTED	Stock	4.6353	4.7353	4.5147	4.5441	78006.0
2016-01-29	AAME	Stock	4.49	4.5	4.36	4.36	3600.0
2016-01-29	AAMI	Stock	10.75	11.31	10.75	11.31	375900.0
2016-01-29	AAOI	Stock	16.26	16.66	15.87	16.37	227300.0
2016-01-29	AAON	Stock	13.68	14.38	13.68	14.3533	403650.0
2016-01-29	AAP	Stock	149.87	152.23	148.18	152.05	1255600.0
2016-01-29	AAT	Stock	37.1	37.41	36.92	37.39	499800.0
2016-01-29	AAU-DELISTED	Stock	0.5699	0.61	0.5699	0.605	201104.0
2016-01-29	AAUAF-DELISTED	Stock	0.5699	0.61	0.5699	0.605	309962.0
2016-01-29	AAV-DELISTED	Stock	5.5	5.625	5.297	5.46	623880.0
2016-01-29	AAVL-DELISTED	Stock	5.84	6.24	5.7105	6.02	388248.0
2016-01-29	AAWW-DELISTED	Stock	34.76	36.81	34.76	36.72	253392.0
2016-01-29	AAXJ	Stock	49.18	49.79	49.16	49.75	1720305.0
2016-01-29	AAXN-DELISTED	Stock	14.86	15.4	14.86	15.39	1045662.0
2016-01-29	AB	Stock	18.34	18.55	18.27	18.44	282600.0
2016-01-29	ABAC-DELISTED	Stock	0.656	0.656	0.6211	0.6211	1200.0
2016-01-29	ABAX-DELISTED	Stock	37.71	45.19	37.71	43.55	1207436.0
2016-01-29	ABB-DELISTED	Stock	17.06	17.31	17.02	17.305	2058034.0
2016-01-29	ABBNY-DELISTED	Stock	17.06	17.31	17.02	17.3	2117552.0
2016-01-29	ABBV	Stock	53.42	55.31	53.42	54.9	17768700.0
2016-01-29	ABC-DELISTED	Stock	87.55	89.6	87.28	89.54	3508174.0
2016-01-29	ABCB	Stock	28.05	28.95	27.83	28.93	330500.0
2016-01-29	ABCD-DELISTED	Stock	4.4	4.54	4.37	4.5	20050.0
2016-01-29	ABCO-DELISTED	Stock	43.82	46.02	43.65	45.77	304022.0
2016-01-29	ABCW-DELISTED	Stock	41.91	42.8	41.87	42.71	245433.0
2016-01-29	ABDC-DELISTED	Stock	10.61	11.0205	10.61	10.75	26282.0
2016-01-29	ABE-DELISTED	Stock	10.16	10.39	10.13	10.39	14722.0
2016-01-29	ABEO	Stock	60.75	65.75	60.5	65.25	6524.0
2016-01-29	ABEOW-DELISTED	Stock	0.9	0.9153	0.81	0.9153	8200.0
2016-01-29	ABEV	Stock	4.51	4.68	4.47	4.67	19187800.0
2016-01-29	ABG	Stock	46.0	47.08	45.57	47.08	630600.0
2016-01-29	ABGB-DELISTED	Stock	0.957	1.0	0.935	0.96	15900.0

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

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