PREVIEW / stock_daily / 2016-08-09

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-09.parquet
  size:    219 KB
  rows:    6,529
  symbols: 3,237

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-08-09	AAPL	Stock	27.0575	27.235	27.0025	27.2025	105260800.0
2016-08-09	MSFT	Stock	58.17	58.5	58.02	58.2	16920700.0
2016-08-09	NVDA	Stock	1.4758	1.4865	1.4685	1.4722	372344000.0
2016-08-09	AMZN	Stock	38.3695	38.63	38.345	38.4155	37522000.0
2016-08-09	GOOGL	Stock	40.2245	40.6665	40.203	40.374	32153700.0
2016-08-09	META	Stock	125.34	126.09	124.53	125.06	19621000.0
2016-08-09	TSLA	Stock	15.1213	15.436	15.11	15.272	33117000.0
2016-08-09	TLT	Stock	138.71	139.72	138.62	139.62	5503166.0
2016-08-09	ES	Stock	56.78	57.26	56.64	56.84	799700.0
2016-08-09	CL	Stock	74.55	75.03	74.47	74.78	1535700.0
2016-08-09	A	Stock	47.11	47.63	47.11	47.45	1006200.0
2016-08-09	AA.B-DELISTED	Stock	35.88	35.95	35.43	35.45	55215.0
2016-08-09	AAAP-DELISTED	Stock	31.19	32.2	31.11	31.69	19157.0
2016-08-09	AABA-DELISTED	Stock	39.24	39.31	39.1	39.24	5507458.0
2016-08-09	AAC-DELISTED	Stock	18.88	18.95	17.91	18.06	174020.0
2016-08-09	AACG	Stock	3.7	3.75	3.33	3.67	19600.0
2016-08-09	AAIC-DELISTED	Stock	15.12	15.16	14.9701	15.03	276086.0
2016-08-09	AAL	Stock	35.21	35.5	34.54	34.59	7307200.0
2016-08-09	AAMC-DELISTED	Stock	3.9735	4.0971	3.8412	3.9059	58541.0
2016-08-09	AAME	Stock	4.1	4.16	4.1	4.14	600.0
2016-08-09	AAMI	Stock	13.71	13.74	13.52	13.66	128900.0
2016-08-09	AAOI	Stock	14.25	14.41	13.93	13.97	402200.0
2016-08-09	AAON	Stock	18.1933	18.2867	18.02	18.1533	178200.0
2016-08-09	AAP	Stock	168.75	169.56	166.29	166.5	514000.0
2016-08-09	AAT	Stock	45.28	45.84	44.96	45.75	185000.0
2016-08-09	AAU-DELISTED	Stock	1.5	1.59	1.49	1.58	551875.0
2016-08-09	AAUAF-DELISTED	Stock	1.5	1.59	1.49	1.58	554119.0
2016-08-09	AAV-DELISTED	Stock	6.71	6.86	6.69	6.74	59675.0
2016-08-09	AAWW-DELISTED	Stock	36.02	36.48	35.09	35.12	303653.0
2016-08-09	AAXJ	Stock	58.82	59.1	58.755	58.91	445779.0
2016-08-09	AAXN-DELISTED	Stock	28.73	29.07	28.53	28.69	1041543.0
2016-08-09	AB	Stock	21.86	22.04	21.67	21.67	209400.0
2016-08-09	ABAC-DELISTED	Stock	0.6828	0.69	0.6501	0.685	132646.0
2016-08-09	ABAX-DELISTED	Stock	49.07	49.86	48.835	49.85	147192.0
2016-08-09	ABB-DELISTED	Stock	21.55	21.64	21.52	21.56	828388.0
2016-08-09	ABBNY-DELISTED	Stock	21.55	21.64	21.52	21.56	862906.0
2016-08-09	ABBV	Stock	66.34	67.25	66.25	66.76	5717300.0
2016-08-09	ABC-DELISTED	Stock	88.78	89.36	88.37	88.63	1327194.0
2016-08-09	ABCB	Stock	33.53	33.81	33.45	33.79	91700.0
2016-08-09	ABCD-DELISTED	Stock	4.8025	4.8025	4.73	4.77	8768.0
2016-08-09	ABCO-DELISTED	Stock	41.42	42.18	40.2417	41.5	130810.0
2016-08-09	ABDC-DELISTED	Stock	12.35	12.4	12.3029	12.37	44240.0
2016-08-09	ABE-DELISTED	Stock	12.67	12.72	12.67	12.72	500.0
2016-08-09	ABEO	Stock	93.75	98.0	87.5	95.5	3784.0
2016-08-09	ABEOW-DELISTED	Stock	1.33	2.1	1.33	1.95	69201.0
2016-08-09	ABEV	Stock	6.08	6.15	6.06	6.13	15488500.0
2016-08-09	ABG	Stock	57.27	57.52	54.49	54.99	401500.0
2016-08-09	ABIL-DELISTED	Stock	5.6	5.6	5.5	5.54	21532.0
2016-08-09	ABM	Stock	37.06	37.23	36.98	37.2	179400.0
2016-08-09	ABMD-DELISTED	Stock	120.81	124.06	120.81	123.34	464094.0

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

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