PREVIEW / stock_daily / 2019-08-13

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-13.parquet
  size:    221 KB
  rows:    6,631
  symbols: 2,538

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-13	AAPL	Stock	50.255	53.035	50.12	52.2425	188874000.0
2019-08-13	MSFT	Stock	136.05	138.8	135.0	138.6	25154600.0
2019-08-13	NVDA	Stock	3.7848	3.9475	3.7455	3.9013	351956000.0
2019-08-13	AMZN	Stock	89.15	91.587	89.0	91.217	79880000.0
2019-08-13	GOOGL	Stock	58.7175	60.2715	58.6498	59.8365	28604800.0
2019-08-13	META	Stock	185.52	191.38	185.37	188.45	13577000.0
2019-08-13	TSLA	Stock	15.254	15.7333	15.17	15.6667	72721500.0
2019-08-13	TLT	Stock	143.81	143.9116	141.95	142.48	16099485.0
2019-08-13	ES	Stock	77.57	78.18	77.21	77.91	1393300.0
2019-08-13	CL	Stock	70.87	71.95	70.66	71.69	2513600.0
2019-08-13	A	Stock	66.91	68.78	66.5	67.64	3164300.0
2019-08-13	AA	Stock	18.5	19.52	18.33	19.11	4426600.0
2019-08-13	AABA-DELISTED	Stock	69.95	70.26	69.95	70.14	4250551.0
2019-08-13	AAC-DELISTED	Stock	0.77	0.85	0.77	0.81	50465.0
2019-08-13	AACG	Stock	2.25	2.25	2.03	2.11	63600.0
2019-08-13	AAIC-DELISTED	Stock	5.77	5.87	5.76	5.77	329279.0
2019-08-13	AAIC.C-DELISTED	Stock	22.55	22.6139	22.4535	22.6139	1824.0
2019-08-13	AAL	Stock	27.62	28.37	27.33	27.51	12950000.0
2019-08-13	AAM.A-DELISTED	Stock	26.24	26.47	26.2118	26.45	22691.0
2019-08-13	AAM.B-DELISTED	Stock	26.67	26.75	26.64	26.75	15792.0
2019-08-13	AAMC-DELISTED	Stock	3.1882	3.3382	3.1882	3.3382	2972.0
2019-08-13	AAME	Stock	2.47	2.49	2.45	2.45	1400.0
2019-08-13	AAMI	Stock	8.75	9.08	8.74	8.92	448800.0
2019-08-13	AAOI	Stock	9.74	10.19	9.7	9.85	347600.0
2019-08-13	AAON	Stock	29.08	30.08	29.08	29.9667	125700.0
2019-08-13	AAP	Stock	130.8	144.06	130.09	142.23	5903800.0
2019-08-13	AAT	Stock	46.68	47.06	46.6	46.9	117300.0
2019-08-13	AAU-DELISTED	Stock	0.78	0.7999	0.75	0.754	238411.0
2019-08-13	AAUAF-DELISTED	Stock	0.78	0.7999	0.75	0.754	263418.0
2019-08-13	AAWW-DELISTED	Stock	27.63	29.63	27.38	28.45	280739.0
2019-08-13	AAXJ	Stock	63.12	64.84	63.06	64.48	1285301.0
2019-08-13	AAXN-DELISTED	Stock	57.57	60.62	57.21	58.76	601974.0
2019-08-13	AB	Stock	26.94	27.51	26.88	27.43	280100.0
2019-08-13	ABB-DELISTED	Stock	18.59	18.98	18.56	18.77	2711788.0
2019-08-13	ABBNY-DELISTED	Stock	18.59	18.98	18.56	18.77	3165187.0
2019-08-13	ABBV	Stock	64.86	65.93	64.64	65.01	7082500.0
2019-08-13	ABC-DELISTED	Stock	87.61	89.96	86.95	89.26	1119512.0
2019-08-13	ABCB	Stock	36.41	37.51	36.41	36.98	249300.0
2019-08-13	ABDC-DELISTED	Stock	9.27	9.4	8.5	9.24	697004.0
2019-08-13	ABEO	Stock	57.0	61.25	53.5	59.75	31440.0
2019-08-13	ABEV	Stock	4.83	4.94	4.81	4.87	25557000.0
2019-08-13	ABG	Stock	91.11	94.86	91.11	92.45	160100.0
2019-08-13	ABIL-DELISTED	Stock	0.62	0.6779	0.6136	0.67	31013.0
2019-08-13	ABM	Stock	39.65	41.01	39.65	39.91	233300.0
2019-08-13	ABMD-DELISTED	Stock	189.36	198.07	189.32	197.24	463241.0
2019-08-13	ABR	Stock	12.65	12.71	12.61	12.64	1045100.0
2019-08-13	ABR.A-DELISTED	Stock	26.4	26.4	26.3	26.4	6967.0
2019-08-13	ABR.B-DELISTED	Stock	25.93	26.0	25.8619	26.0	5710.0
2019-08-13	ABR.C-DELISTED	Stock	26.8644	26.89	26.46	26.46	2150.0
2019-08-13	ABT	Stock	85.32	87.1	84.98	86.89	4808300.0

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

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