PREVIEW / stock_daily / 2016-10-05

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-05.parquet
  size:    219 KB
  rows:    6,503
  symbols: 3,177

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-10-05	AAPL	Stock	28.35	28.415	28.1725	28.2625	85812400.0
2016-10-05	MSFT	Stock	57.29	57.96	57.26	57.64	16726400.0
2016-10-05	NVDA	Stock	1.722	1.7395	1.7005	1.7058	305440000.0
2016-10-05	AMZN	Stock	41.9	42.2835	41.806	42.218	69382000.0
2016-10-05	GOOGL	Stock	40.3	40.425	40.0355	40.0615	24276400.0
2016-10-05	META	Stock	128.25	128.8	127.83	128.47	12386800.0
2016-10-05	TSLA	Stock	14.1493	14.21	13.8747	13.8973	28162500.0
2016-10-05	TLT	Stock	135.02	135.08	134.12	134.58	8917655.0
2016-10-05	ES	Stock	53.22	53.24	52.18	52.56	2671500.0
2016-10-05	CL	Stock	73.02	73.1	72.59	72.97	2365500.0
2016-10-05	A	Stock	47.04	47.31	46.93	47.15	1431900.0
2016-10-05	AA.B-DELISTED	Stock	33.12	33.4999	32.89	33.3599	5185134.0
2016-10-05	AAAP-DELISTED	Stock	36.99	38.98	36.6	38.98	168679.0
2016-10-05	AABA-DELISTED	Stock	43.23	43.87	43.22	43.71	5709617.0
2016-10-05	AAC-DELISTED	Stock	17.35	17.56	17.075	17.23	130375.0
2016-10-05	AACG	Stock	4.1	4.2	4.09	4.2	900.0
2016-10-05	AAIC-DELISTED	Stock	14.49	14.646	14.43	14.45	147890.0
2016-10-05	AAL	Stock	37.82	38.12	37.31	37.87	4713100.0
2016-10-05	AAMC-DELISTED	Stock	6.218	6.5706	6.1206	6.2529	31450.0
2016-10-05	AAME	Stock	3.39	3.39	3.26	3.26	2100.0
2016-10-05	AAMI	Stock	13.96	14.16	13.83	14.1	258700.0
2016-10-05	AAOI	Stock	22.06	24.18	21.786	23.26	763200.0
2016-10-05	AAON	Stock	20.0333	20.5333	19.9067	20.32	238200.0
2016-10-05	AAP	Stock	147.62	149.4	147.5	148.93	699000.0
2016-10-05	AAT	Stock	41.71	41.79	40.64	40.87	271800.0
2016-10-05	AAU-DELISTED	Stock	1.2	1.3	1.19	1.3	486121.0
2016-10-05	AAUAF-DELISTED	Stock	1.2	1.3	1.19	1.3	491011.0
2016-10-05	AAV-DELISTED	Stock	7.05	7.31	7.03	7.26	75437.0
2016-10-05	AAWW-DELISTED	Stock	42.34	43.5	42.09	43.28	148183.0
2016-10-05	AAXJ	Stock	60.82	61.09	60.7	61.04	719208.0
2016-10-05	AAXN-DELISTED	Stock	23.87	23.99	22.9221	23.195	2903415.0
2016-10-05	AB	Stock	22.32	22.64	22.32	22.52	115300.0
2016-10-05	ABAC-DELISTED	Stock	2.1	2.1265	2.0392	2.12	10001.0
2016-10-05	ABAX-DELISTED	Stock	52.44	53.21	52.08	52.75	113530.0
2016-10-05	ABB-DELISTED	Stock	22.66	22.79	22.59	22.76	1231884.0
2016-10-05	ABBNY-DELISTED	Stock	22.66	22.79	22.59	22.76	1265594.0
2016-10-05	ABBV	Stock	63.08	63.75	63.0	63.39	4442500.0
2016-10-05	ABC-DELISTED	Stock	80.71	80.8585	79.88	80.03	1519047.0
2016-10-05	ABCB	Stock	35.25	35.82	35.2	35.55	237400.0
2016-10-05	ABCD-DELISTED	Stock	5.37	5.39	5.3363	5.35	12709.0
2016-10-05	ABCO-DELISTED	Stock	43.4	43.4	42.02	42.43	295393.0
2016-10-05	ABDC-DELISTED	Stock	12.71	13.03	12.55	12.78	69346.0
2016-10-05	ABE-DELISTED	Stock	12.73	12.73	12.68	12.68	6472.0
2016-10-05	ABEO	Stock	147.5	175.0	147.5	167.25	27652.0
2016-10-05	ABEOW-DELISTED	Stock	3.24	3.6	3.24	3.6	1934.0
2016-10-05	ABEV	Stock	6.06	6.1	6.02	6.07	5231400.0
2016-10-05	ABG	Stock	54.29	56.71	54.28	55.98	151300.0
2016-10-05	ABIL-DELISTED	Stock	3.79	3.85	3.78	3.82	20317.0
2016-10-05	ABM	Stock	39.42	39.56	39.04	39.1	195400.0
2016-10-05	ABMD-DELISTED	Stock	127.49	128.5	126.7	127.46	345700.0

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

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