PREVIEW / stock_daily / 2019-10-16

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-16.parquet
  size:    220 KB
  rows:    6,605
  symbols: 2,486

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-16	AAPL	Stock	58.3425	58.81	58.3	58.5925	73903200.0
2019-10-16	MSFT	Stock	140.79	140.99	139.53	140.41	20751600.0
2019-10-16	NVDA	Stock	4.875	4.9805	4.8438	4.8553	428944000.0
2019-10-16	AMZN	Stock	88.6665	89.312	88.526	88.8715	55268000.0
2019-10-16	GOOGL	Stock	62.0905	62.7095	61.9265	62.15	23020560.0
2019-10-16	META	Stock	188.32	189.7	186.9	189.55	10516900.0
2019-10-16	TSLA	Stock	17.1593	17.4733	17.128	17.3167	100261500.0
2019-10-16	TLT	Stock	139.64	140.06	139.35	139.92	8645282.0
2019-10-16	ES	Stock	83.97	84.7	83.57	84.58	1474300.0
2019-10-16	CL	Stock	68.38	68.38	67.37	67.85	4436000.0
2019-10-16	A	Stock	75.3	75.88	74.96	75.27	2275500.0
2019-10-16	AA	Stock	19.25	19.96	19.16	19.16	7168000.0
2019-10-16	AAC-DELISTED	Stock	0.3671	0.3885	0.35	0.361	1016154.0
2019-10-16	AACG	Stock	1.9	1.9	1.75	1.83	16500.0
2019-10-16	AAIC-DELISTED	Stock	5.46	5.53	5.44	5.5	131756.0
2019-10-16	AAIC.C-DELISTED	Stock	21.25	21.3721	21.25	21.3	6174.0
2019-10-16	AAL	Stock	28.33	28.81	28.03	28.05	6353300.0
2019-10-16	AAM.A-DELISTED	Stock	26.62	26.69	26.54	26.64	20390.0
2019-10-16	AAM.B-DELISTED	Stock	27.19	27.3	27.06	27.15	49288.0
2019-10-16	AAMC-DELISTED	Stock	3.7706	3.8529	3.7706	3.8294	7075.0
2019-10-16	AAME	Stock	2.3	2.47	2.28	2.47	3600.0
2019-10-16	AAMI	Stock	9.43	9.55	9.42	9.48	450900.0
2019-10-16	AAOI	Stock	10.84	11.33	10.78	10.84	484200.0
2019-10-16	AAON	Stock	31.2533	31.5867	30.9933	31.42	164700.0
2019-10-16	AAP	Stock	159.21	164.34	159.2	162.75	870600.0
2019-10-16	AAT	Stock	47.54	47.59	47.23	47.52	224800.0
2019-10-16	AAU-DELISTED	Stock	0.67	0.6747	0.66	0.66	155007.0
2019-10-16	AAUAF-DELISTED	Stock	0.67	0.6747	0.66	0.66	158994.0
2019-10-16	AAWW-DELISTED	Stock	22.38	22.91	22.185	22.24	398751.0
2019-10-16	AAXJ	Stock	68.25	68.49	68.125	68.33	607264.0
2019-10-16	AAXN-DELISTED	Stock	52.94	53.14	51.51	51.89	515123.0
2019-10-16	AB	Stock	27.92	28.22	27.78	27.78	231400.0
2019-10-16	ABB-DELISTED	Stock	18.83	18.91	18.805	18.85	1024122.0
2019-10-16	ABBNY-DELISTED	Stock	18.83	18.91	18.805	18.86	1077438.0
2019-10-16	ABBV	Stock	74.38	74.98	74.34	74.75	8288300.0
2019-10-16	ABC-DELISTED	Stock	84.11	88.69	84.02	86.05	2281415.0
2019-10-16	ABCB	Stock	41.04	41.4	40.67	40.96	269300.0
2019-10-16	ABDC-DELISTED	Stock	8.88	8.97	8.84	8.97	30573.0
2019-10-16	ABEO	Stock	68.0	70.5	60.5	61.0	45236.0
2019-10-16	ABEV	Stock	4.51	4.55	4.49	4.52	16441200.0
2019-10-16	ABG	Stock	99.58	101.33	99.25	100.25	89500.0
2019-10-16	ABIL-DELISTED	Stock	0.473	0.58	0.4518	0.5086	176067.0
2019-10-16	ABM	Stock	36.52	36.93	36.39	36.79	271200.0
2019-10-16	ABMD-DELISTED	Stock	177.27	180.19	175.67	178.68	297997.0
2019-10-16	ABR	Stock	13.28	13.3	13.19	13.27	1285200.0
2019-10-16	ABR.A-DELISTED	Stock	26.21	26.21	26.007	26.007	700.0
2019-10-16	ABR.C-DELISTED	Stock	26.32	26.3935	26.3055	26.3935	700.0
2019-10-16	ABT	Stock	81.36	83.69	79.65	81.78	10707400.0
2019-10-16	ABTC	Stock	170100.0	179400.0	164700.0	165900.0	1.1066666666666667
2019-10-16	ABTS	Stock	27.0	27.15	25.95	27.0	253.0

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

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