PREVIEW / stock_daily / 2017-03-21

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-21.parquet
  size:    216 KB
  rows:    6,476
  symbols: 3,046

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
2017-03-21	AAPL	Stock	35.5275	35.7	34.9325	34.96	158119600.0
2017-03-21	MSFT	Stock	65.19	65.5	64.13	64.21	26640500.0
2017-03-21	NVDA	Stock	2.7188	2.749	2.6398	2.6478	913484000.0
2017-03-21	AMZN	Stock	42.942	43.14	42.0655	42.16	87658000.0
2017-03-21	GOOGL	Stock	43.503	43.6735	42.3844	42.507	50759560.0
2017-03-21	META	Stock	141.15	142.31	138.4	138.51	29894800.0
2017-03-21	TSLA	Stock	17.522	17.6533	16.6827	16.712	103629000.0
2017-03-21	TLT	Stock	119.05	120.3	119.02	120.14	12540662.0
2017-03-21	ES	Stock	58.41	59.72	58.34	59.44	1782300.0
2017-03-21	CL	Stock	73.96	74.01	73.5	73.7	3694700.0
2017-03-21	A	Stock	53.28	53.73	52.48	52.66	1492700.0
2017-03-21	AA	Stock	34.9	35.25	33.17	33.22	4536900.0
2017-03-21	AAAP-DELISTED	Stock	37.04	37.6	36.95	37.105	75282.0
2017-03-21	AABA-DELISTED	Stock	47.0	47.19	45.68	45.77	6031620.0
2017-03-21	AAC-DELISTED	Stock	8.39	8.5074	8.18	8.24	65806.0
2017-03-21	AACG	Stock	3.72	3.75	3.64	3.64	11200.0
2017-03-21	AAIC-DELISTED	Stock	14.49	14.49	14.17	14.25	392848.0
2017-03-21	AAL	Stock	41.88	41.98	40.34	40.42	7938700.0
2017-03-21	AAM.A-DELISTED	Stock	24.95	25.0	24.9	25.0	172843.0
2017-03-21	AAMC-DELISTED	Stock	17.7794	18.1912	17.2074	17.6471	38230.0
2017-03-21	AAME	Stock	3.95	3.95	3.9	3.95	1700.0
2017-03-21	AAMI	Stock	14.71	14.745	14.17	14.17	348400.0
2017-03-21	AAOI	Stock	50.48	51.97	48.06	48.23	1315000.0
2017-03-21	AAON	Stock	24.6333	24.6333	23.8667	23.9333	321750.0
2017-03-21	AAP	Stock	152.54	152.83	150.64	151.22	1061900.0
2017-03-21	AAT	Stock	42.24	42.3	41.77	41.81	235700.0
2017-03-21	AAU-DELISTED	Stock	1.03	1.15	1.03	1.13	458524.0
2017-03-21	AAUAF-DELISTED	Stock	1.03	1.15	1.03	1.13	462036.0
2017-03-21	AAV-DELISTED	Stock	6.05	6.125	5.95	6.0	130566.0
2017-03-21	AAWW-DELISTED	Stock	53.35	53.35	51.35	51.4	131382.0
2017-03-21	AAXJ	Stock	63.72	63.85	62.83	62.9	1667913.0
2017-03-21	AAXN-DELISTED	Stock	23.01	23.33	22.43	22.455	691860.0
2017-03-21	AB	Stock	22.4	22.55	21.9	21.95	289400.0
2017-03-21	ABAC-DELISTED	Stock	2.382	2.5186	2.25	2.32	21852.0
2017-03-21	ABAX-DELISTED	Stock	49.36	49.55	47.71	47.711	26695.0
2017-03-21	ABB-DELISTED	Stock	23.5	23.5562	23.045	23.09	3152753.0
2017-03-21	ABBNY-DELISTED	Stock	23.5	23.5562	23.045	23.09	3393052.0
2017-03-21	ABBV	Stock	65.96	66.0	65.04	65.35	5187400.0
2017-03-21	ABC-DELISTED	Stock	87.0	87.29	85.77	85.9	1614309.0
2017-03-21	ABCB	Stock	47.5	47.55	44.25	44.53	393400.0
2017-03-21	ABCD-DELISTED	Stock	5.11	5.11	4.9	5.0	37202.0
2017-03-21	ABCO-DELISTED	Stock	45.25	46.0	44.65	45.15	360585.0
2017-03-21	ABDC-DELISTED	Stock	13.64	13.75	13.3578	13.45	50932.0
2017-03-21	ABE-DELISTED	Stock	12.61	12.82	12.541	12.62	4727.0
2017-03-21	ABEO	Stock	125.0	128.75	119.75	121.25	14068.0
2017-03-21	ABEOW-DELISTED	Stock	3.0	3.03	3.0	3.03	400.0
2017-03-21	ABEV	Stock	5.71	5.71	5.59	5.59	15999400.0
2017-03-21	ABG	Stock	61.8	61.8	59.4	60.5	353700.0
2017-03-21	ABIL-DELISTED	Stock	2.35	2.35	2.34	2.34	2300.0
2017-03-21	ABM	Stock	44.18	44.27	43.39	43.44	281400.0

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

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