PREVIEW / stock_daily / 2019-08-23

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-23.parquet
  size:    219 KB
  rows:    6,554
  symbols: 2,505

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-08-23	AAPL	Stock	52.3575	53.0125	50.25	50.66	187272000.0
2019-08-23	MSFT	Stock	137.19	138.35	132.8	133.39	38508600.0
2019-08-23	NVDA	Stock	4.21	4.2648	4.041	4.061	568056000.0
2019-08-23	AMZN	Stock	89.6515	90.245	87.2615	87.481	105416000.0
2019-08-23	GOOGL	Stock	59.2585	59.7835	57.5	57.679	36262820.0
2019-08-23	META	Stock	180.84	183.13	176.66	177.75	17323400.0
2019-08-23	TSLA	Stock	14.6647	14.7447	14.0667	14.0933	128079000.0
2019-08-23	TLT	Stock	143.52	146.27	143.43	145.96	16194116.0
2019-08-23	ES	Stock	80.03	80.17	78.85	79.17	1708600.0
2019-08-23	CL	Stock	73.11	73.88	71.81	72.23	3910900.0
2019-08-23	A	Stock	71.5	71.67	69.25	69.55	2990000.0
2019-08-23	AA	Stock	17.83	18.0	17.31	17.48	3217300.0
2019-08-23	AABA-DELISTED	Stock	69.47	69.58	69.39	69.52	4230006.0
2019-08-23	AAC-DELISTED	Stock	0.6	0.62	0.563	0.5829	179013.0
2019-08-23	AACG	Stock	1.88	1.99	1.88	1.88	13700.0
2019-08-23	AAIC-DELISTED	Stock	5.26	5.31	5.17	5.2	610978.0
2019-08-23	AAIC.C-DELISTED	Stock	21.9626	22.53	21.9626	22.53	4224.0
2019-08-23	AAL	Stock	26.27	26.51	25.35	25.42	8900100.0
2019-08-23	AAM.A-DELISTED	Stock	26.72	26.825	26.68	26.7	15931.0
2019-08-23	AAM.B-DELISTED	Stock	26.8528	26.9136	26.75	26.75	6802.0
2019-08-23	AAME	Stock	2.69	2.8	2.59	2.8	3500.0
2019-08-23	AAMI	Stock	9.15	9.36	8.86	8.91	317300.0
2019-08-23	AAOI	Stock	9.31	9.312	8.79	9.12	664200.0
2019-08-23	AAON	Stock	31.28	31.54	30.22	30.3867	163350.0
2019-08-23	AAP	Stock	136.57	138.19	134.45	135.05	1088000.0
2019-08-23	AAT	Stock	47.19	47.48	46.24	46.37	218800.0
2019-08-23	AAU-DELISTED	Stock	0.78	0.7843	0.755	0.7648	228115.0
2019-08-23	AAUAF-DELISTED	Stock	0.78	0.7843	0.755	0.7648	231194.0
2019-08-23	AAWW-DELISTED	Stock	26.35	26.72	25.34	25.76	590825.0
2019-08-23	AAXJ	Stock	64.59	65.12	63.72	63.77	1798006.0
2019-08-23	AAXN-DELISTED	Stock	62.15	62.69	59.14	59.37	742619.0
2019-08-23	AB	Stock	28.33	28.83	27.63	27.71	234100.0
2019-08-23	ABB-DELISTED	Stock	18.6	18.745	18.37	18.42	1497549.0
2019-08-23	ABBNY-DELISTED	Stock	18.6	18.745	18.37	18.42	1587841.0
2019-08-23	ABBV	Stock	67.28	67.79	65.48	65.97	8904700.0
2019-08-23	ABC-DELISTED	Stock	85.46	86.4	83.095	83.55	868541.0
2019-08-23	ABCB	Stock	36.38	36.95	34.86	35.0	388800.0
2019-08-23	ABDC-DELISTED	Stock	8.81	8.9	8.81	8.84	42771.0
2019-08-23	ABEO	Stock	50.75	52.0	45.5	45.75	19528.0
2019-08-23	ABEV	Stock	4.56	4.58	4.38	4.42	40148200.0
2019-08-23	ABG	Stock	90.73	91.82	88.35	88.74	103400.0
2019-08-23	ABIL-DELISTED	Stock	0.6601	0.72	0.6105	0.6509	55200.0
2019-08-23	ABM	Stock	38.22	38.47	36.72	36.84	259700.0
2019-08-23	ABMD-DELISTED	Stock	194.6	195.65	188.675	189.55	327226.0
2019-08-23	ABR	Stock	12.58	12.62	12.46	12.48	754200.0
2019-08-23	ABR.A-DELISTED	Stock	25.9	25.975	25.9	25.9354	2700.0
2019-08-23	ABR.B-DELISTED	Stock	25.7103	25.713	25.7103	25.713	3316.0
2019-08-23	ABR.C-DELISTED	Stock	26.3	26.3087	26.25	26.2885	420.0
2019-08-23	ABT	Stock	83.84	84.25	81.36	81.93	6228400.0
2019-08-23	ABTC	Stock	262500.0	275100.0	259500.0	261000.0	1.2133333333333334

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

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