PREVIEW / stock_daily / 2019-08-20

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-20.parquet
  size:    219 KB
  rows:    6,558
  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-08-20	AAPL	Stock	52.72	53.3375	52.58	52.59	107537200.0
2019-08-20	MSFT	Stock	138.21	138.71	137.24	137.26	21170800.0
2019-08-20	NVDA	Stock	4.264	4.2645	4.1755	4.1968	463188000.0
2019-08-20	AMZN	Stock	90.725	90.841	89.994	90.069	38590000.0
2019-08-20	GOOGL	Stock	59.7675	59.9	59.1523	59.1765	20211320.0
2019-08-20	META	Stock	185.45	186.0	182.39	183.81	10083400.0
2019-08-20	TSLA	Stock	15.1747	15.2727	14.9693	15.0573	61878000.0
2019-08-20	TLT	Stock	145.28	145.6225	144.84	145.53	7451608.0
2019-08-20	ES	Stock	79.24	79.32	78.67	79.1	1235100.0
2019-08-20	CL	Stock	72.96	73.28	72.43	72.54	2463700.0
2019-08-20	A	Stock	71.42	72.26	71.1	71.12	2171200.0
2019-08-20	AA	Stock	18.12	18.4	18.064	18.31	2954100.0
2019-08-20	AABA-DELISTED	Stock	69.7	69.79	69.44	69.6191	8668286.0
2019-08-20	AAC-DELISTED	Stock	0.6453	0.6697	0.6116	0.6231	106400.0
2019-08-20	AACG	Stock	2.01	2.01	1.8	1.83	145200.0
2019-08-20	AAIC-DELISTED	Stock	5.6	5.6	5.46	5.46	267392.0
2019-08-20	AAIC.C-DELISTED	Stock	22.2574	22.2574	22.2574	22.2574	100.0
2019-08-20	AAL	Stock	26.08	26.08	25.56	25.83	7658800.0
2019-08-20	AAM.A-DELISTED	Stock	26.6174	26.7	26.595	26.68	10462.0
2019-08-20	AAM.B-DELISTED	Stock	26.56	26.7	26.56	26.57	25448.0
2019-08-20	AAMC-DELISTED	Stock	2.6147	2.7941	2.6147	2.7882	4090.0
2019-08-20	AAME	Stock	2.4	2.5	2.36	2.43	13800.0
2019-08-20	AAMI	Stock	8.64	8.78	8.57	8.71	389000.0
2019-08-20	AAOI	Stock	9.52	9.72	9.34	9.67	228000.0
2019-08-20	AAON	Stock	31.6267	31.6333	31.1933	31.2267	151650.0
2019-08-20	AAP	Stock	136.44	137.85	135.3	135.38	997300.0
2019-08-20	AAT	Stock	47.44	47.44	46.8	46.9	223900.0
2019-08-20	AAU-DELISTED	Stock	0.74	0.75	0.7001	0.75	152706.0
2019-08-20	AAUAF-DELISTED	Stock	0.74	0.75	0.7001	0.75	157241.0
2019-08-20	AAWW-DELISTED	Stock	27.36	27.61	26.46	26.6	266665.0
2019-08-20	AAXJ	Stock	65.35	65.45	65.165	65.22	801914.0
2019-08-20	AAXN-DELISTED	Stock	60.27	60.97	59.35	60.78	864229.0
2019-08-20	AB	Stock	27.4	27.82	27.18	27.5	197300.0
2019-08-20	ABB-DELISTED	Stock	18.63	18.635	18.48	18.49	984792.0
2019-08-20	ABBNY-DELISTED	Stock	18.63	18.635	18.48	18.49	1043391.0
2019-08-20	ABBV	Stock	67.38	68.46	66.33	66.41	12037900.0
2019-08-20	ABC-DELISTED	Stock	88.04	88.6072	86.22	86.31	776191.0
2019-08-20	ABCB	Stock	36.55	36.82	36.3	36.6	211900.0
2019-08-20	ABDC-DELISTED	Stock	8.92	8.95	8.8212	8.9	128420.0
2019-08-20	ABEO	Stock	56.0	56.5	54.75	54.75	6528.0
2019-08-20	ABEOW-DELISTED	Stock	0.15	0.15	0.15	0.15	6086.0
2019-08-20	ABEV	Stock	4.65	4.73	4.64	4.66	17027500.0
2019-08-20	ABG	Stock	90.79	91.64	90.0	90.49	89400.0
2019-08-20	ABIL-DELISTED	Stock	0.64	0.64	0.6001	0.63	62779.0
2019-08-20	ABM	Stock	38.82	38.82	38.09	38.12	404000.0
2019-08-20	ABMD-DELISTED	Stock	192.97	200.43	192.17	192.65	327495.0
2019-08-20	ABR	Stock	12.32	12.32	12.17	12.23	604300.0
2019-08-20	ABR.B-DELISTED	Stock	25.65	25.75	25.65	25.69	2333.0
2019-08-20	ABR.C-DELISTED	Stock	26.18	26.18	26.18	26.18	1335.0
2019-08-20	ABT	Stock	85.95	86.01	84.48	84.54	3322400.0

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

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