PREVIEW / stock_daily / 2017-09-20

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-20.parquet
  size:    215 KB
  rows:    6,435
  symbols: 2,928

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-09-20	AAPL	Stock	39.475	39.565	38.4575	39.0175	211805600.0
2017-09-20	MSFT	Stock	75.35	75.55	74.31	74.94	21587900.0
2017-09-20	NVDA	Stock	4.6875	4.7355	4.6053	4.646	724920000.0
2017-09-20	AMZN	Stock	48.5895	48.7405	48.108	48.6605	57776000.0
2017-09-20	GOOGL	Stock	46.8865	47.5	46.875	47.377	40080360.0
2017-09-20	META	Stock	172.5	173.05	170.7	172.17	12264100.0
2017-09-20	TSLA	Stock	24.8667	25.2167	24.738	24.9273	73786500.0
2017-09-20	TLT	Stock	125.97	126.05	125.33	125.91	8036991.0
2017-09-20	ES	Stock	61.96	61.98	61.14	61.48	1573600.0
2017-09-20	CL	Stock	72.85	73.22	72.1	72.55	2084100.0
2017-09-20	A	Stock	66.31	66.36	65.77	66.09	1186000.0
2017-09-20	AA	Stock	46.98	47.95	46.53	47.5	7305700.0
2017-09-20	AAAP-DELISTED	Stock	57.85	58.26	56.92	57.5325	225552.0
2017-09-20	AABA-DELISTED	Stock	67.37	67.59	66.4	66.92	4996851.0
2017-09-20	AAC-DELISTED	Stock	10.18	10.89	10.13	10.73	139252.0
2017-09-20	AACG	Stock	4.71	4.76	4.71	4.76	900.0
2017-09-20	AAIC-DELISTED	Stock	13.31	13.38	13.29	13.32	470707.0
2017-09-20	AAL	Stock	44.92	45.56	44.46	45.42	4708100.0
2017-09-20	AAM.A-DELISTED	Stock	26.24	26.28	26.14	26.17	38883.0
2017-09-20	AAMC-DELISTED	Stock	28.5294	28.5294	24.7544	25.8824	20876.0
2017-09-20	AAME	Stock	3.25	3.3	3.21	3.3	2100.0
2017-09-20	AAMI	Stock	13.75	13.99	13.635	13.65	910800.0
2017-09-20	AAOI	Stock	67.25	68.95	63.7	63.96	3490600.0
2017-09-20	AAON	Stock	22.0667	22.5667	21.5933	22.3	188850.0
2017-09-20	AAP	Stock	94.5	96.1	93.67	94.75	1454400.0
2017-09-20	AAT	Stock	40.06	40.22	39.72	40.02	177200.0
2017-09-20	AAU-DELISTED	Stock	1.16	1.23	1.13	1.16	229529.0
2017-09-20	AAUAF-DELISTED	Stock	1.16	1.23	1.13	1.16	232583.0
2017-09-20	AAV-DELISTED	Stock	6.55	6.7	6.5	6.6	70492.0
2017-09-20	AAWW-DELISTED	Stock	66.25	68.7	66.2038	68.15	252284.0
2017-09-20	AAXJ	Stock	73.8	73.87	72.85	73.4	606643.0
2017-09-20	AAXN-DELISTED	Stock	22.21	23.22	22.085	22.92	673277.0
2017-09-20	AB	Stock	24.3	24.55	24.0	24.25	212400.0
2017-09-20	ABAC-DELISTED	Stock	2.33	2.34	2.1863	2.34	3900.0
2017-09-20	ABAX-DELISTED	Stock	44.01	44.88	43.9	44.88	155093.0
2017-09-20	ABB-DELISTED	Stock	24.61	24.69	24.48	24.6	793234.0
2017-09-20	ABBNY-DELISTED	Stock	24.61	24.69	24.48	24.6	1332315.0
2017-09-20	ABBV	Stock	86.4	87.48	86.25	87.41	6559400.0
2017-09-20	ABC-DELISTED	Stock	79.47	80.09	78.3399	79.51	1094800.0
2017-09-20	ABCB	Stock	44.05	45.25	43.65	45.1	152900.0
2017-09-20	ABCD-DELISTED	Stock	6.23	6.28	6.14	6.155	20704.0
2017-09-20	ABCO-DELISTED	Stock	53.35	53.475	53.25	53.4	905674.0
2017-09-20	ABDC-DELISTED	Stock	10.87	10.93	10.8	10.81	26995.0
2017-09-20	ABE-DELISTED	Stock	14.22	14.23	14.18	14.1988	2239.0
2017-09-20	ABEO	Stock	423.75	423.75	404.5	412.5	23884.0
2017-09-20	ABEOW-DELISTED	Stock	12.89	12.99	12.5596	12.5596	1800.0
2017-09-20	ABEV	Stock	6.78	6.82	6.71	6.82	19948500.0
2017-09-20	ABG	Stock	58.25	59.35	58.1	58.75	97900.0
2017-09-20	ABIL-DELISTED	Stock	0.77	0.8	0.7483	0.7857	41331.0
2017-09-20	ABM	Stock	39.03	39.64	39.03	39.29	385200.0

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

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