PREVIEW / stock_daily / 2019-10-09

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-09.parquet
  size:    218 KB
  rows:    6,530
  symbols: 2,449

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-10-09	AAPL	Stock	56.7575	56.9475	56.41	56.7575	74770400.0
2019-10-09	MSFT	Stock	137.46	138.7	136.97	138.24	19749900.0
2019-10-09	NVDA	Stock	4.508	4.5675	4.479	4.5178	292412000.0
2019-10-09	AMZN	Stock	85.9805	86.4975	85.718	86.0995	40870000.0
2019-10-09	GOOGL	Stock	60.0665	60.423	59.9058	60.12	16264320.0
2019-10-09	META	Stock	179.16	180.72	177.94	179.85	7556900.0
2019-10-09	TSLA	Stock	16.088	16.4867	16.0433	16.302	103416000.0
2019-10-09	TLT	Stock	144.6	144.61	143.8	144.35	8933140.0
2019-10-09	ES	Stock	84.93	86.26	84.93	86.09	1818800.0
2019-10-09	CL	Stock	70.88	71.12	70.08	70.63	1844200.0
2019-10-09	A	Stock	73.05	73.84	72.64	73.47	1499700.0
2019-10-09	AA	Stock	18.75	18.82	18.186	18.41	3000400.0
2019-10-09	AAC-DELISTED	Stock	0.5514	0.5775	0.5	0.5017	298501.0
2019-10-09	AACG	Stock	1.62	1.68	1.5	1.5	15000.0
2019-10-09	AAIC-DELISTED	Stock	5.32	5.37	5.285	5.34	245956.0
2019-10-09	AAIC.C-DELISTED	Stock	20.98	21.03	20.69	20.75	6940.0
2019-10-09	AAL	Stock	26.78	27.33	26.69	27.07	8095500.0
2019-10-09	AAM.A-DELISTED	Stock	26.51	26.69	26.51	26.62	19105.0
2019-10-09	AAM.B-DELISTED	Stock	26.85	27.11	26.8425	27.07	17366.0
2019-10-09	AAMC-DELISTED	Stock	3.4412	3.7059	3.4412	3.7059	19961.0
2019-10-09	AAME	Stock	2.52	2.52	2.52	2.52	100.0
2019-10-09	AAMI	Stock	9.16	9.23	9.055	9.08	732500.0
2019-10-09	AAOI	Stock	10.24	10.52	10.21	10.39	198600.0
2019-10-09	AAON	Stock	30.1467	30.4733	30.0667	30.08	177000.0
2019-10-09	AAP	Stock	154.61	155.38	153.25	154.41	641600.0
2019-10-09	AAT	Stock	46.74	46.85	46.35	46.42	161500.0
2019-10-09	AAU-DELISTED	Stock	0.75	0.75	0.7248	0.736	101823.0
2019-10-09	AAUAF-DELISTED	Stock	0.75	0.75	0.7248	0.736	105103.0
2019-10-09	AAWW-DELISTED	Stock	21.13	21.35	20.61	21.21	485117.0
2019-10-09	AAXJ	Stock	66.1	66.35	65.995	66.08	1817974.0
2019-10-09	AAXN-DELISTED	Stock	53.13	53.33	52.12	52.35	430320.0
2019-10-09	AB	Stock	28.52	28.7	28.25	28.57	133300.0
2019-10-09	ABB-DELISTED	Stock	18.06	18.08	17.93	18.01	1681733.0
2019-10-09	ABBNY-DELISTED	Stock	18.06	18.08	17.93	18.01	1904291.0
2019-10-09	ABBV	Stock	74.07	74.62	73.25	73.3	5851000.0
2019-10-09	ABC-DELISTED	Stock	80.83	81.18	80.29	80.38	474045.0
2019-10-09	ABCB	Stock	38.95	39.04	38.34	38.86	271100.0
2019-10-09	ABDC-DELISTED	Stock	8.85	8.86	8.8	8.81	16934.0
2019-10-09	ABEO	Stock	57.5	59.5	55.0	55.25	8012.0
2019-10-09	ABEV	Stock	4.54	4.6	4.54	4.56	14752100.0
2019-10-09	ABG	Stock	95.7	98.57	95.64	97.19	122300.0
2019-10-09	ABIL-DELISTED	Stock	0.4739	0.49	0.4558	0.4796	40946.0
2019-10-09	ABM	Stock	34.59	34.77	34.21	34.38	254300.0
2019-10-09	ABMD-DELISTED	Stock	160.1	161.15	157.47	159.32	637698.0
2019-10-09	ABR	Stock	13.14	13.18	13.09	13.1	1016100.0
2019-10-09	ABR.A-DELISTED	Stock	26.11	26.1675	26.1	26.1675	1000.0
2019-10-09	ABR.B-DELISTED	Stock	26.16	26.25	25.95	26.25	1099.0
2019-10-09	ABR.C-DELISTED	Stock	26.3	26.3	26.3	26.3	100.0
2019-10-09	ABT	Stock	79.31	79.81	78.88	79.5	4008500.0
2019-10-09	ABTC	Stock	180600.0	181500.0	172200.0	172200.0	1.2666666666666666

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

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