PREVIEW / stock_daily / 2020-03-19

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-19.parquet
  size:    211 KB
  rows:    6,658
  symbols: 2,403

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
2020-03-19	AAPL	Stock	61.8475	63.21	60.6525	61.195	271857200.0
2020-03-19	MSFT	Stock	142.77	150.15	139.0	142.71	85922700.0
2020-03-19	NVDA	Stock	5.049	5.4183	4.8348	5.3242	765512000.0
2020-03-19	AMZN	Stock	93.0	97.25	91.6325	94.0465	207998000.0
2020-03-19	GOOGL	Stock	54.411	57.6305	52.7775	55.5835	74064960.0
2020-03-19	META	Stock	146.62	159.93	144.8	153.13	39862300.0
2020-03-19	TSLA	Stock	24.98	30.1333	23.8973	28.5093	452932500.0
2020-03-19	TLT	Stock	146.95	153.45	145.25	148.28	21175266.0
2020-03-19	ES	Stock	86.72	86.72	75.46	77.05	3691500.0
2020-03-19	CL	Stock	67.98	68.99	65.06	66.65	8926800.0
2020-03-19	A	Stock	68.54	68.59	64.17	65.76	3430700.0
2020-03-19	AA	Stock	5.76	6.15	5.2	5.83	6174500.0
2020-03-19	AACG	Stock	0.72	0.76	0.7	0.74	7800.0
2020-03-19	AAIC-DELISTED	Stock	1.98	2.47	1.7	2.13	1318789.0
2020-03-19	AAIC.C-DELISTED	Stock	7.74	10.8087	7.5157	10.07	39893.0
2020-03-19	AAL	Stock	11.6	12.16	10.01	10.29	71584500.0
2020-03-19	AAM.A-DELISTED	Stock	16.76	18.9869	15.5	18.5	90472.0
2020-03-19	AAM.B-DELISTED	Stock	16.5	18.92	15.33	18.5	136593.0
2020-03-19	AAMC-DELISTED	Stock	3.1882	3.4765	3.1882	3.2706	12940.0
2020-03-19	AAME	Stock	2.44	2.44	2.4	2.4	300.0
2020-03-19	AAMI	Stock	3.7	4.725	3.62	4.43	970000.0
2020-03-19	AAOI	Stock	5.51	6.6	5.448	6.55	1028700.0
2020-03-19	AAON	Stock	31.7133	35.3333	30.6467	32.78	856500.0
2020-03-19	AAP	Stock	86.48	89.42	81.62	85.97	1185000.0
2020-03-19	AAT	Stock	21.56	23.03	20.15	22.53	656600.0
2020-03-19	AAU-DELISTED	Stock	0.221	0.2701	0.221	0.27	282865.0
2020-03-19	AAUAF-DELISTED	Stock	0.221	0.2701	0.221	0.27	296706.0
2020-03-19	AAWW-DELISTED	Stock	19.55	22.41	18.01	21.89	943951.0
2020-03-19	AAXJ	Stock	53.91	55.0	53.13	54.01	2132281.0
2020-03-19	AAXN-DELISTED	Stock	52.89	64.2514	52.2397	62.03	943623.0
2020-03-19	AB	Stock	14.5	20.1	13.24	19.3	2225500.0
2020-03-19	ABB-DELISTED	Stock	15.45	16.26	15.195	16.02	2858509.0
2020-03-19	ABBNY-DELISTED	Stock	15.45	16.26	15.195	16.01	3094095.0
2020-03-19	ABBV	Stock	69.1	74.85	65.33	71.06	19739900.0
2020-03-19	ABC-DELISTED	Stock	83.09	86.74	80.37	86.0	1869513.0
2020-03-19	ABCB	Stock	20.03	23.29	18.56	22.6	787200.0
2020-03-19	ABEO	Stock	42.75	49.5	42.75	44.5	46484.0
2020-03-19	ABEV	Stock	2.12	2.4	2.0	2.34	21856600.0
2020-03-19	ABG	Stock	43.78	52.57	39.36	48.98	531700.0
2020-03-19	ABM	Stock	24.63	26.02	21.86	24.06	630200.0
2020-03-19	ABMD-DELISTED	Stock	142.41	145.95	135.4602	140.68	679962.0
2020-03-19	ABR	Stock	4.45	5.07	3.8	4.48	5723300.0
2020-03-19	ABR.A-DELISTED	Stock	11.5	17.8	8.05	17.8	22872.0
2020-03-19	ABR.B-DELISTED	Stock	6.7	16.8599	6.01	15.0	23299.0
2020-03-19	ABR.C-DELISTED	Stock	12.63	17.3942	12.0	16.0	12158.0
2020-03-19	ABT	Stock	81.36	81.81	73.55	74.5	14476000.0
2020-03-19	ABTC	Stock	122700.0	140700.0	113400.0	130800.0	1.7066666666666668
2020-03-19	ABTS	Stock	15.0	15.0	13.5	14.4	1367.0
2020-03-19	ABTX-DELISTED	Stock	24.94	27.76	23.85	27.14	106298.0
2020-03-19	ABUS	Stock	1.21	1.86	1.2	1.75	1371300.0

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

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