PREVIEW / stock_daily / 2019-11-15

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-15.parquet
  size:    222 KB
  rows:    6,613
  symbols: 2,466

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-15	AAPL	Stock	65.92	66.445	65.7525	66.44	100206400.0
2019-11-15	MSFT	Stock	148.93	149.99	148.27	149.97	23485700.0
2019-11-15	NVDA	Stock	5.2425	5.2945	5.016	5.1048	1053628000.0
2019-11-15	AMZN	Stock	88.0025	88.084	86.643	86.9745	78552000.0
2019-11-15	GOOGL	Stock	65.7525	66.677	65.5945	66.677	39299100.0
2019-11-15	META	Stock	194.26	195.3	193.38	195.1	11524300.0
2019-11-15	TSLA	Stock	23.376	23.52	23.224	23.478	72135000.0
2019-11-15	TLT	Stock	137.48	138.16	137.43	137.76	4657758.0
2019-11-15	ES	Stock	80.98	81.43	80.57	81.27	2237800.0
2019-11-15	CL	Stock	66.66	66.74	66.13	66.37	5146800.0
2019-11-15	A	Stock	76.93	78.31	76.61	78.26	1700400.0
2019-11-15	AA	Stock	21.0	21.25	20.435	20.89	3289100.0
2019-11-15	AACG	Stock	1.73	1.73	1.7	1.7	10000.0
2019-11-15	AAIC-DELISTED	Stock	5.7	5.73	5.64	5.67	287641.0
2019-11-15	AAIC.C-DELISTED	Stock	21.75	21.8704	21.75	21.8704	2388.0
2019-11-15	AAL	Stock	28.95	29.2	28.8	28.86	4552000.0
2019-11-15	AAM.A-DELISTED	Stock	26.49	26.55	26.47	26.546	8232.0
2019-11-15	AAM.B-DELISTED	Stock	26.8734	26.95	26.8324	26.86	11364.0
2019-11-15	AAMC-DELISTED	Stock	3.5294	3.5441	3.3824	3.4324	10486.0
2019-11-15	AAME	Stock	1.7	1.75	1.7	1.75	13200.0
2019-11-15	AAMI	Stock	9.52	9.55	9.39	9.48	825700.0
2019-11-15	AAOI	Stock	10.99	11.11	10.8	10.865	496500.0
2019-11-15	AAON	Stock	33.84	34.0467	33.3133	33.56	169800.0
2019-11-15	AAP	Stock	157.79	162.69	157.44	162.66	1084500.0
2019-11-15	AAT	Stock	47.01	47.23	46.59	47.23	293000.0
2019-11-15	AAU-DELISTED	Stock	0.54	0.5494	0.5	0.51	225988.0
2019-11-15	AAUAF-DELISTED	Stock	0.54	0.5494	0.5	0.51	235431.0
2019-11-15	AAWW-DELISTED	Stock	25.34	25.6119	25.11	25.21	164383.0
2019-11-15	AAXJ	Stock	70.09	70.25	70.01	70.1	449198.0
2019-11-15	AAXN-DELISTED	Stock	67.35	68.35	66.37	67.36	573479.0
2019-11-15	AB	Stock	29.85	29.99	29.55	29.7	186600.0
2019-11-15	ABB-DELISTED	Stock	22.1	22.21	22.08	22.205	1292541.0
2019-11-15	ABBNY-DELISTED	Stock	22.1	22.21	22.08	22.21	1358739.0
2019-11-15	ABBV	Stock	88.1	89.19	87.26	88.63	8036700.0
2019-11-15	ABC-DELISTED	Stock	86.0	87.74	85.45	87.3	894660.0
2019-11-15	ABCB	Stock	43.84	44.13	43.45	43.6	155700.0
2019-11-15	ABDC-DELISTED	Stock	9.03	9.03	8.8922	9.0	21122.0
2019-11-15	ABEO	Stock	57.0	60.0	55.75	58.0	7632.0
2019-11-15	ABEOW-DELISTED	Stock	0.1115	0.1116	0.1115	0.1116	8136.0
2019-11-15	ABEV	Stock	4.17	4.21	4.15	4.2	4338700.0
2019-11-15	ABG	Stock	110.18	110.83	109.47	110.0	103800.0
2019-11-15	ABIL-DELISTED	Stock	0.34	0.38	0.32	0.325	60800.0
2019-11-15	ABM	Stock	38.58	38.58	37.75	37.89	199100.0
2019-11-15	ABMD-DELISTED	Stock	221.82	224.36	220.0	223.32	197164.0
2019-11-15	ABR	Stock	15.1	15.12	14.93	15.04	1658300.0
2019-11-15	ABR.A-DELISTED	Stock	25.79	25.85	25.79	25.85	1400.0
2019-11-15	ABR.B-DELISTED	Stock	25.48	25.7	25.48	25.6	6990.0
2019-11-15	ABR.C-DELISTED	Stock	26.0731	26.64	26.07	26.2806	1500.0
2019-11-15	ABT	Stock	84.67	85.71	84.4	85.71	5453500.0
2019-11-15	ABTC	Stock	120000.0	205500.0	120000.0	178170.0	92.8

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

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