PREVIEW / stock_daily / 2019-11-27

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-27.parquet
  size:    219 KB
  rows:    6,554
  symbols: 2,433

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-11-27	AAPL	Stock	66.395	66.995	66.3275	66.96	65235600.0
2019-11-27	MSFT	Stock	152.33	152.5	151.52	152.32	15184400.0
2019-11-27	NVDA	Stock	5.4668	5.5013	5.4295	5.456	215784000.0
2019-11-27	AMZN	Stock	90.05	91.225	89.8655	90.9255	60512000.0
2019-11-27	GOOGL	Stock	65.771	65.882	65.4737	65.6065	18810720.0
2019-11-27	META	Stock	199.9	203.14	199.42	202.0	12736600.0
2019-11-27	TSLA	Stock	22.0747	22.262	21.9047	22.086	83334000.0
2019-11-27	TLT	Stock	140.6	140.91	140.42	140.72	4096955.0
2019-11-27	ES	Stock	82.94	83.04	82.55	82.9	2256300.0
2019-11-27	CL	Stock	67.79	67.89	67.22	67.68	2517600.0
2019-11-27	A	Stock	81.08	81.34	80.69	81.08	1628000.0
2019-11-27	AA	Stock	20.29	20.6	20.18	20.6	2292600.0
2019-11-27	AACG	Stock	1.8	1.85	1.8	1.8	10100.0
2019-11-27	AAIC-DELISTED	Stock	5.72	5.79	5.67	5.79	361046.0
2019-11-27	AAIC.C-DELISTED	Stock	21.99	22.055	21.99	22.0	5915.0
2019-11-27	AAL	Stock	29.07	29.33	28.74	28.95	3381800.0
2019-11-27	AAM.A-DELISTED	Stock	26.35	26.37	26.28	26.3	15617.0
2019-11-27	AAM.B-DELISTED	Stock	26.87	26.87	26.7	26.7	18390.0
2019-11-27	AAMC-DELISTED	Stock	4.0	4.0	4.0	4.0	1098.0
2019-11-27	AAME	Stock	1.63	2.0	1.63	2.0	800.0
2019-11-27	AAMI	Stock	9.52	9.61	9.35	9.4	421500.0
2019-11-27	AAOI	Stock	10.65	10.82	10.45	10.68	339300.0
2019-11-27	AAON	Stock	32.98	33.2933	32.8067	32.96	177900.0
2019-11-27	AAP	Stock	157.61	160.61	157.33	158.78	809700.0
2019-11-27	AAT	Stock	46.81	47.07	46.45	47.0	144900.0
2019-11-27	AAU-DELISTED	Stock	0.48	0.48	0.46	0.46	133623.0
2019-11-27	AAUAF-DELISTED	Stock	0.48	0.48	0.46	0.46	158622.0
2019-11-27	AAWW-DELISTED	Stock	26.42	26.82	26.245	26.58	177212.0
2019-11-27	AAXJ	Stock	70.75	70.97	70.64	70.88	419994.0
2019-11-27	AAXN-DELISTED	Stock	74.81	76.07	72.02	75.57	1191650.0
2019-11-27	AB	Stock	28.82	29.01	28.68	28.88	160900.0
2019-11-27	ABB-DELISTED	Stock	22.13	22.15	21.96	22.07	2196341.0
2019-11-27	ABBNY-DELISTED	Stock	22.13	22.15	21.96	22.07	2292834.0
2019-11-27	ABBV	Stock	87.86	88.81	87.61	88.33	4711800.0
2019-11-27	ABC-DELISTED	Stock	87.5	88.55	86.88	88.52	438561.0
2019-11-27	ABCB	Stock	43.53	43.95	43.5	43.68	135000.0
2019-11-27	ABDC-DELISTED	Stock	8.83	9.01	8.83	9.01	75328.0
2019-11-27	ABEO	Stock	73.75	87.75	73.75	85.0	46616.0
2019-11-27	ABEOW-DELISTED	Stock	0.2	0.2	0.2	0.2	2000.0
2019-11-27	ABEV	Stock	4.2	4.23	4.15	4.23	15623500.0
2019-11-27	ABG	Stock	112.04	113.01	111.45	112.52	182100.0
2019-11-27	ABIL-DELISTED	Stock	0.34	0.38	0.31	0.37	362083.0
2019-11-27	ABM	Stock	38.96	39.13	38.72	38.84	121400.0
2019-11-27	ABMD-DELISTED	Stock	194.97	202.87	194.2815	196.79	535946.0
2019-11-27	ABR	Stock	14.93	15.18	14.93	15.12	718500.0
2019-11-27	ABR.A-DELISTED	Stock	26.15	26.19	26.1	26.14	2726.0
2019-11-27	ABR.B-DELISTED	Stock	25.6826	25.744	25.6826	25.744	700.0
2019-11-27	ABR.C-DELISTED	Stock	26.1213	26.1394	26.0656	26.1394	796.0
2019-11-27	ABT	Stock	85.97	85.97	85.16	85.42	2865400.0
2019-11-27	ABTC	Stock	225000.0	249000.0	213000.0	224100.0	15.066666666666666

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

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