PREVIEW / stock_daily / 2016-05-09

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-09.parquet
  size:    219 KB
  rows:    6,572
  symbols: 3,298

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-05-09	AAPL	Stock	23.25	23.4425	23.1475	23.1975	131745600.0
2016-05-09	MSFT	Stock	50.49	50.59	50.0	50.07	17951600.0
2016-05-09	NVDA	Stock	0.8855	0.8893	0.8748	0.882	333336000.0
2016-05-09	AMZN	Stock	33.6975	34.349	33.5705	33.9875	79644000.0
2016-05-09	GOOGL	Stock	36.335	36.7145	36.175	36.4565	38073780.0
2016-05-09	META	Stock	119.54	120.28	118.9	119.24	21138100.0
2016-05-09	TSLA	Stock	14.3813	14.41	13.7867	13.928	71646000.0
2016-05-09	TLT	Stock	130.46	130.89	130.32	130.86	4950805.0
2016-05-09	ES	Stock	57.21	57.68	56.92	57.58	1340200.0
2016-05-09	CL	Stock	71.98	72.25	71.58	71.76	2352900.0
2016-05-09	A	Stock	41.51	41.78	41.29	41.33	1741500.0
2016-05-09	AA.B-DELISTED	Stock	34.59	34.59	33.39	33.45	38956.0
2016-05-09	AAAP-DELISTED	Stock	30.85	33.98	30.85	33.86	10358.0
2016-05-09	AABA-DELISTED	Stock	36.95	37.35	36.92	37.17	5429313.0
2016-05-09	AAC-DELISTED	Stock	21.34	21.94	20.78	21.52	105656.0
2016-05-09	AACG	Stock	5.27	5.49	5.27	5.38	4300.0
2016-05-09	AAIC-DELISTED	Stock	12.53	12.64	12.3545	12.46	222534.0
2016-05-09	AAL	Stock	33.03	33.8	32.94	32.94	9312500.0
2016-05-09	AAMC-DELISTED	Stock	3.3529	5.7412	3.3529	5.15	444951.0
2016-05-09	AAME	Stock	4.3	4.3	4.05	4.1	4200.0
2016-05-09	AAMI	Stock	14.07	14.25	13.96	14.12	316100.0
2016-05-09	AAOI	Stock	10.6	10.725	10.26	10.26	455800.0
2016-05-09	AAON	Stock	18.6667	18.7867	18.4	18.5267	407550.0
2016-05-09	AAP	Stock	150.0	152.06	149.41	151.53	546800.0
2016-05-09	AAT	Stock	41.87	42.36	41.87	42.21	73800.0
2016-05-09	AAU-DELISTED	Stock	1.14	1.14	1.03	1.03	408275.0
2016-05-09	AAUAF-DELISTED	Stock	1.14	1.14	1.03	1.05	413005.0
2016-05-09	AAV-DELISTED	Stock	5.25	5.28	5.1	5.21	60223.0
2016-05-09	AAVL-DELISTED	Stock	4.05	4.15	3.89	4.035	353485.0
2016-05-09	AAWW-DELISTED	Stock	46.85	47.51	45.06	46.02	503133.0
2016-05-09	AAXJ	Stock	52.13	52.13	51.64	51.68	513072.0
2016-05-09	AAXN-DELISTED	Stock	18.09	18.6699	18.05	18.56	595772.0
2016-05-09	AB	Stock	22.86	23.05	22.54	22.71	151900.0
2016-05-09	ABAC-DELISTED	Stock	0.6977	0.72	0.623	0.7	9913.0
2016-05-09	ABAX-DELISTED	Stock	44.6	45.85	43.0	45.08	150540.0
2016-05-09	ABB-DELISTED	Stock	20.53	20.55	20.385	20.405	2418209.0
2016-05-09	ABBNY-DELISTED	Stock	20.53	20.55	20.385	20.4	2850286.0
2016-05-09	ABBV	Stock	62.36	63.87	62.28	63.7	9917400.0
2016-05-09	ABC-DELISTED	Stock	76.43	78.48	76.27	77.36	3552442.0
2016-05-09	ABCB	Stock	30.73	31.02	30.42	30.75	87500.0
2016-05-09	ABCD-DELISTED	Stock	4.25	4.37	3.97	4.2601	10879.0
2016-05-09	ABCO-DELISTED	Stock	32.88	34.01	32.71	33.91	658147.0
2016-05-09	ABDC-DELISTED	Stock	11.5	11.6	11.0	11.0	51528.0
2016-05-09	ABE-DELISTED	Stock	11.83	11.83	11.73	11.76	5435.0
2016-05-09	ABEO	Stock	60.0	63.0	60.0	62.0	1172.0
2016-05-09	ABEV	Stock	5.31	5.33	5.14	5.32	17923800.0
2016-05-09	ABG	Stock	56.22	57.64	56.22	56.99	352000.0
2016-05-09	ABIL-DELISTED	Stock	3.09	3.25	3.0	3.21	152460.0
2016-05-09	ABM	Stock	32.46	32.95	32.41	32.87	191100.0
2016-05-09	ABMD-DELISTED	Stock	94.58	96.86	93.92	96.41	345760.0

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

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