PREVIEW / stock_daily / 2019-09-05

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-05.parquet
  size:    220 KB
  rows:    6,581
  symbols: 2,523

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-09-05	AAPL	Stock	53.0	53.4925	52.8775	53.32	95654800.0
2019-09-05	MSFT	Stock	139.11	140.38	138.76	140.05	26101800.0
2019-09-05	NVDA	Stock	4.3218	4.4998	4.32	4.4935	695676000.0
2019-09-05	AMZN	Stock	91.0975	92.1	90.779	92.036	66216000.0
2019-09-05	GOOGL	Stock	59.683	60.7	59.6345	60.6095	26413120.0
2019-09-05	META	Stock	188.53	191.36	187.94	190.9	13876700.0
2019-09-05	TSLA	Stock	14.8333	15.32	14.7233	15.3053	110929500.0
2019-09-05	TLT	Stock	145.66	145.8	143.89	144.76	19386357.0
2019-09-05	ES	Stock	82.0	82.23	80.97	82.03	2208400.0
2019-09-05	CL	Stock	75.0	75.0	74.09	74.29	3430900.0
2019-09-05	A	Stock	71.64	73.71	71.64	73.52	2997900.0
2019-09-05	AA	Stock	18.71	19.765	18.7	19.62	5547200.0
2019-09-05	AABA-DELISTED	Stock	69.57	69.7	69.51	69.65	5113367.0
2019-09-05	AAC-DELISTED	Stock	0.5613	0.62	0.5613	0.5705	76263.0
2019-09-05	AACG	Stock	1.88	1.97	1.88	1.93	9400.0
2019-09-05	AAIC-DELISTED	Stock	5.05	5.16	5.05	5.08	392087.0
2019-09-05	AAIC.C-DELISTED	Stock	21.83	22.1608	21.83	22.0	2655.0
2019-09-05	AAL	Stock	27.45	28.11	27.44	27.69	6254600.0
2019-09-05	AAM.A-DELISTED	Stock	26.52	26.55	26.36	26.37	84074.0
2019-09-05	AAM.B-DELISTED	Stock	26.72	26.74	26.3293	26.393	84024.0
2019-09-05	AAMC-DELISTED	Stock	3.1471	3.2221	3.1471	3.1471	6977.0
2019-09-05	AAMI	Stock	9.23	9.65	9.17	9.47	472400.0
2019-09-05	AAOI	Stock	9.26	9.82	9.26	9.79	687200.0
2019-09-05	AAON	Stock	32.12	33.1733	32.0133	32.28	210300.0
2019-09-05	AAP	Stock	143.08	147.12	143.07	146.55	770600.0
2019-09-05	AAT	Stock	47.67	47.89	47.26	47.53	471600.0
2019-09-05	AAU-DELISTED	Stock	0.72	0.7301	0.64	0.6701	702575.0
2019-09-05	AAUAF-DELISTED	Stock	0.72	0.7301	0.64	0.6701	719536.0
2019-09-05	AAWW-DELISTED	Stock	25.67	27.67	25.65	27.32	338094.0
2019-09-05	AAXJ	Stock	66.79	67.01	66.7	66.9	3438075.0
2019-09-05	AAXN-DELISTED	Stock	60.87	61.93	60.13	61.2	337624.0
2019-09-05	AB	Stock	28.87	29.2	28.81	29.05	187400.0
2019-09-05	ABB-DELISTED	Stock	19.31	19.37	19.27	19.33	1594870.0
2019-09-05	ABBNY-DELISTED	Stock	19.31	19.37	19.27	19.34	1654432.0
2019-09-05	ABBV	Stock	66.64	67.3	66.43	67.03	5602400.0
2019-09-05	ABC-DELISTED	Stock	86.29	87.17	85.7916	86.05	693560.0
2019-09-05	ABCB	Stock	34.71	35.62	34.58	35.22	341700.0
2019-09-05	ABDC-DELISTED	Stock	9.0	9.05	8.9509	8.97	26132.0
2019-09-05	ABEO	Stock	73.0	76.25	70.25	75.25	68336.0
2019-09-05	ABEOW-DELISTED	Stock	0.44	0.44	0.44	0.44	274.0
2019-09-05	ABEV	Stock	4.63	4.67	4.56	4.58	18406200.0
2019-09-05	ABG	Stock	96.61	99.48	96.61	97.63	100200.0
2019-09-05	ABIL-DELISTED	Stock	0.6134	0.64	0.6	0.6109	36711.0
2019-09-05	ABM	Stock	37.09	37.84	37.09	37.37	431600.0
2019-09-05	ABMD-DELISTED	Stock	185.07	191.02	182.82	190.37	263959.0
2019-09-05	ABR	Stock	12.6	12.61	12.49	12.56	515900.0
2019-09-05	ABR.A-DELISTED	Stock	25.99	26.1	25.97	26.0498	1114.0
2019-09-05	ABR.B-DELISTED	Stock	25.86	25.86	25.701	25.75	2082.0
2019-09-05	ABR.C-DELISTED	Stock	26.12	26.3	26.12	26.2614	450.0
2019-09-05	ABT	Stock	85.0	86.16	84.56	85.9	4356400.0

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

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