PREVIEW / stock_daily / 2016-01-28

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-28.parquet
  size:    218 KB
  rows:    6,577
  symbols: 3,351

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-28	AAPL	Stock	23.4475	23.63	23.0975	23.5225	222715200.0
2016-01-28	MSFT	Stock	51.86	52.21	51.25	52.06	62513800.0
2016-01-28	NVDA	Stock	0.7148	0.7173	0.6875	0.7012	276776000.0
2016-01-28	AMZN	Stock	30.4185	31.903	29.8775	31.7675	280304000.0
2016-01-28	GOOGL	Stock	36.9095	37.558	36.53	37.415	62104440.0
2016-01-28	META	Stock	107.2	110.34	104.81	109.11	107475300.0
2016-01-28	TSLA	Stock	12.7193	12.752	12.1607	12.6467	68892000.0
2016-01-28	TLT	Stock	125.54	126.41	125.46	126.23	10575351.0
2016-01-28	ES	Stock	52.19	53.52	51.76	53.09	1850500.0
2016-01-28	CL	Stock	64.56	65.55	64.32	65.02	5576500.0
2016-01-28	A	Stock	37.27	37.27	36.01	36.11	3479400.0
2016-01-28	AA.B-DELISTED	Stock	24.8	25.7758	24.8	25.6	23577.0
2016-01-28	AAAP-DELISTED	Stock	23.71	25.079	23.01	23.5	296694.0
2016-01-28	AABA-DELISTED	Stock	30.61	30.63	28.6	28.74	14922334.0
2016-01-28	AAC-DELISTED	Stock	19.68	19.94	16.44	17.1399	275322.0
2016-01-28	AACG	Stock	5.6	5.6	5.11	5.2	13100.0
2016-01-28	AAIC-DELISTED	Stock	10.88	11.11	10.65	10.85	158862.0
2016-01-28	AAL	Stock	39.61	39.79	37.66	38.14	17112300.0
2016-01-28	AAMC-DELISTED	Stock	4.7647	5.0926	4.5971	4.6029	152320.0
2016-01-28	AAME	Stock	4.34	4.47	4.32	4.45	1400.0
2016-01-28	AAMI	Stock	10.84	10.88	10.46	10.66	225600.0
2016-01-28	AAOI	Stock	16.5	17.05	15.93	16.27	597200.0
2016-01-28	AAON	Stock	13.78	13.8067	13.52	13.6267	121650.0
2016-01-28	AAP	Stock	152.96	153.7	145.67	148.56	1001800.0
2016-01-28	AAT	Stock	37.07	37.14	36.52	36.85	223600.0
2016-01-28	AAU-DELISTED	Stock	0.61	0.62	0.5811	0.5811	120310.0
2016-01-28	AAUAF-DELISTED	Stock	0.61	0.62	0.5811	0.5811	185235.0
2016-01-28	AAV-DELISTED	Stock	5.42	5.51	5.3	5.48	227873.0
2016-01-28	AAVL-DELISTED	Stock	6.34	6.51	5.74	5.85	254651.0
2016-01-28	AAWW-DELISTED	Stock	35.1	35.56	33.46	34.52	133952.0
2016-01-28	AAXJ	Stock	48.63	48.825	48.12	48.37	1727590.0
2016-01-28	AAXN-DELISTED	Stock	15.33	15.55	14.735	14.8	838422.0
2016-01-28	AB	Stock	18.75	19.04	18.23	18.24	233600.0
2016-01-28	ABAX-DELISTED	Stock	52.08	52.08	49.86	50.44	141390.0
2016-01-28	ABB-DELISTED	Stock	17.12	17.16	16.825	16.92	2784535.0
2016-01-28	ABBNY-DELISTED	Stock	17.12	17.16	16.825	16.93	2863132.0
2016-01-28	ABBV	Stock	57.23	57.73	54.78	55.85	10521100.0
2016-01-28	ABC-DELISTED	Stock	90.5	90.73	87.09	87.28	5706371.0
2016-01-28	ABCB	Stock	27.88	28.29	27.76	27.96	181800.0
2016-01-28	ABCD-DELISTED	Stock	4.46	4.49	4.36	4.38	8943.0
2016-01-28	ABCO-DELISTED	Stock	43.98	44.69	43.52	43.8	138247.0
2016-01-28	ABCW-DELISTED	Stock	41.64	42.0	41.39	41.9	145509.0
2016-01-28	ABDC-DELISTED	Stock	10.75	11.2499	10.36	10.61	61442.0
2016-01-28	ABE-DELISTED	Stock	10.07	10.09	10.04	10.07	1100.0
2016-01-28	ABEO	Stock	63.0	66.25	60.25	61.5	2732.0
2016-01-28	ABEOW-DELISTED	Stock	0.71	0.71	0.68	0.69	6400.0
2016-01-28	ABEV	Stock	4.41	4.48	4.34	4.4	21767500.0
2016-01-28	ABG	Stock	47.28	47.73	44.62	45.81	658300.0
2016-01-28	ABGB-DELISTED	Stock	0.98	0.98	0.93	0.93	30730.0
2016-01-28	ABIL-DELISTED	Stock	9.2911	9.36	8.5	8.5	108944.0

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

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