PREVIEW / stock_daily / 2019-07-30

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-30.parquet
  size:    221 KB
  rows:    6,605
  symbols: 2,536

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
2019-07-30	AAPL	Stock	52.19	52.54	51.8275	52.195	135742800.0
2019-07-30	MSFT	Stock	140.14	141.22	139.8	140.35	16846500.0
2019-07-30	NVDA	Stock	4.3237	4.3985	4.3093	4.3862	197772000.0
2019-07-30	AMZN	Stock	94.556	95.4945	94.174	94.9265	58218000.0
2019-07-30	GOOGL	Stock	61.35	61.8455	61.266	61.4	28615500.0
2019-07-30	META	Stock	195.39	198.71	193.5	197.04	11903600.0
2019-07-30	TSLA	Stock	15.5267	16.224	15.4787	16.1507	121635000.0
2019-07-30	TLT	Stock	132.0	132.1	131.43	131.83	5678475.0
2019-07-30	ES	Stock	76.45	77.26	76.17	76.53	1540100.0
2019-07-30	CL	Stock	75.51	76.41	74.42	74.74	5020600.0
2019-07-30	A	Stock	69.25	70.18	68.1	70.15	2871800.0
2019-07-30	AA	Stock	22.9	23.04	22.575	23.04	2865600.0
2019-07-30	AABA-DELISTED	Stock	70.44	70.915	70.44	70.66	1838691.0
2019-07-30	AAC-DELISTED	Stock	0.9715	1.0	0.9389	0.97	54928.0
2019-07-30	AACG	Stock	2.64	2.68	2.6	2.6	18500.0
2019-07-30	AAIC-DELISTED	Stock	6.66	6.715	6.6508	6.7	257230.0
2019-07-30	AAIC.C-DELISTED	Stock	23.2132	23.2547	23.2	23.2	1752.0
2019-07-30	AAL	Stock	30.45	30.81	30.21	30.71	5290200.0
2019-07-30	AAM.A-DELISTED	Stock	26.43	26.5	26.16	26.255	69756.0
2019-07-30	AAM.B-DELISTED	Stock	26.82	26.87	26.71	26.8	36834.0
2019-07-30	AAMC-DELISTED	Stock	3.0801	3.0801	2.7312	2.8088	32018.0
2019-07-30	AAME	Stock	2.41	2.48	2.35	2.36	3200.0
2019-07-30	AAMI	Stock	10.78	10.93	10.74	10.92	185700.0
2019-07-30	AAOI	Stock	9.21	9.53	8.98	9.48	611200.0
2019-07-30	AAON	Stock	33.4933	34.5067	33.3133	34.4067	232650.0
2019-07-30	AAP	Stock	152.52	154.66	150.91	151.8	872900.0
2019-07-30	AAT	Stock	46.88	47.39	46.88	46.94	466400.0
2019-07-30	AAU-DELISTED	Stock	0.76	0.76	0.7188	0.7563	118323.0
2019-07-30	AAUAF-DELISTED	Stock	0.76	0.76	0.7188	0.7563	127320.0
2019-07-30	AAWW-DELISTED	Stock	44.99	46.84	44.48	46.62	186096.0
2019-07-30	AAXJ	Stock	68.66	68.71	68.44	68.67	399265.0
2019-07-30	AAXN-DELISTED	Stock	68.0	69.66	67.51	69.66	454987.0
2019-07-30	AB	Stock	29.5	29.91	29.2	29.9	243300.0
2019-07-30	ABB-DELISTED	Stock	18.77	18.85	18.68	18.775	2516137.0
2019-07-30	ABBNY-DELISTED	Stock	18.77	18.85	18.68	18.78	2606985.0
2019-07-30	ABBV	Stock	66.92	67.53	66.26	67.18	8143700.0
2019-07-30	ABC-DELISTED	Stock	86.5	89.01	85.48	88.72	1046310.0
2019-07-30	ABCB	Stock	38.87	40.0	38.84	39.97	328000.0
2019-07-30	ABDC-DELISTED	Stock	8.34	8.34	8.28	8.31	11435.0
2019-07-30	ABEO	Stock	75.25	77.25	71.5	74.5	19556.0
2019-07-30	ABEV	Stock	5.42	5.45	5.31	5.32	28687700.0
2019-07-30	ABG	Stock	94.0	94.0	91.42	92.97	232200.0
2019-07-30	ABIL-DELISTED	Stock	0.799	0.799	0.629	0.7361	42348.0
2019-07-30	ABM	Stock	41.51	42.46	41.09	42.25	308800.0
2019-07-30	ABMD-DELISTED	Stock	273.87	279.52	273.61	279.18	261776.0
2019-07-30	ABR	Stock	12.2	12.35	12.16	12.31	631200.0
2019-07-30	ABR.A-DELISTED	Stock	26.2	26.4	26.1486	26.4	5169.0
2019-07-30	ABR.B-DELISTED	Stock	25.805	25.9	25.805	25.8999	1202.0
2019-07-30	ABR.C-DELISTED	Stock	26.55	26.687	26.4467	26.47	2584.0
2019-07-30	ABT	Stock	88.18	88.73	87.85	88.31	2864700.0

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

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