PREVIEW / stock_daily / 2017-10-16

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-16.parquet
  size:    214 KB
  rows:    6,447
  symbols: 2,918

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-10-16	AAPL	Stock	39.475	40.0	39.4125	39.97	96486000.0
2017-10-16	MSFT	Stock	77.42	77.81	77.35	77.65	12380100.0
2017-10-16	NVDA	Stock	4.895	4.9513	4.831	4.9483	576640000.0
2017-10-16	AMZN	Stock	50.422	50.4785	50.052	50.317	40178000.0
2017-10-16	GOOGL	Stock	50.4815	50.6	50.076	50.4675	21420460.0
2017-10-16	META	Stock	174.49	175.0	174.06	174.52	11498800.0
2017-10-16	TSLA	Stock	23.584	23.632	23.144	23.3733	80632500.0
2017-10-16	TLT	Stock	125.53	125.9	125.38	125.76	5737322.0
2017-10-16	ES	Stock	61.54	61.72	60.99	61.2	2079200.0
2017-10-16	CL	Stock	75.89	76.1	75.32	75.75	2229600.0
2017-10-16	A	Stock	67.2	67.37	66.77	66.91	1473400.0
2017-10-16	AA	Stock	48.0	48.93	47.48	48.24	4682000.0
2017-10-16	AAAP-DELISTED	Stock	68.75	72.37	67.57	71.05	584412.0
2017-10-16	AABA-DELISTED	Stock	67.91	68.13	67.36	68.02	3803069.0
2017-10-16	AAC-DELISTED	Stock	8.27	8.55	7.95	8.03	240051.0
2017-10-16	AACG	Stock	4.64	4.64	4.64	4.64	300.0
2017-10-16	AAIC-DELISTED	Stock	12.6	12.82	12.6	12.71	545302.0
2017-10-16	AAL	Stock	52.52	52.68	51.93	52.27	3262300.0
2017-10-16	AAM.A-DELISTED	Stock	26.0432	26.0928	26.008	26.08	32186.0
2017-10-16	AAMC-DELISTED	Stock	25.5882	25.5882	25.5735	25.5735	1557.0
2017-10-16	AAME	Stock	3.35	3.4	3.25	3.3	2800.0
2017-10-16	AAMI	Stock	15.45	15.54	15.22	15.28	256900.0
2017-10-16	AAOI	Stock	47.0	47.75	43.135	43.38	4536700.0
2017-10-16	AAON	Stock	22.6333	23.4333	22.5333	22.8667	159300.0
2017-10-16	AAP	Stock	85.7	86.05	84.76	86.01	2448000.0
2017-10-16	AAT	Stock	41.2	41.33	40.53	40.65	169300.0
2017-10-16	AAU-DELISTED	Stock	1.18	1.18	1.14	1.165	150758.0
2017-10-16	AAUAF-DELISTED	Stock	1.18	1.18	1.14	1.17	157940.0
2017-10-16	AAV-DELISTED	Stock	5.6	5.6	5.375	5.45	163788.0
2017-10-16	AAWW-DELISTED	Stock	65.6	65.6	63.525	64.75	176030.0
2017-10-16	AAXJ	Stock	75.3	75.44	75.265	75.39	824805.0
2017-10-16	AAXN-DELISTED	Stock	24.65	24.65	24.225	24.31	384935.0
2017-10-16	AB	Stock	24.9	25.15	24.9	25.0	107800.0
2017-10-16	ABAC-DELISTED	Stock	3.38	3.49	3.27	3.48	6186.0
2017-10-16	ABAX-DELISTED	Stock	45.72	46.251	45.6102	45.91	50651.0
2017-10-16	ABB-DELISTED	Stock	24.97	25.015	24.941	24.97	792974.0
2017-10-16	ABBNY-DELISTED	Stock	24.97	25.015	24.941	24.97	823672.0
2017-10-16	ABBV	Stock	91.01	91.99	90.56	91.04	4640300.0
2017-10-16	ABC-DELISTED	Stock	79.02	81.04	78.4	79.01	2273464.0
2017-10-16	ABCB	Stock	48.85	50.25	48.85	49.65	179100.0
2017-10-16	ABCD-DELISTED	Stock	6.21	6.46	6.02	6.12	88765.0
2017-10-16	ABCO-DELISTED	Stock	53.9	53.9	53.8	53.8	1153341.0
2017-10-16	ABDC-DELISTED	Stock	10.55	10.5759	10.426	10.44	37000.0
2017-10-16	ABE-DELISTED	Stock	14.74	14.74	14.69	14.7	19040.0
2017-10-16	ABEO	Stock	427.5	432.5	400.0	417.5	49952.0
2017-10-16	ABEOW-DELISTED	Stock	11.75	12.2	11.69	11.75	5650.0
2017-10-16	ABEV	Stock	6.89	6.94	6.81	6.84	18151400.0
2017-10-16	ABG	Stock	57.5	57.9	56.35	56.8	201200.0
2017-10-16	ABIL-DELISTED	Stock	0.7741	0.8	0.729	0.7383	146715.0
2017-10-16	ABM	Stock	42.89	43.23	42.7	42.7	176000.0

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

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