PREVIEW / stock_daily / 2018-03-07

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-07.parquet
  size:    216 KB
  rows:    6,474
  symbols: 2,832

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
2018-03-07	AAPL	Stock	43.735	43.9625	43.5675	43.7575	126814000.0
2018-03-07	MSFT	Stock	93.16	93.94	92.43	93.86	26716100.0
2018-03-07	NVDA	Stock	5.95	6.0988	5.9488	6.046	581208000.0
2018-03-07	AMZN	Stock	76.326	77.295	76.1255	77.25	83482000.0
2018-03-07	GOOGL	Stock	54.641	55.81	54.4955	55.752	30748580.0
2018-03-07	META	Stock	178.74	183.82	178.07	183.71	19097300.0
2018-03-07	TSLA	Stock	21.696	22.1667	21.4493	22.1533	75109500.0
2018-03-07	TLT	Stock	118.57	118.68	117.955	118.01	4461757.0
2018-03-07	ES	Stock	56.65	57.06	56.13	56.29	2226900.0
2018-03-07	CL	Stock	69.08	69.9	69.01	69.68	3303300.0
2018-03-07	A	Stock	67.36	69.86	67.3	69.7	3125800.0
2018-03-07	AA	Stock	46.6	48.26	46.401	47.88	3654700.0
2018-03-07	AABA-DELISTED	Stock	74.03	76.05	74.02	75.95	4413040.0
2018-03-07	AAC-DELISTED	Stock	10.02	11.11	10.0	10.95	184606.0
2018-03-07	AAIC-DELISTED	Stock	11.29	11.55	11.29	11.52	529887.0
2018-03-07	AAL	Stock	53.12	54.17	53.04	54.11	3216900.0
2018-03-07	AAM.A-DELISTED	Stock	25.65	25.73	25.55	25.73	32277.0
2018-03-07	AAMC-DELISTED	Stock	19.6029	19.6324	19.5588	19.6324	4162.0
2018-03-07	AAME	Stock	3.5	3.5	3.35	3.35	2100.0
2018-03-07	AAMI	Stock	15.09	15.39	15.0	15.36	894300.0
2018-03-07	AAOI	Stock	27.18	27.44	26.28	26.78	1542700.0
2018-03-07	AAON	Stock	23.8333	24.3	23.8	24.2333	193950.0
2018-03-07	AAP	Stock	117.43	118.31	115.8	116.77	708600.0
2018-03-07	AAT	Stock	32.15	32.46	32.04	32.32	364200.0
2018-03-07	AAU-DELISTED	Stock	0.8799	0.89	0.8626	0.8725	275678.0
2018-03-07	AAUAF-DELISTED	Stock	0.8799	0.89	0.8626	0.8725	279628.0
2018-03-07	AAV-DELISTED	Stock	3.0	3.0	2.75	2.825	739712.0
2018-03-07	AAWW-DELISTED	Stock	60.4	61.05	60.0	60.55	134502.0
2018-03-07	AAXJ	Stock	76.93	77.565	76.66	77.53	566360.0
2018-03-07	AAXN-DELISTED	Stock	38.97	40.24	38.7	39.77	1171535.0
2018-03-07	AB	Stock	26.85	27.35	26.75	27.0	311400.0
2018-03-07	ABAC-DELISTED	Stock	2.4982	2.5	2.49	2.5	3811.0
2018-03-07	ABAX-DELISTED	Stock	70.59	71.46	66.44	71.44	70898.0
2018-03-07	ABB-DELISTED	Stock	24.06	24.22	23.96	24.19	1655946.0
2018-03-07	ABBNY-DELISTED	Stock	24.06	24.22	23.96	24.19	1924684.0
2018-03-07	ABBV	Stock	112.58	114.99	112.21	114.72	5286200.0
2018-03-07	ABC-DELISTED	Stock	93.78	95.89	93.12	95.59	884263.0
2018-03-07	ABCB	Stock	56.1	57.25	56.1	57.05	316800.0
2018-03-07	ABCD-DELISTED	Stock	6.95	8.54	6.95	8.36	575078.0
2018-03-07	ABDC-DELISTED	Stock	7.66	7.77	7.52	7.73	32600.0
2018-03-07	ABE-DELISTED	Stock	15.1	15.14	15.1	15.14	300.0
2018-03-07	ABEO	Stock	387.5	400.5	382.5	393.75	47804.0
2018-03-07	ABEOW-DELISTED	Stock	11.37	11.37	10.75	10.95	900.0
2018-03-07	ABEV	Stock	7.03	7.1	6.95	7.06	34211100.0
2018-03-07	ABG	Stock	67.75	68.3	66.95	67.95	117700.0
2018-03-07	ABIL-DELISTED	Stock	0.4081	0.4179	0.3725	0.4	154131.0
2018-03-07	ABLX-DELISTED	Stock	54.59	54.68	54.33	54.56	33459.0
2018-03-07	ABM	Stock	34.47	36.93	34.47	36.29	1117200.0
2018-03-07	ABMD-DELISTED	Stock	277.38	288.8424	277.121	285.445	363441.0
2018-03-07	ABR	Stock	8.48	8.59	8.46	8.5	2056900.0

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

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