PREVIEW / stock_daily / 2017-09-21

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-21.parquet
  size:    213 KB
  rows:    6,414
  symbols: 2,915

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-21	AAPL	Stock	38.95	38.95	38.1875	38.3475	150046800.0
2017-09-21	MSFT	Stock	75.11	75.24	74.11	74.21	19186100.0
2017-09-21	NVDA	Stock	4.541	4.5675	4.4403	4.519	1075600000.0
2017-09-21	AMZN	Stock	48.5655	48.585	48.101	48.2325	46752000.0
2017-09-21	GOOGL	Stock	47.4065	47.64	46.969	47.3775	27413700.0
2017-09-21	META	Stock	171.69	172.27	170.01	171.11	11161400.0
2017-09-21	TSLA	Stock	24.9933	25.122	24.3007	24.432	69273000.0
2017-09-21	TLT	Stock	126.16	126.555	125.82	125.84	6147895.0
2017-09-21	ES	Stock	61.48	61.85	61.3	61.44	1125400.0
2017-09-21	CL	Stock	72.5	72.66	71.31	71.37	2378700.0
2017-09-21	A	Stock	65.88	66.14	65.63	65.92	874800.0
2017-09-21	AA	Stock	47.11	47.25	45.97	46.25	3695600.0
2017-09-21	AAAP-DELISTED	Stock	57.8	57.9	56.89	57.2	144371.0
2017-09-21	AABA-DELISTED	Stock	67.0	67.22	66.055	66.59	3769738.0
2017-09-21	AAC-DELISTED	Stock	10.7	10.835	9.52	9.54	124328.0
2017-09-21	AACG	Stock	4.7	4.83	4.69	4.83	26300.0
2017-09-21	AAIC-DELISTED	Stock	13.32	13.41	13.32	13.34	384619.0
2017-09-21	AAL	Stock	45.47	46.57	44.99	46.29	5864400.0
2017-09-21	AAM.A-DELISTED	Stock	26.1774	26.2899	26.15	26.16	31171.0
2017-09-21	AAMC-DELISTED	Stock	26.1765	26.1765	25.3529	25.739	6307.0
2017-09-21	AAME	Stock	3.2	3.3	3.2	3.2	2400.0
2017-09-21	AAMI	Stock	13.7	13.78	13.55	13.7	400300.0
2017-09-21	AAOI	Stock	63.99	65.39	61.3	63.6	2622000.0
2017-09-21	AAON	Stock	22.3667	22.4667	22.1333	22.2333	202200.0
2017-09-21	AAP	Stock	94.75	94.97	93.19	93.68	1597300.0
2017-09-21	AAT	Stock	39.98	40.34	39.94	39.94	155200.0
2017-09-21	AAU-DELISTED	Stock	1.14	1.18	1.131	1.15	149065.0
2017-09-21	AAUAF-DELISTED	Stock	1.14	1.18	1.131	1.15	155595.0
2017-09-21	AAV-DELISTED	Stock	6.55	6.65	6.5	6.6	54207.0
2017-09-21	AAWW-DELISTED	Stock	68.15	68.7	67.25	67.45	91621.0
2017-09-21	AAXJ	Stock	73.71	73.72	73.27	73.47	468671.0
2017-09-21	AAXN-DELISTED	Stock	22.91	23.1199	22.7	22.79	409189.0
2017-09-21	AB	Stock	24.15	24.2	23.85	23.95	127700.0
2017-09-21	ABAC-DELISTED	Stock	2.34	2.34	2.12	2.3	4200.0
2017-09-21	ABAX-DELISTED	Stock	44.86	44.86	44.35	44.41	63080.0
2017-09-21	ABB-DELISTED	Stock	24.6	24.715	24.57	24.63	469659.0
2017-09-21	ABBNY-DELISTED	Stock	24.6	24.715	24.57	24.63	502996.0
2017-09-21	ABBV	Stock	87.36	87.7	86.67	87.41	7340300.0
2017-09-21	ABC-DELISTED	Stock	79.49	80.94	79.2	80.39	850631.0
2017-09-21	ABCB	Stock	45.05	45.95	45.05	45.8	183900.0
2017-09-21	ABCD-DELISTED	Stock	6.11	6.25	6.11	6.23	20131.0
2017-09-21	ABCO-DELISTED	Stock	53.35	53.425	53.3	53.3	609561.0
2017-09-21	ABDC-DELISTED	Stock	10.95	10.97	10.82	10.88	51359.0
2017-09-21	ABE-DELISTED	Stock	14.2	14.3	14.2	14.3	4517.0
2017-09-21	ABEO	Stock	412.5	426.25	403.75	405.0	36896.0
2017-09-21	ABEOW-DELISTED	Stock	12.8	12.8	11.7501	11.79	2250.0
2017-09-21	ABEV	Stock	6.85	6.86	6.72	6.74	19374900.0
2017-09-21	ABG	Stock	58.95	59.05	58.4	58.4	164000.0
2017-09-21	ABIL-DELISTED	Stock	0.79	0.7901	0.7483	0.7901	24716.0
2017-09-21	ABM	Stock	39.44	39.44	38.92	38.93	355600.0

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

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