PREVIEW / stock_daily / 2016-11-07

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-07.parquet
  size:    213 KB
  rows:    6,488
  symbols: 3,148

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-11-07	AAPL	Stock	27.52	27.6275	27.365	27.6025	130240000.0
2016-11-07	MSFT	Stock	59.78	60.52	59.78	60.42	31664800.0
2016-11-07	NVDA	Stock	1.7388	1.793	1.7375	1.7818	487580000.0
2016-11-07	AMZN	Stock	38.582	39.3865	38.547	39.2465	119688000.0
2016-11-07	GOOGL	Stock	39.7475	40.25	39.645	40.1015	39851400.0
2016-11-07	META	Stock	122.83	123.21	121.35	122.15	23008900.0
2016-11-07	TSLA	Stock	12.906	12.9527	12.67	12.8807	58051500.0
2016-11-07	TLT	Stock	130.75	131.0	130.44	130.62	5386725.0
2016-11-07	ES	Stock	53.48	54.3	52.99	54.29	1282300.0
2016-11-07	CL	Stock	70.26	70.69	70.06	70.54	3596700.0
2016-11-07	A	Stock	44.99	45.76	44.95	45.71	1724000.0
2016-11-07	AA	Stock	25.54	26.41	24.89	25.08	8377000.0
2016-11-07	AAAP-DELISTED	Stock	35.69	36.46	35.41	35.79	113996.0
2016-11-07	AABA-DELISTED	Stock	41.17	41.23	40.8601	41.05	5117636.0
2016-11-07	AAC-DELISTED	Stock	7.8	7.87	7.445	7.6	594068.0
2016-11-07	AACG	Stock	3.57	3.88	3.55	3.7	53500.0
2016-11-07	AAIC-DELISTED	Stock	14.6	14.83	14.6	14.68	171293.0
2016-11-07	AAL	Stock	40.39	41.65	40.31	41.49	8334200.0
2016-11-07	AAMC-DELISTED	Stock	10.7941	10.8664	10.3015	10.3235	25772.0
2016-11-07	AAMI	Stock	12.57	12.57	12.24	12.27	154400.0
2016-11-07	AAOI	Stock	22.25	23.67	22.054	23.5	884600.0
2016-11-07	AAON	Stock	18.7333	19.0	18.6	18.9	151800.0
2016-11-07	AAP	Stock	137.54	137.83	136.22	137.54	859300.0
2016-11-07	AAT	Stock	39.18	40.09	38.27	39.42	405300.0
2016-11-07	AAU-DELISTED	Stock	1.35	1.41	1.34	1.39	188731.0
2016-11-07	AAUAF-DELISTED	Stock	1.35	1.41	1.34	1.39	190636.0
2016-11-07	AAV-DELISTED	Stock	6.5	6.65	6.5	6.6	141575.0
2016-11-07	AAWW-DELISTED	Stock	44.25	45.15	43.7	44.8	224609.0
2016-11-07	AAXJ	Stock	58.74	59.135	58.62	59.11	458237.0
2016-11-07	AAXN-DELISTED	Stock	22.29	22.48	22.17	22.28	841524.0
2016-11-07	AB	Stock	21.25	21.59	21.05	21.1	188200.0
2016-11-07	ABAC-DELISTED	Stock	2.69	2.7785	2.69	2.71	20359.0
2016-11-07	ABAX-DELISTED	Stock	47.27	48.12	46.61	47.84	84219.0
2016-11-07	ABB-DELISTED	Stock	20.85	20.9	20.8	20.89	1229485.0
2016-11-07	ABBNY-DELISTED	Stock	20.85	20.9	20.8	20.89	1262003.0
2016-11-07	ABBV	Stock	56.81	61.16	56.64	58.91	17763100.0
2016-11-07	ABC-DELISTED	Stock	71.52	72.34	70.99	71.9	3125212.0
2016-11-07	ABCB	Stock	36.55	37.05	36.45	36.9	141900.0
2016-11-07	ABCD-DELISTED	Stock	5.01	5.29	5.01	5.18	13080.0
2016-11-07	ABCO-DELISTED	Stock	35.45	36.2	34.275	34.7	824595.0
2016-11-07	ABDC-DELISTED	Stock	12.86	12.86	11.91	12.0068	175603.0
2016-11-07	ABE-DELISTED	Stock	11.99	12.216	11.99	12.18	12066.0
2016-11-07	ABEO	Stock	142.5	148.25	136.25	138.75	15644.0
2016-11-07	ABEOW-DELISTED	Stock	2.8	2.8	2.29	2.66	17630.0
2016-11-07	ABEV	Stock	5.59	5.62	5.55	5.57	14951100.0
2016-11-07	ABG	Stock	50.2	51.3	49.8	50.2	205000.0
2016-11-07	ABIL-DELISTED	Stock	3.0	3.0314	2.96	2.989	12493.0
2016-11-07	ABM	Stock	38.64	39.23	38.46	39.0	169300.0
2016-11-07	ABMD-DELISTED	Stock	106.29	107.85	104.81	107.37	543525.0
2016-11-07	ABR	Stock	7.31	7.36	7.22	7.27	87100.0

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

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