PREVIEW / stock_daily / 2020-04-01

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-01.parquet
  size:    213 KB
  rows:    6,622
  symbols: 2,379

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-04-01	AAPL	Stock	61.625	62.18	59.7825	60.2275	176218400.0
2020-04-01	MSFT	Stock	153.0	157.75	150.82	152.11	57969900.0
2020-04-01	NVDA	Stock	6.3912	6.5382	6.032	6.0768	656912000.0
2020-04-01	AMZN	Stock	96.6485	97.248	94.65	95.385	82438000.0
2020-04-01	GOOGL	Stock	56.2	56.471	54.6745	55.105	51970380.0
2020-04-01	META	Stock	161.62	164.15	158.04	159.6	19507600.0
2020-04-01	TSLA	Stock	33.6	34.2633	31.6733	32.104	200298000.0
2020-04-01	TLT	Stock	168.48	168.96	166.4	167.04	11334698.0
2020-04-01	ES	Stock	75.5	77.18	75.0	75.99	2425700.0
2020-04-01	CL	Stock	64.75	65.85	64.09	65.55	4247700.0
2020-04-01	A	Stock	69.47	70.23	68.15	68.92	2173600.0
2020-04-01	AA	Stock	5.96	6.61	5.71	6.25	10452200.0
2020-04-01	AACG	Stock	0.95	1.01	0.94	0.95	1900.0
2020-04-01	AAIC-DELISTED	Stock	2.0	2.11	1.9	1.93	765524.0
2020-04-01	AAIC.C-DELISTED	Stock	12.6163	12.95	12.2	12.375	9441.0
2020-04-01	AAL	Stock	11.45	11.48	10.5	10.69	56854400.0
2020-04-01	AAM.A-DELISTED	Stock	23.0	23.0	21.21	21.66	30947.0
2020-04-01	AAM.B-DELISTED	Stock	22.9675	23.0	21.0	21.72	27210.0
2020-04-01	AAMC-DELISTED	Stock	4.2059	4.4265	3.9824	4.0735	25017.0
2020-04-01	AAME	Stock	2.11	2.15	2.11	2.15	600.0
2020-04-01	AAMI	Stock	6.01	6.31	5.91	5.99	533500.0
2020-04-01	AAOI	Stock	7.34	7.488	7.18	7.32	348900.0
2020-04-01	AAON	Stock	31.4067	31.9533	30.72	31.2533	390600.0
2020-04-01	AAP	Stock	89.63	92.7	87.12	89.17	1163400.0
2020-04-01	AAT	Stock	23.75	23.76	22.15	22.6	437500.0
2020-04-01	AAU-DELISTED	Stock	0.2836	0.2953	0.2609	0.2649	240370.0
2020-04-01	AAUAF-DELISTED	Stock	0.2836	0.2953	0.2609	0.2649	242695.0
2020-04-01	AAWW-DELISTED	Stock	24.56	25.7	23.55	24.02	464180.0
2020-04-01	AAXJ	Stock	58.04	58.36	57.07	57.07	2005431.0
2020-04-01	AAXN-DELISTED	Stock	67.58	69.67	63.7	64.9	493688.0
2020-04-01	AB	Stock	17.87	18.13	16.67	16.97	390500.0
2020-04-01	ABB-DELISTED	Stock	16.8	16.94	16.46	16.59	3407544.0
2020-04-01	ABBNY-DELISTED	Stock	16.8	16.94	16.46	16.59	3682572.0
2020-04-01	ABBV	Stock	72.12	73.99	71.43	73.42	12948000.0
2020-04-01	ABC-DELISTED	Stock	88.21	88.7125	84.185	86.23	1032094.0
2020-04-01	ABCB	Stock	22.43	23.09	21.75	22.54	433900.0
2020-04-01	ABEO	Stock	50.0	58.75	47.5	49.75	110912.0
2020-04-01	ABEV	Stock	2.25	2.3	2.22	2.25	29219600.0
2020-04-01	ABG	Stock	52.77	53.65	45.84	47.25	645300.0
2020-04-01	ABM	Stock	23.99	24.12	22.76	23.36	530100.0
2020-04-01	ABMD-DELISTED	Stock	140.95	147.37	140.14	144.37	536250.0
2020-04-01	ABR	Stock	4.63	4.67	4.39	4.55	2585700.0
2020-04-01	ABR.A-DELISTED	Stock	16.05	16.05	13.82	14.3	14465.0
2020-04-01	ABR.B-DELISTED	Stock	14.39	14.7	12.12	12.3197	5249.0
2020-04-01	ABR.C-DELISTED	Stock	14.49	14.88	13.39	13.7	13901.0
2020-04-01	ABT	Stock	77.0	77.38	75.35	76.57	12208300.0
2020-04-01	ABTC	Stock	150000.0	182100.0	144000.0	162600.0	6.733333333333333
2020-04-01	ABTS	Stock	11.25	14.85	9.3	11.58	267.0
2020-04-01	ABTX-DELISTED	Stock	23.08	23.88	21.93	22.26	85761.0
2020-04-01	ABUS	Stock	1.01	1.08	0.96	1.06	981900.0

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

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