PREVIEW / stock_daily / 2018-08-29

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-29.parquet
  size:    218 KB
  rows:    6,515
  symbols: 2,754

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-08-29	AAPL	Stock	55.0375	55.8725	54.8525	55.745	109019200.0
2018-08-29	MSFT	Stock	110.45	112.03	110.27	112.02	20818000.0
2018-08-29	NVDA	Stock	6.848	6.9875	6.827	6.9623	420108000.0
2018-08-29	AMZN	Stock	97.6725	99.9345	97.447	99.905	130636000.0
2018-08-29	GOOGL	Stock	62.75	63.3585	62.64	63.2325	36932300.0
2018-08-29	META	Stock	176.3	176.79	174.75	175.9	18494100.0
2018-08-29	TSLA	Stock	20.6847	20.79	20.246	20.334	111711000.0
2018-08-29	TLT	Stock	120.94	121.145	120.615	121.02	5613329.0
2018-08-29	ES	Stock	62.1	62.22	61.75	62.18	847600.0
2018-08-29	CL	Stock	66.87	67.25	66.85	66.96	2322000.0
2018-08-29	A	Stock	66.69	67.28	66.4	67.01	1852100.0
2018-08-29	AA	Stock	44.12	45.47	44.04	45.13	2549000.0
2018-08-29	AABA-DELISTED	Stock	70.32	70.615	69.87	70.47	2228453.0
2018-08-29	AAC-DELISTED	Stock	9.35	9.49	8.94	9.03	158317.0
2018-08-29	AACG	Stock	2.62	3.09	2.28	2.42	2632600.0
2018-08-29	AAIC-DELISTED	Stock	10.14	10.2	10.12	10.18	263553.0
2018-08-29	AAL	Stock	40.66	41.04	40.25	40.5	4475100.0
2018-08-29	AAM.A-DELISTED	Stock	25.861	26.0	25.861	25.96	18735.0
2018-08-29	AAM.B-DELISTED	Stock	25.4	25.55	25.4	25.47	46120.0
2018-08-29	AAME	Stock	2.4	2.45	2.35	2.45	5800.0
2018-08-29	AAMI	Stock	12.75	12.99	12.62	12.94	725400.0
2018-08-29	AAOI	Stock	42.95	43.95	42.31	42.39	1455000.0
2018-08-29	AAON	Stock	27.0667	27.5333	26.9667	27.2333	139200.0
2018-08-29	AAP	Stock	162.34	164.23	161.13	163.56	765000.0
2018-08-29	AAT	Stock	39.46	39.51	39.23	39.3	135700.0
2018-08-29	AAU-DELISTED	Stock	0.647	0.6521	0.6314	0.645	83732.0
2018-08-29	AAUAF-DELISTED	Stock	0.647	0.6521	0.6314	0.645	88521.0
2018-08-29	AAV-DELISTED	Stock	3.15	3.195	3.05	3.15	61587.0
2018-08-29	AAWW-DELISTED	Stock	62.25	62.45	61.95	62.0417	244075.0
2018-08-29	AAXJ	Stock	72.25	72.8	72.13	72.74	815697.0
2018-08-29	AAXN-DELISTED	Stock	67.5	67.6	66.66	67.08	272776.0
2018-08-29	AB	Stock	30.05	30.3	29.7	30.2	306500.0
2018-08-29	ABAC-DELISTED	Stock	1.8008	1.8008	1.8008	1.8008	100.0
2018-08-29	ABB-DELISTED	Stock	23.89	23.96	23.81	23.88	2055069.0
2018-08-29	ABBNY-DELISTED	Stock	23.88	23.96	23.81	23.88	2749329.0
2018-08-29	ABBV	Stock	97.43	97.83	96.03	97.58	3637100.0
2018-08-29	ABC-DELISTED	Stock	88.67	89.43	87.78	89.27	657433.0
2018-08-29	ABCB	Stock	49.9	49.95	49.25	49.5	175600.0
2018-08-29	ABCD-DELISTED	Stock	13.79	13.86	13.65	13.74	69176.0
2018-08-29	ABDC-DELISTED	Stock	6.09	6.1	6.02	6.1	48631.0
2018-08-29	ABEO	Stock	375.0	388.75	372.5	383.75	22660.0
2018-08-29	ABEOW-DELISTED	Stock	10.5	10.5	10.5	10.5	400.0
2018-08-29	ABEV	Stock	4.64	4.73	4.63	4.7	21528500.0
2018-08-29	ABG	Stock	75.9	76.3	74.85	76.05	101700.0
2018-08-29	ABIL-DELISTED	Stock	4.0	4.09	3.61	3.9775	235973.0
2018-08-29	ABM	Stock	31.09	31.65	30.99	31.58	372400.0
2018-08-29	ABMD-DELISTED	Stock	388.23	402.96	387.95	402.03	455454.0
2018-08-29	ABR	Stock	12.06	12.09	12.0	12.04	758800.0
2018-08-29	ABR.A-DELISTED	Stock	26.05	26.05	25.82	25.86	1985.0
2018-08-29	ABR.B-DELISTED	Stock	25.48	25.48	25.4	25.4577	3600.0

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

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