PREVIEW / stock_daily / 2017-02-16

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-16.parquet
  size:    216 KB
  rows:    6,488
  symbols: 3,079

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-02-16	AAPL	Stock	33.9175	33.975	33.71	33.8375	90338400.0
2017-02-16	MSFT	Stock	64.74	65.24	64.44	64.52	20546300.0
2017-02-16	NVDA	Stock	2.7348	2.736	2.6415	2.6813	647176000.0
2017-02-16	AMZN	Stock	42.092	42.25	41.969	42.207	54294000.0
2017-02-16	GOOGL	Stock	41.925	42.1345	41.863	42.1085	20101680.0
2017-02-16	META	Stock	133.07	133.87	133.02	133.84	12831100.0
2017-02-16	TSLA	Stock	18.5067	18.6667	17.9	17.93	106159500.0
2017-02-16	TLT	Stock	119.22	120.21	119.12	119.61	10005829.0
2017-02-16	ES	Stock	55.74	56.3	55.65	56.29	1009400.0
2017-02-16	CL	Stock	68.61	69.04	68.03	69.0	5172700.0
2017-02-16	A	Stock	51.68	51.68	50.56	50.84	2550400.0
2017-02-16	AA	Stock	37.82	37.83	36.35	36.46	7040700.0
2017-02-16	AAAP-DELISTED	Stock	35.8	36.16	35.62	35.93	204073.0
2017-02-16	AABA-DELISTED	Stock	45.65	45.69	45.01	45.15	7241065.0
2017-02-16	AAC-DELISTED	Stock	8.03	8.21	7.91	8.05	53528.0
2017-02-16	AACG	Stock	3.69	3.72	3.65	3.65	6200.0
2017-02-16	AAIC-DELISTED	Stock	14.72	14.9551	14.72	14.91	343078.0
2017-02-16	AAL	Stock	47.5	47.65	46.66	46.97	5681800.0
2017-02-16	AAMC-DELISTED	Stock	22.9412	22.9412	21.2651	21.9556	38787.0
2017-02-16	AAME	Stock	3.75	3.89	3.7	3.89	1500.0
2017-02-16	AAMI	Stock	15.32	15.32	14.92	14.99	375500.0
2017-02-16	AAOI	Stock	36.18	36.18	35.16	35.79	357500.0
2017-02-16	AAON	Stock	23.1333	23.3333	22.8333	23.3	157350.0
2017-02-16	AAP	Stock	164.21	164.46	160.32	160.99	1357800.0
2017-02-16	AAT	Stock	43.21	43.51	43.11	43.22	106100.0
2017-02-16	AAU-DELISTED	Stock	1.25	1.25	1.22	1.235	137042.0
2017-02-16	AAUAF-DELISTED	Stock	1.25	1.25	1.22	1.235	137777.0
2017-02-16	AAV-DELISTED	Stock	6.6	6.65	6.5	6.6	73898.0
2017-02-16	AAWW-DELISTED	Stock	54.4	54.4	53.25	53.95	201024.0
2017-02-16	AAXJ	Stock	60.82	60.82	60.6	60.7	1014695.0
2017-02-16	AAXN-DELISTED	Stock	26.49	26.68	26.27	26.68	387966.0
2017-02-16	AB	Stock	23.75	24.2	23.75	23.85	562300.0
2017-02-16	ABAC-DELISTED	Stock	3.318	3.318	3.15	3.25	17327.0
2017-02-16	ABAX-DELISTED	Stock	49.08	49.08	48.61	49.03	69215.0
2017-02-16	ABB-DELISTED	Stock	22.96	23.03	22.9372	23.01	1121307.0
2017-02-16	ABBNY-DELISTED	Stock	22.96	23.03	22.9372	23.01	1159777.0
2017-02-16	ABBV	Stock	61.67	61.91	60.81	61.48	5662000.0
2017-02-16	ABC-DELISTED	Stock	91.0	91.54	89.0	90.31	1930978.0
2017-02-16	ABCB	Stock	47.95	48.55	47.72	48.55	128000.0
2017-02-16	ABCD-DELISTED	Stock	4.82	4.83	4.64	4.7	13842.0
2017-02-16	ABCO-DELISTED	Stock	47.4	47.4	46.85	47.2	236543.0
2017-02-16	ABDC-DELISTED	Stock	12.72	12.87	12.51	12.79	33911.0
2017-02-16	ABE-DELISTED	Stock	12.18	12.18	11.98	12.0012	75411.0
2017-02-16	ABEO	Stock	150.0	156.25	143.75	153.75	19560.0
2017-02-16	ABEOW-DELISTED	Stock	3.25	3.25	3.25	3.25	300.0
2017-02-16	ABEV	Stock	5.83	5.85	5.78	5.81	15433900.0
2017-02-16	ABG	Stock	67.5	67.8	65.7	65.95	299500.0
2017-02-16	ABIL-DELISTED	Stock	2.94	2.94	2.71	2.83	36359.0
2017-02-16	ABM	Stock	40.25	40.87	40.21	40.87	366200.0
2017-02-16	ABMD-DELISTED	Stock	110.98	114.4	110.61	114.26	602561.0

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

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